Question: Does this data set need to be normalized? What is its 3NF? Please design the new database. Purchase order # Purchase Date Item Purchased Item
Does this data set need to be normalized? What is its 3NF? Please design the new database.
| Purchase order # | Purchase Date | Item Purchased | Item Desc | Unit Price | Quantity | Vendor | Vendor # | Vendor Phone | Purchased by | Employee ID | Office Phone |
| 1 | 3/3/2018 | AAA | Equitment | $300 | 10 | ABC Corp | A1 | 111-222-3333 | JACK | 2 | 9802 |
| 1 | 3/3/2018 | BBB | Equitment | $402 | 20 | ABC Corp | |||||
| 2 | 1/1/2018 | CCC | Supply | $12 | 30 | DEF Corp | B1 | 888-123-456 | TOM | 3 | 9803 |
| 2 | 1/1/2018 | DDD | Equitment | $405 | 10 | DEF Corp | |||||
| 3 | 2/14/2018 | EEE | Supply | $76 | 5 | DEF Corp | JACK | 2 | 9802 | ||
| 4 | 12/1/2018 | FFF | Equitment | $180 | 4 | GHI Corp | C1 | 713-000-1111 | EMMA | 4 | 9804 |
| 5 | 7/18/2018 | GGG | Computer | $2,000 | 1 | GHI Corp | EMMA |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
