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.

You should include the following attributes: - CustID for the [Bill To] Customer - EmpID for the employee [Salesperson] - ProdID for the Product - ShipID for the [Ship Via] Shippers

Order (An Order Entry Form) [25 marks: 5 marks per UNF, 5 marks per INF, 2NF, 3NF (with PKs/FKs), and 5 marks for logical ER diagram] Orders Order ID Order Date: 2019-01-30 equired Date: 2019-02-13 Shipped Date: 2019-02-07 10431 Bottom-Dollar Markets 23 Tsawassen Blvd Bill To: Ship To: Bottom-Dollar Markets 23 Tsawassen Blvd l sawassen BC T2F 8M4 l sawassen BC T2F 8M4 Canada Ship Yia Canada Federal Extended Price Salesperson Peacock, Margaret Speedy United Quantity Discount 30 50 20 Product -Unit PriceQ Zaanse koeken Boston Crab Meat Alice Mutton $7.60 $14.70 $31.20 0% 25% 5% $228.00 $551.25 $592.80 Subtotal: Freight Total: $1.372.05 $44.17 Print Invoice $1,416.22 Order (An Order Entry Form) [25 marks: 5 marks per UNF, 5 marks per INF, 2NF, 3NF (with PKs/FKs), and 5 marks for logical ER diagram] Orders Order ID Order Date: 2019-01-30 equired Date: 2019-02-13 Shipped Date: 2019-02-07 10431 Bottom-Dollar Markets 23 Tsawassen Blvd Bill To: Ship To: Bottom-Dollar Markets 23 Tsawassen Blvd l sawassen BC T2F 8M4 l sawassen BC T2F 8M4 Canada Ship Yia Canada Federal Extended Price Salesperson Peacock, Margaret Speedy United Quantity Discount 30 50 20 Product -Unit PriceQ Zaanse koeken Boston Crab Meat Alice Mutton $7.60 $14.70 $31.20 0% 25% 5% $228.00 $551.25 $592.80 Subtotal: Freight Total: $1.372.05 $44.17 Print Invoice $1,416.22