314259 Employee Database SQL

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:\POS410\MyStuff\[login to view URL]", SIZE = 10MB, MAXSIZE = 100MB FILEGROWTH = 10%) --Comment goes here LOG ON (NAME="Case_KudlerDB_log", FILENAME="C:\POS410\MyStuff\[login to view URL]", 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.) • Create the following two tables using the following fields: • Note: Comment all your code. An example comment would look like the following: --Comment goes here CREATE TABLE [EmployeeDB].[login to view URL] ( EmpID char (6) CONSTRAINT custNoKey PRIMARY KEY Not Null, EmpeeLName char (25) Not Null, EmpeeFName char (20) Not Null, • 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. Table 1 Employee • Employee ID • Last name • First name • Address • City • State • Telephone area code • Telephone number • Employer Information Report (EEO-1) classification • Hire date • Salary • Gender • Age • Foreign key from Job Title table Table 2 Job_title • EEO-1 classification • Job title • Job description • Exempt/non-exempt status • Use the SQL INSERT statement to insert records from the Human Resources department in the Kudler Fine Foods Virtual Organization. Using information found in the Employee Files for the La Jolla and Encinitas stores, enter records into the Employee table for the following employees: o Glenn Edelman o Eric McMullen o Raj Slentz o Erin Broun o Donald Carpenter o David Esquivez o Nancy Sharp • Use the Job classifications and descriptions information to enter records into the Job Title table for the following titles: o Accounting clerk o Assistant manager o Bagger o Cashier o Computer support specialist o Director of finance and accounting o Retail assistant bakery and pastry o Retail assistant butchers and seafood specialists o Stocker • Check results by selecting all columns from both tables. Non-exempt employees at Kudler Fine Foods are paid an hours wage and must track their working hours. • Screen Shot – take screen shots of your successful implementation of your code and submit as attachments. • Save your SQL in a txt file in Notepad and submit as an attachment in your individual forum. Data Dictionary (You will be submitting your updated data dictionary each week and with your final project submission) • Note: Create a data dictionary in order to identify the contents of your database, the keys that connect the tables and the tables that are connected by the keys. Create this data dictionary in MS Excel or similar spreadsheet program or in a table in MS Word or similar word processing program. Use the following column labels to fill the data dictionary: • Table Name • Column Name • Data Type • Data Length • Nullable (Yes/No) • Primary Key • Foreign Key (if any) • Table connected by key • Comments