Create the four tables EMP, DEPT, PROJ, EMP_PROJ with the appropriate constraints except for FOREIGN KEY constraints.

 

EMP Data empNo fname Iname address sex salary position deptNo 1000 Steven King 731 Fondren, Houston, TX M 30000 Programmer 60 1007 Diana Lorentz 638 Voss, Bellaire, TX F 24000 Clerk 20 2002 Pat Fay 3321 Castle, Spring, TX F 15000 Sales Representative 80 1760 Jonathan Taylor 561 Rice, Houston, TX M 60000 Manager 20 1740 Ellen Abel 890 Stone, Houston, TX F 65000 Manager 60 2060 William Gietz 450 Berry, Bellaire, TX M 65000 Manager 80 2000 Jennifer Whalen 1444 Peter 980 Fire Oak, Humble, TX Vargas 975 Dallas, Houston, TX F 28000 Clerk 60 M 20000 Sales Representative 80 DEPT Data deptNumber deptName Mgr 20 Marketing 1760 60 IT 1740 80 Sales 2060 PROJ Data projNumber projName deptNum 10 Product X 20 20 224 Product Y 20 30 Computerization 60 40 Product Z 80 50 Mobile Apps 60 EMP_PROJ Data empNo projNo hoursWorked 1000 30 32.5 1000 50 7.5 2002 10 40.0 1444 20 20.0 1760 10 5.0 1760 20 10.0 1740 50 15.0 2060 40 12.0