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).

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- id address no date hand name no date name name John Duster South 1001 St Paul 1001 St Paul 1001 St Paul Ao01 VollzoDoo1 6 Vollzo Doo1 2 Randste Doo2 2 Vollzo Doo 8Happag Doo 0001 Duster South John Duster South Marion Jones Marion Jones Marion Jones Marion Jones 0001 Aoo2 08-09- 2016 0001 Aoo38/15/2016 1004 St Paul St 1004 St Paul St 1004 St Paul St 1004 St Paul St 1008 St Paul St 1008 St Paul St North Aoo2 09-01- 201 North Aoo5 o9-12-201 04-01 201 North Aoo6 12 Panaso Doo 09-01- 201 08-01 2016 North Ao07 03-12-2016 23Whirl 08-08- 2016 Doo 0 0008 Dawson East Aoo8 SMC Doo6 09-06 2016 0008 Dawson East Aoo7 2016 20 Whirl Doo6 1008 St Paul St o6-06 201 0008 Dawson East Sample Table A010 06-12-201 8 Paul Inc Doo8 10 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 LNAME, EMP EDUCATION, JOB_CLASS, EMP BASE SALARY, EMP COMMISSION RATE) The dependencies shown as: EMP CODEemp_Iname, emp_education, job_class.... Partial Dependencies No Partial Dependencies Transitive Dependencies JOB CLASS emp_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. (2o points) 2. 3. Draw the ER Diagram. (20 points)