Question: Part A tasks Note the following points to prepare your answers: 1. Population is significant and no further explanation is required from the domain expert.
Part A tasks Note the following points to prepare your answers: 1. Population is significant and no further explanation is required from the domain expert. In other words, carry out your CSDP steps 1 to 6 for the given data only. 2. We strongly recommend that you carry out your CSDP steps starting from Step 1 and ending in Step 6 to prepare your final ORM diagram. But you are not required to submit results of these steps individually 3. You are only required to submit your final ORM diagram obtained after performing Step 6. Task 1 10 marks] Following are tables of employee information. Specify an ORM conceptual schema for this UoD. Ssn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pnumber 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Hours 32.5 7.5 40.0 30.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 Null EMP PROJ Ename Smith, John B. Smith, John B. Narayan, Ramesh K. English, Joyce A. English, Joyce A. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Zekata, Alicia J. Zekata, Alicia J. Jabbar, Ahmad V. Jabbar, Ahmad V. Wallace, Jennifer S. Wallace, Jennifer S. Borg, James E. Pname ProductX ProductY Productz ProductX ProductY ProductY Productz Computerization Reorganization Newbenefits Computerization Computerization Newbenefits Newbenefits Reorganization Reorganization Plocation Bellaire Sugarland Houston Bellaire Sugarland Sugarland Houston Stafford Houston Stafford Stafford Stafford Stafford Stafford Houston Houston Ssn 123456789 333445555 EMP DEPT Bdate Address Dnumber Dname Dmgr_ssn 1965-01- 731 Fondren, Houston, 5 Research 333445555 09 TX 1955-12 639 Voss, Houston, TX5 Research 333445555 08 1968-07- 3321 Castle, Spring, 4 Administration 987654321 19 TX 1941-06 291 Berry, Bellaire, TX 4 Administration 987654321 20 1962-09- 975 Fire Oak, Humble, 5 Research 333445555 15 TX 999887777 Ename Smith, John B. Wong, Franklin T. Zekata, Alicia J. Wallace, Jennifer S. Narayan, Ramesh K. English, Joyce A Jabbar, Ahmad V. Borg, James E. 987654321 666884444 453453453 5 Research 333445555 987987987 4 1972-07- 5631 Rice, Houston, 31 TX 1689-03 980 Dallas, Houston, 29 1937-11- 450 Ston, Houston, TX 10 Administration 987654321 TX 888665555 Headquarters 888665555 The 7-Step CSDP Step 1 Transform familiar examples into atomic facts and apply quality checks 2 Draw the fact types and apply a population check 3 Check for entity types that should be combined and note any arithmetic derivations 4 Add uniqueness constraints and check arity of fact types Add mandatory role constraints and check for logical derivations 6 Add value, set comparison, and subtyping constraints Add other constraints and perform final checks 5 7 Part A tasks Note the following points to prepare your answers: 1. Population is significant and no further explanation is required from the domain expert. In other words, carry out your CSDP steps 1 to 6 for the given data only. 2. We strongly recommend that you carry out your CSDP steps starting from Step 1 and ending in Step 6 to prepare your final ORM diagram. But you are not required to submit results of these steps individually 3. You are only required to submit your final ORM diagram obtained after performing Step 6. Task 1 10 marks] Following are tables of employee information. Specify an ORM conceptual schema for this UoD. Ssn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pnumber 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Hours 32.5 7.5 40.0 30.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 Null EMP PROJ Ename Smith, John B. Smith, John B. Narayan, Ramesh K. English, Joyce A. English, Joyce A. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Wong, Franklin T. Zekata, Alicia J. Zekata, Alicia J. Jabbar, Ahmad V. Jabbar, Ahmad V. Wallace, Jennifer S. Wallace, Jennifer S. Borg, James E. Pname ProductX ProductY Productz ProductX ProductY ProductY Productz Computerization Reorganization Newbenefits Computerization Computerization Newbenefits Newbenefits Reorganization Reorganization Plocation Bellaire Sugarland Houston Bellaire Sugarland Sugarland Houston Stafford Houston Stafford Stafford Stafford Stafford Stafford Houston Houston Ssn 123456789 333445555 EMP DEPT Bdate Address Dnumber Dname Dmgr_ssn 1965-01- 731 Fondren, Houston, 5 Research 333445555 09 TX 1955-12 639 Voss, Houston, TX5 Research 333445555 08 1968-07- 3321 Castle, Spring, 4 Administration 987654321 19 TX 1941-06 291 Berry, Bellaire, TX 4 Administration 987654321 20 1962-09- 975 Fire Oak, Humble, 5 Research 333445555 15 TX 999887777 Ename Smith, John B. Wong, Franklin T. Zekata, Alicia J. Wallace, Jennifer S. Narayan, Ramesh K. English, Joyce A Jabbar, Ahmad V. Borg, James E. 987654321 666884444 453453453 5 Research 333445555 987987987 4 1972-07- 5631 Rice, Houston, 31 TX 1689-03 980 Dallas, Houston, 29 1937-11- 450 Ston, Houston, TX 10 Administration 987654321 TX 888665555 Headquarters 888665555 The 7-Step CSDP Step 1 Transform familiar examples into atomic facts and apply quality checks 2 Draw the fact types and apply a population check 3 Check for entity types that should be combined and note any arithmetic derivations 4 Add uniqueness constraints and check arity of fact types Add mandatory role constraints and check for logical derivations 6 Add value, set comparison, and subtyping constraints Add other constraints and perform final checks 5 7
Study Help