1. Engineering
  2. Computer Science
  3. figure 142 book relation db sample database state for a...

Question: figure 142 book relation db sample database state for a...

Question details

Figure 14.2 (book): relation DB Sample database state for a simplified COMPANY EMPLOYEE Ename Bdate Address Dnumber Smith, John B. Wong, Franklin T.3334455551955-12-08 638 Voss, Houston, TX Zelaya, Alicia J Wallace, Jennifer S. 9876543211941-06-20 291 Berry, Bellaire, TX Narayan, Ramesh K 6668844441962-09-15 975 Fire Oak, Humble, TX English, Joyce A. 453453453 1972-07-31 5631 Rice, Houston, TX Jabbar, Ahmad V Borg, James E. DEPARTMENT 123456789 1965-01-09 731 Fondren, Houston, TX 5 9998877771968-07-19 3321 Castle, Spring, TX 5 5 987987987 1969-03-29 980 Dallas, Houston, TX 888665555 1937-11-10 450 Stone, Houston, TX DEPT LOCATIONS Dnumber Dmgr ssn Dname Research Administration Headquarters Dnumber Dlocation 333445555 987654321 888665555 Houstorn Stafford Bellaire Sugarland Houstorn 5 5 WORKS ON PROJECT Pnumber Hours 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 Pnumber Plocation Dnum ProductX Product)Y Productz Computerization 10 Reorganization Bellaire Sugarland 5 Houston Stafford Houston Stafford 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 5 3 4 30 3 10 20 30 10 30 30 20 20

Fig 4.1: DEPARTMENT_PROJECT DB schema suffering from update anomalies Dnumber Pnumber Dname |Dmgr_ssn Pname Plocation FD1 FD2 FD3

Fig 4.2: A database state of the DEPARTMENT_PROJECT DATABASE derived from Fig 14.2 DNUMBER PNUMBER DNAME DMGR SSN PNAME PLOCATION 3 10 5 20 5 30 Research 333445555 ProductZ Hoston Research 333445555 Computerize Stafford Research 333445555 Reorganize Houston Research 333445555 Nbenefits Stafford Research 333445555 ProductXBellair Research 333445555 Product Sugarland Administration 987654321 Productz Houston Administration 987654321 Computerize Stafford Administration 987654321Reorganize Houston Administration 987654321 Nbenefits Stafford Administration 987654321 ProductXBellair Administration 987654321ProductYSugarland Headquarters 888665555 ProductZ Houston Headquarters 888665555 Computerize Stafford Headquarters 888665555 ReorganizeHouston Headquarters 888665555 Nbenefits Stafford Headquarters 888665555 ProductXBellair Headquarters 888665555ProductYSugarland 4 4 4 4 4 4 3 10 20 30 3 10 20 30 18 rows selected

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution