Answer Q6(a)(i) - Q6(a)(iii) based on information in Figure Q6(a). An agency supplies temporary staff to hotels througho

[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 30 times

FOR Q6Aiii) Please normalize it, get something like this: R1 {attributes...} and list out all the key attributes, tq!
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)