Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started