Assignment Instructions:

• Create a logical database design for the construction company data in the attached Excel file.
• Your logical design must be in Third Normal Form (3NF).
• Document your logical design using SQL Create Table statements as shown in Figure 4-6 on page 162 of the textbook.

| PROJ_NUM PROJ_NAME 15 Evergreen 2 + UI UI 7 18 Amber Wave 3 1 22 Rolling Tide EMP_NUM EMP_NAME 103 June E. Arbough 101 John G. News 105 Alice K. Johnson 106 William Smithfield 102 David H. Senior 114 Annelise Jones 118 James J. Frommer 104 Anne K. Ramoras 112 Darlene M. Smithson 105 Alice K. Johnson 104 Anne K. Ramoras 113 Delbert K. Joenbrood 111 Geoff B. Wabash 106 William Smithfield 107 Maria D. Alonzo 115 Travis B. Bawangi 101 John G. News 114 Annelise Jones 108 Ralph B. Washington 118 James J. Frommer 112 Darlene M. Smithson JOB_CLASS Elect. Engineer Database Designer Database Designer Programmer Systems Analyst Applications Designer General Support Systems Analyst DSS Analyst Database Designer Systems Analyst Applications Designer Clerical Support Programmer Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst CHG HOUR HOURS 84.5 23.8 105 19.4 105 35.7 35.75 12.6 96.75 23.8 48.1 24.6 18.36 45.3 96.75 32.4 45.95 44 105 64.7 96.75 48.4 48.1 23.6 26.87 22 35.75 12.8 35.75 24.6 96.75 45.8 105 56.3 48.1 33.1 96.75 23.6 18.36 30.5 45.95 41.4 6 25 Starflight w No 6000