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

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