Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Accidental Data Scientist

Authors: Amy Affelt

1st Edition

1573877077, 9781573877077

More Books

Students also viewed these Databases questions

Question

=+ How can this information be obtained from them?

Answered: 1 week ago