Question 4

An agency called DeepClean supplies part-time/temporary staff to do cleaning services at residential area and offices in Kuala Lumpur. Table 2 as shown below, lists the time spent by the agency staff working at two office sites. The StaffID is unique for each employee.

Table 2 DeepClean

StaffID	ContractNo	HoursPerWeek	StaffName	OfficeNo	OfficeLocation
101	C90	16	Anne	O25	Ampang
102	C90	24	Rita	O25	Ampang
103	C91	28	Mandy	O7	Kg Baru
101	C91	16	Anne	O7	Kg Baru

1. Draw the dependency diagram and label the primary key(s), partial dependency(s) and transitive dependency.

[5 Marks]

2. Based on the dependency diagram in Question (a), show the relations in Second Normal Form (2NF).

[5 Marks]

3. Convert the relations to Third Normal Form (3NF).

[5 Marks]