Question: What is the the normalization results in Relation schema (UNF, 1NF, 2NF and 3NF) plus the corresponding logical ER diagrams drawn from the 3NF using

What is the the normalization results in Relation schema (UNF, 1NF, 2NF and 3NF) plus the corresponding logical ER diagrams drawn from the 3NF using Visio 2016 (UML notation).

for the following Invoice:-

What is the the normalization results in Relation schema (UNF, 1NF, 2NF

Invoice (A simple Invoice Report to accompany a shipping package) [25 marks : 5 marks per UNF, 5 marks per INF, 2NF, 3NF (with PKs/FKs), and 5 marks for logical ER diagram] Invoice Customer No: C012345 Name: Contemporary Design Address: 456 Willingdon Avenue Invoice No: I034567 Date: 2019-02-20 Order No: 0076543 Burnaby, BC V3V 2A2 Qty Qty Qty Unit Tot Ord ShipBkOrd Product Description P1256679 CVP Color Monitor P0077901 HP Color Laser Printer P0077909Color Toner Cartridge Price Price 120.00 400.00 150.00 240.00 400.00 300.00 Total Amount Discount Amount Due $940.00 40.00 $900.00 Invoice (A simple Invoice Report to accompany a shipping package) [25 marks : 5 marks per UNF, 5 marks per INF, 2NF, 3NF (with PKs/FKs), and 5 marks for logical ER diagram] Invoice Customer No: C012345 Name: Contemporary Design Address: 456 Willingdon Avenue Invoice No: I034567 Date: 2019-02-20 Order No: 0076543 Burnaby, BC V3V 2A2 Qty Qty Qty Unit Tot Ord ShipBkOrd Product Description P1256679 CVP Color Monitor P0077901 HP Color Laser Printer P0077909Color Toner Cartridge Price Price 120.00 400.00 150.00 240.00 400.00 300.00 Total Amount Discount Amount Due $940.00 40.00 $900.00

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!