Question
HOW TO MAKE UNF, 1NF, 2NF, 3NF (with PKs/FKs) AND LOGICAL ER diagram for following INVOICE with the Requirements below:- Please let me know Normalization
HOW TO MAKE UNF, 1NF, 2NF, 3NF (with PKs/FKs) AND LOGICAL ER diagram for following INVOICE with the Requirements below:-
Please let me know Normalization results (UNF, 1NF, 2NF and 3NF) plus the corresponding logical ER diagrams drawn from the 3NF using Visio 2016 (UML notation).
1. Normalization result must be stated in RELATION SCHEMA format, showing UNF, 1NF, 2NF and 3NF separately and progressively. Include ALL derived attributes starting in UNF. 2. For each normal form, state the normal form objective (i.e. definition of the normal form in terms of functional dependency), and the corresponding problems / issues to be resolved by decomposition. Note: Broad normal form objective and issue, NOT specific columns in the current context. 3. For each relation in each of 1NF, 2NF & 3NF, identify the primary key (with underline), and foreign keys (labeled with [FK] suffix) as appropriate. 4 Draw the corresponding logical ER diagram from each 3NF, using Visio 2016 UML notation, in pure Black & White. Copy & paste diagrams into Word docx as objects (not bitmap images) for printing. 5. Where necessary, state in point form, any business rules / assumptions made during the normalization process, as they affect your design choices and decisions. Do not include irrelevant assumptions. ** Remember ** An assumption in this context is NOT any different possibilities that can be, but that when a column can be interpreted in more than one way, which one interpretation you have decided to go with in your work. Of course, you cannot make assumptions which contradict the given information.
For Q.1 Invoice: Qty Ord = Quantity ordered [as recorded in the original customer order]. Qty Ship = Quantity shipped [quantity included in current shipping package]. Qty BkOrd = Quantity Back-ordered [quantity not yet shipped due to insufficient stock, and back-ordered]. Unit Price = Product item price for the current order and 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.00Step 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