Assignment Given the blank order form, order form with data, and sample data, create the 3NF relations needed to store this data in a relational database. You should follow the normalization process listed below. Your solution should include: -All non-aggregated data from the order form - Each relation should have a primary key - Include the foreign keys necessary to create the appropriate relationships Your solution should list: - The relational notation for all relation schemas R(A,B,C,D,E) - For each relation, list all functional dependencies using the notation: FD1 (A,B) -> C,D,E CS 420 Order Form Normalization Order Form Order Number Order Date Customer Name: Street Address: City: State: Zip Code: Customer Phone Number: Description Quantity Price Subtotal OrderLine Product # 1 2 3 4 5 6 7 8 9 Total Order Form Order Number 101 Order Date 3/17/2017 Customer Name: ACME, Inc. Street Address: 123 Front St City: Ellensburg StateisssssssssWA Zip Code: 98926 Customer Phone Number: 509-555-1212 Price Description Quantity Widgets 4 Thingamajigs 4 20 Subtotal 80 88 22 OrderLine Product # 1 1 2 2 3 4 5 6 7 8 9 Total 168 Sample Data Order Number Order Date Customer Name City Product# 101 3/17/2017 ACME, Inc 1 Street Address State Zip Phone 509-555- 123 Front St Ellensburg WA 98926 1212 456 Second 509-555- St Ellensburg WA 98926 9999 206-555- 5 Third St Seattle WA 98101 1111 509-555- 123 Front St Ellensburg WA 98926 1212 102 3/30/2017 ABC Corp 2 103 4/4/2017 XYZ, LLC 4 104 4/5/2017 ACME, Inc 4 Sample Data (columns to the right of the above table) Description Quantity Price Product# Description Quantity Price Product# Description Widgets 4 20 2 Thingmajigs 22 Thingmajigs 5 22 4 Cups 2 30 3 Dohickey Cups 2 Thingmajigs 22 1 Widgets Cups 5 Straws 2 Thingmajigs 4 14 30 12 2 30 100 2 Sample Data (columns to the right of the above tables) Quantity Price Product# Description Quantity Price 2 4 122 20 5 Straws 100 2 4 22