PROJ_NUM PROJ_NAME JOB_CLASS Elect. Engineer CHG HOUR HOURS EMP_NUM EMP_NAME June E. Arbough 15 Evergreen 103 84.5 23.8 101 John G. News Database Designer 105 19.4 105 Alice K. Johnson Database...



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

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

Jun 11, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?