Show how the MVDS Ename Pname and Ename Dname in Figure 14.15(a) may arise during normalization...

 

   

Transcribed Image Text:

Show how the MVDS Ename Pname and Ename Dname in Figure 14.15(a) may arise during normalization into 1NF of a relation, where the attributes Pname and Dname are multivalued. (а) EMP LOCS Ename Figure 14.5 Particularly poor design for the EMP_PROJ relation in Figure 14.3(b). (a) The two relation schemas EMP_LOCS and EMP PROJ1. (b) The result of projecting the exten- sion of EMP PROJ from Figure 14.4 onto the relations EMP LOCS and EMP_PROJ1. Plocation P.K. EMP PROJ1 Ssn Pnumber Hours Pname Plocation P.K. (b) EMP LOCS EMP PROJ1 Pnumber Hours Ename Smith, John B. Plocation Ssn Pname Plocation Bellaire 123456789 32.5 ProductX Bellaire Smith, John B. Sugarland 123456789 2 7.5 ProductY Sugarland Narayan, Ramesh K. Houston English, Joyce A. English, Joyce A. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Zelaya, Alicia J. Jabbar, Ahmad V. Wallace, Jennifer S. Stafford Wallace, Jennifer S. Houston Borg, James E. 666884444 3 40.0 ProductZ Houston Bellaire 453453453 1. 20.0 ProductX Bellaire Sugarland 453453453 2 20.0 ProductY Sugarland Sugarland 333445555 10.0 ProductY Sugarland Houston 333445555 3 10.0 ProductZ Houston Stafford 333445555 10 10.0 Computerization Stafford Stafford 333445555 20 10.0 Reorganization Houston Stafford 999887777 30 30.0 Newbenefits Stafford 999887777 10 10.0 Computerization Stafford 987987987 10 35.0 Computerization Stafford Houston 987987987 30 5.0 Newbenefits Stafford 987654321 30 20.0 Newbenefits Stafford 987654321 20 15.0 Reorganization Houston 888665555 20 NULL Reorganization Houston Show how the MVDS Ename Pname and Ename Dname in Figure 14.15(a) may arise during normalization into 1NF of a relation, where the attributes Pname and Dname are multivalued. (а) EMP LOCS Ename Figure 14.5 Particularly poor design for the EMP_PROJ relation in Figure 14.3(b). (a) The two relation schemas EMP_LOCS and EMP PROJ1. (b) The result of projecting the exten- sion of EMP PROJ from Figure 14.4 onto the relations EMP LOCS and EMP_PROJ1. Plocation P.K. EMP PROJ1 Ssn Pnumber Hours Pname Plocation P.K. (b) EMP LOCS EMP PROJ1 Pnumber Hours Ename Smith, John B. Plocation Ssn Pname Plocation Bellaire 123456789 32.5 ProductX Bellaire Smith, John B. Sugarland 123456789 2 7.5 ProductY Sugarland Narayan, Ramesh K. Houston English, Joyce A. English, Joyce A. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Zelaya, Alicia J. Jabbar, Ahmad V. Wallace, Jennifer S. Stafford Wallace, Jennifer S. Houston Borg, James E. 666884444 3 40.0 ProductZ Houston Bellaire 453453453 1. 20.0 ProductX Bellaire Sugarland 453453453 2 20.0 ProductY Sugarland Sugarland 333445555 10.0 ProductY Sugarland Houston 333445555 3 10.0 ProductZ Houston Stafford 333445555 10 10.0 Computerization Stafford Stafford 333445555 20 10.0 Reorganization Houston Stafford 999887777 30 30.0 Newbenefits Stafford 999887777 10 10.0 Computerization Stafford 987987987 10 35.0 Computerization Stafford Houston 987987987 30 5.0 Newbenefits Stafford 987654321 30 20.0 Newbenefits Stafford 987654321 20 15.0 Reorganization Houston 888665555 20 NULL Reorganization Houston

Answer rating: 100% (QA)

To convert 1NF ENAME PLOCATION 1 PLOCATION 2 PLOCATION 3 smith johnB be... View the full answer