ONLY NEED NO. 2

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 warehouselis 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, manager-manager warehouse- warehouse- part- inventory- on supplier- delivery- delivery delivery- id no date hand name no date Duster South John Duster South 1001 St Paul St 1001 St Paul Vollzo Doos 2016 6 Voll Doos 016 1001 St Paul St 1004 St Paul St 1004 St Paul St Duster South 2016 Aooz VollzO Marion 09-01- Marion 1004 St Paul St 1004 St Paul St 1008 St Paul St 12 Panaso Marion Hugh Dawson East 08-01- oo08 Aoo8 2016 1008 St Paul St 09-12 0008Hugh o Whirl 6 2016 Dawson East 1008 St Paul St 0008 Hugh Dawson East Sample Table A010 06-12-201 8 Paul Inc D008 1. List the primary key(s) and list all transitive and/or partial dependencies for the WAREHOUSE relation. (1o points) WAREHOUSE (manager-id, manager-name, warehouse-name, warehouse-address, part-no Example: Relational Schema EMPLOYEE EMP CODE, EMP LNAME, EMP EDUCATION, JOB CLASS, The dependencies shown as: EMP-CODE emp Partial Dependencies EMP BASE SALARY, EMP COMMISSION RATE) Iname, emp _education, job_clas.... No Partial 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 criteriaj 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. (z0 points) 2