Get a Freelance Job

Please see the attached.

Part One

Using the same Kudler Fine Foods Database and Tables as well as building off all previous code:

Note. Select all data from both tables and produce a screen shot of each before and after you perform each item on the list below:

1. Increase all employees’ salaries with the selected EEO-1 classification by 10%.

2. Increase all employees’ salaries by 5%.

3. Choose an employee from the Employee table and delete that employee.

4. Calculate the average salary for all employees.

5. Calculate the maximum salaries for exempt and non-exempt employees.

6. Calculate the maximum salary for all employees.

7. Calculate the minimum salaries for exempt and non-exempt employees.

8. Calculate the minimum salary for all employees.

Otherwise, just stick to everything else we have been doing previously such as code documentation, screen shots, etc.

Write SQL statements to perform the following:

Using the SQL CREATE statement, create the following two tables using the following fields:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.

Kudler Fine Foods is a

Kudler Fine Foods is a

I need a SQL database completed in Express 2008. The details are as follows and it must be completed by Saturday the 25th:

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

–Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = “C:POS410MyStuffCase_KudlerDB_dat.mdf”,
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)

–Comment goes here
LOG ON
(NAME=”Case_KudlerDB_log”,
FILENAME=”C:POS410MyStuffCase_KudlerDB_log.ldf”,
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)

(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)