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) manager- manager- warehouse- warehouse- part inventory- on- supplier- devery delivery delivery- id no date hand name date 1001 St Paul 1001 St Paul 1001 St Paul Vollzo Doo 2016 6 Vollzo Doo1 2016 10 John south 1004 2016 2 Randste Doo2 Marionh1004 004 St Paul St 9-01 201 Jones North 12-2 Marion 04-01- 004 St Paul St 1008 St 9-01 201 North 03-12-2016 08-08- Jones 3 Whirl Hugh SMC Hugh Dawson East 1008 St Paul St 09-12- 0008 A007 2016 20 Whirl Doo6 2016 1008 St Paul St Dawson East Sample Table 8 Paul IncDoo8 0008 Ao1 06-12-201 201 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, 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 _dass.... Partial Dependencies No Partial Dependencies Transitive Dependencies JOB 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. (2o points) 2. 3. Draw the ER Diagram. (20 points)