3.2 Use the reduction techniques you leared in Chapter 12 to map the following ER diagram to relational schemas. (4 points) Department Employee dnumber (PK) emp_id (PK) Works in 1... name name phone[1..3] fname Iname phone address 3.3 Fill in the table below to indicate the foreign keys in the schemas you obtained in the previous step, the schemas where they are located, the primary keys tha correspond to these foreign keys, and the schemas where they are located: (2 points) Foreign Key Primary key Schema of Foreign Schema of Prima 7 Figure 5.6 One possible database state for the COMPANY relational database schema EMPLOYEE Frame Mint John B Franklin T Alicia Jennifer S Ramesh Joyce Ahmad V James E Lame San Bdate Address Sex Salary Superman Deo Smith 123456780 1065-01-09 731 Fonden, Houston, TX M 30000 333445555 5 Wong 333445555 1955-12-08 638 Vous Houston, TX M 40000 B88665555 Zelaya 999887777 1968-01-19 3321 Castle Spring. TX F 25000 087654321 4 Watce0876543211941-06-20 291 Berry. Belaire. TX F43000 888665566 4 Narayan 666884444 1062-09-15 975 Fire Oak, Humble. TX M 39000 333445555 5 English 453453453 1972-07-31 5631 Rice, Houston, TX F25000 333445555 5 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TXM 25000 987654321 4 Borg 888666555 1927-11-10450 Stone Houston, TX M 65000 NULL 1 DEPARTMENT Drame Research Administration Headquarters Dnumber 5 More 333445555 987654321 888665555 Mor_start date 1988-05-22 1995-01-01 1981-06-10 DEPT LOCATIONS Denumber Dlocation 1 Houston Stafford 5 Bellare Sugarland 6 Houston + Hous Pumber Drum 1 Pro 1 2 3 1 2 32.5 75 40.0 PROJECT Prame ProductX Product Product Computerization Reorganization Newbenefits Plocation Bere Sugarland Houston Stafford Houston Stafford 5 5 5 4 3 10 20 30 200 200 10.0 1 4 2 WORKS ON Esan 123456700 123456789 666884444 453453453 453453453 333445555 333445555 333445656 333445555 999887777 999887777 987987907 987987987 987654321 987654321 888666655 10.0 10.0 Sex F 10 20 30 10 10 30 30 20 20 % % % % 88% 88 DEPENDENT EN 333445555 333445555 333445555 987654321 123456789 123456789 123456789 100 30.0 100 350 50 200 15.0 NULL M F Dependent.name Alice Theodore Joy Abner Michael Alice Elizabeth M Bate Relationship 1906-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-20 Spouse 1988-01-06 Son 1988-12-30 Daughter 1967-05-05 Spouse M F F