Question: Using the table below, turn it into a set of fully normalized relations up to 3NF. Show all intermediate relations, keys, and functional dependencies. State
Using the table below, turn it into a set of fully normalized relations up to 3NF. Show all intermediate relations, keys, and functional dependencies. State any assumption you make about the data (if necessary).
| 121 Holdings, Inc. INVOICE Name: Alfred Vargas Mobile: 09098765432 Invoice No: 100001 Address: Clark, Pampanga Date Issued: October 30, 2019 | |||||||||
| Product Code | Product Name | Product Color | Order Number | Date Ordered | Quantity Ordered | Quantity Delivered | Date Delivered | Unit Price | Total Amount |
| FX123 | Flower Stand | Pink | 001 | 11/12/21 | 2 | 2 | 11/12/21 | 200 | 400.00 |
| DA001 | Dishwasher | Red | 1 | 1 | 11/14/21 | 550 | 550.00 | ||
| GD923 | Gardening Tools | 002 | 11/22/21 | 4 | 3 | 11/22/21 | 120 | 360.00 | |
| DA001 | Dishwasher | Blue | 2 | 1 | 11/22/21 | 550 | 550.00 | ||
| GD923 | Gardening Tools | 003 | 11/27/21 | 6 | 4 | 12/01/21 | 120 | 480.00 | |
| Total | 2.340.00 | ||||||||
| Discount | 0.00 | ||||||||
| Amount to pay | 2,340.00 | ||||||||
Assumptions:
- An invoice contains items associated with different orders by the same person
- The quantity delivered is not always equal to the quantity ordered.
- Product of the same code may have different colors.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
