employee emp_ssn emp_last_name emp_first_name emp_middle_name emp_address emp_city emp_state emp_zip emp_date_of_birth emp_salary emp_parking_space emp_gender emp_dpt_number emp_superssn 999111111 Bock Douglas B #2 Mont Verd Dr. St. Louis MO 63121 12/5/1950 $30,000.00 542 M 7 999444444 999222222 Amin Hyder S. Seaside Apt. B Marina CA 93941 3/29/1969 $25,000.00 422 M 3 999555555 999333333 Joshi Dinesh #10 Oak St. Collinsville IL 66234 9/15/1972 $38,000.00 332 M 7 999444444 999444444 Zhu Waiman Z 303 Lindbergh St. Louis MO 63121 12/8/1975 $43,000.00 32 M 7 999666666 999555555 Joyner Suzanne A 202 Burns Farm Marina CA 93941 6/20/1971 $43,000.00 3 F 3 999666666 999666666 Bordoloi Bijoy South Main #12 Edwardsville IL 62025 3/14/1954 $55,000.00 1 M 1 999887777 Markis Marcia M High St. #14 Monterey CA 93940 7/19/1978 $25,000.00 402 F 3 999555555 999888888 Prescott Sherri C Overton Way #4 Edwardsville IL 62025 7/31/1972 $25,000.00 296 F 7 999444444

assignment work_emp_ssn work_pro_number work_hours work_hours_planned 999111111 1 31.4 35 999111111 2 8.5 10.2 999222222 10 34.5 42.3 999222222 30 5.1 11.8 999333333 3 42.1 65 999444444 1 999444444 2 12.2 15.5 999444444 3 10.5 30 999444444 10 10.1 10.5 999444444 20 11.8 10.2 999555555 20 14.8 999555555 30 19.2 18.3 999666666 20 15.5 999887777 10 10.2 15 999887777 30 30.8 25.5 999888888 1 21 20 999888888 2 22 20

ER Diagram
(Not exactly VISIO-compliant)

ER Diagram Drawn by
SQL SERVER 2008

Table Structures

Tables Filled with Data

FK

FK

department dpt_no dpt_name dpt_mgrssn dpt_mgr_start_date 1 Headquarters 999666666 6/19/1981 3 Admin and Records 999555555 1/1/2001 7 Production 999444444 5/22/1998
dept_locations dpt_no dpt_location 1 Edwardsville 3 Marina 7 Collinsville 7 Edwardsville 7 St. Louis
project pro_number pro_name pro_location pro_dept_number 1 Order Entry St….