Complete the Normalization problems below. The final product must be your own work. In your solution, show the Initial Grouping, INF, 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, gty- manager- manager warehouse- warehouse part inventory-nsupplier- deliverydeliverydelivery- id address 1001 St Paul no date hand name no date ohn 1001 St Paul St 1001 St Paul St 004 St ohn Duster South Aoo2 7/23/201 o001 Duster South ADO 016 2 Randste Do02 2016 o001 20 Aoo2 Marion ones 004 St Paul St North 12-2 8 1004 St ones North AD06 20 12 Panaso Doo 20 004 St ones North 03-12-2016 23 Whi Doo 201 Hugh 008 St AOC Hugh 1008 St 09-12- Hugh Dawson East 1008 St Paul St o6-D6- mg 0008 AD10 06-12-201:3 8 Paul Inc Do08 Sample Table 1. List the primary key(s) and list all transitive and/or partial dependencles for the WAREHOUSE relation. (1o points) 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 dependencles shown as: EMPCODE empname, empeducation, jobclass Partial Dependencies . ---- No Partial Dependencies JOB CLASS-> emp base_salary