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:

  1. An invoice contains items associated with different orders by the same person
  2. The quantity delivered is not always equal to the quantity ordered.
  3. Product of the same code may have different colors.

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!