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

 

Transcribed Image Text:

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 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