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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!