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:-

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
Get step-by-step solutions from verified subject matter experts
