Complete the Normalization problems below. The final product must be your own work. In your solution, show the Initial Grouping, 1NF, Dependency Diagram, 2NF, and 3NF. When appropriate, be sure to identify all functional dependencies (both partial and transitive). WAREHOUSE The warehouse database stores inventory information. A warehouse has one manager who has an employee number (unique) and a name. A warehouse is identified by its warehouse name (unique) and its address. Every part in the warehouse has a part number (unique), inventory date, quantity-on- hand, supplier name (one), and the delivery number, data, and quantity. One delivery could deliver several parts. The data is shown below: WAREHOUSE (manager-id, manager-name, warehouse-name, warehouse-address, part-no, inventory-date, qty-on-hand, supplier-name, delivery-no, delivery-date, delivery-qty) qty- manager- manager- warehouse warehouse- part inventory- on- supplier- delivery- delivery delivery- address 1001 St Paul no date hand name no date name John Duster South John Duster South John Duster South Marion A001 VollzoDoo1 6 Vollzo Doo1 2 Randste Doo2 2 Vollzo Doo 8Happag Doo 0001 201 1001 St Paul 0001 A002 201 201 10 1001 St Paul 08-09- 0001 Aoo38/15/2016 2016 20 004 St Paul St 1004 St Paul St 1004 St Paul St 1004 St Paul St 1008 St Paul St 1008 St Paul St North A002 26/201 20/201 Marion 09-01- 201 North A005 09-12-201 04-01 201 Marion North Aoo6 12 Panaso Doo 201 09-01- 201 08-01 2016 20 Marion North Ao07 03-12-2016 23Whirl 08-08- 2016 Doo 0 0008 Dawson East Aoo8 SMC Doo6 6 09-06 2016 09-12 0008 Dawson East Aoo7 2016 20 Whirl Doo6 Hugh Dawson EastPaul St A010 06-12-2013 8 Paul IncD008201 1008 St 06-06- 0008 Sample Table List the primary key(s) and list all transitive and/or partial dependencies for the WAREHOUSE relation. (10 points) 1. WAREHOUSE (manager-id, manager-name, warehouse-name, warehouse-address, part-no, inventory-date, qty-on-hand, supplier-name, delivery-no, delivery-date, delivery-qty) Example: Relational Schema EMPLOYEE(EMP CODE, EMP_LNAM CLASS, E, EMP EDUCATION, JoB EMP_BASE_SALARY, EMP_COMMISSION_RATE) The dependencies shown as: EMP-CODE emp-name, emp-education, job-class Partial Dependencies . No Partial Dependencies Transitive Dependencies OB CLASSemp base_salary Convert the relation to 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes and that the naming conventions are met.) Write the corresponding relational schemas. Identify each primary key and each foreign key. (20 points) 2. 3. Draw the ER Diagram. (20 points)