Q3 Consider the following part-time staff payroll table with sample data of a sales company that provides sales services at various work locations in Hong kong: Where StaffNo = unique part-time staff number;, Name = part-time staff name; TID = job title ID; Title = job title; HrRate = hourly salary of a job title; WorkID = work ID; WorkLoe = work location; HrWorked = number of hours worked; Salary = Salary of a work for a part-time staff member. Assumption: 1. Each part-time staff member has a unique staff number and a unique job title ID that describes the nature of the part-time job. 2. Each work has a unique work ID and a unique work location. 3. Each part-time staff member is assigned to several work but not all part-time staff will be assigned to work. There is at least one part-time staff member assigned to any given work. 4. Each job title has at least one part-time staff member. All part-time staff with the same job title ID will have the same hourly salary. (a) Name and describe the THREE types of database anomalies that may happen in the above STAFF table. [6 marks] (b) (i) Write down the unnormalized form (UNF) for the STAFF relation. [2 marks] (ii) Normalize the STAFF relation to the third normal form (3NF). Show ALL your steps from 1NF to 3NF by listing all the relations in 1NF, 2NF and 3NF. Underline the primary key attribute(s) for each relation in your answer. [12 marks] (c) Draw an entity relationship diagram to represent the normalized relations in 3NF based on the given assumptions. Make sure that all entities must be labelled and relationships must be drawn with the correct symbols. [10 marks]