90.2K

Verified Solution

Link Copied!

Answer correct.

Create 2NF and 3NF tables based on the following 1NF table, and underline the primary keys in the tables. You must label the tables clearly, Project Name Employee Name Job Class Hourly Charge Hours Project Number 1001 1001 1001 1002 1002 1002 1002 1003 1003 Star Trek Star Trek Star Trek Ash Tray Ash Tray Ash Tray Ash Tray Upside Down Upside Down Employee Number 103 101 106 114 103 118 112 118 101 Arbough News Johnson Jones Arbough Frommer Smith Joenbrood News Elect. Engineer DB Designer Programmer Clerical Support Elect. Engineer Sys. Analyst Programmer App. Designer DB Designer $85.60 $107.00 $56.00 $26.56 $85.60 $96.75 $56.00 $48.70 S107.00 24.6 19.4 67.5 22.0 15.9 32.6 41.4 23.8 35.6 Create 2NF and 3NF tables based on the following 1NF table, and underline the primary keys in the tables. You must label the tables clearly, Project Name Employee Name Job Class Hourly Charge Hours Project Number 1001 1001 1001 1002 1002 1002 1002 1003 1003 Star Trek Star Trek Star Trek Ash Tray Ash Tray Ash Tray Ash Tray Upside Down Upside Down Employee Number 103 101 106 114 103 118 112 118 101 Arbough News Johnson Jones Arbough Frommer Smith Joenbrood News Elect. Engineer DB Designer Programmer Clerical Support Elect. Engineer Sys. Analyst Programmer App. Designer DB Designer $85.60 $107.00 $56.00 $26.56 $85.60 $96.75 $56.00 $48.70 S107.00 24.6 19.4 67.5 22.0 15.9 32.6 41.4 23.8 35.6

Answer & Explanation Solved by verified expert

See Answer