An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample...

  

Transcribed Image Text:

An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample data, which lists the time spent by agency staff working at various hotels. The national insurance number (NIN) is unique for every staff. The relation in the table below is already a INF. Please describe and draw the relations/tables for the 2NF and 3NF, respectively [5.5 points]. Identify primary keys for each relation/table in INF, 2NF and 3NF [2 points). Assumptions: ● ● . . . The national insurance number (NIN) is unique for every staff. Multiple staff can be hired under the same contract. Only one hotel can appear in one contract. It s possible for two persons to have the same name. It s possible for two hotels to have the same address. NIN ContractNo 1135 C1024 1057 C1024 1068 C1025 1135 C1025 Hours StaffName Smith J 16 24 Hocine Di 28 White T 15 Smith J HotelNo H25 H25 H4 H4 HotelLocation East Kilbride East Kilbride Glasgow Glasgow An agency supplies part-time/temporary staff to hotels. The table shown in the figure below displays sample data, which lists the time spent by agency staff working at various hotels. The national insurance number (NIN) is unique for every staff. The relation in the table below is already a INF. Please describe and draw the relations/tables for the 2NF and 3NF, respectively [5.5 points]. Identify primary keys for each relation/table in INF, 2NF and 3NF [2 points). Assumptions: ● ● . . . The national insurance number (NIN) is unique for every staff. Multiple staff can be hired under the same contract. Only one hotel can appear in one contract. It s possible for two persons to have the same name. It s possible for two hotels to have the same address. NIN ContractNo 1135 C1024 1057 C1024 1068 C1025 1135 C1025 Hours StaffName Smith J 16 24 Hocine Di 28 White T 15 Smith J HotelNo H25 H25 H4 H4 HotelLocation East Kilbride East Kilbride Glasgow Glasgow