Page 1 of 1
Answer Q6(a)(i) - Q6(a)(iii) based on information in Figure Q6(a). An agency supplies temporary staff to hotels througho
Posted: Thu Jul 14, 2022 2:13 pm
by answerhappygod
- Answer Q6 A I Q6 A Iii Based On Information In Figure Q6 A An Agency Supplies Temporary Staff To Hotels Througho 1 (153.26 KiB) Viewed 14 times
Answer Q6(a)(i) - Q6(a)(iii) based on information in Figure Q6(a). An agency supplies temporary staff to hotels throughout Malaysia. Table 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for employee. Table 1: Employee Data Figure Q6(a) (i) Provide examples of insertion, and deletion anomalies. (4 marks) (ii) Identify all dependencies by using dependency diagram for Table 1. (6 marks) (iii) Normalize the relation into Second Normal Form (2NF) and Third Normal Form (3NF). (15 marks) Discuss how normalization technique can be used to check the structure of the tables created from the ER model. (5 marks)