Q3 Consider the following Activity relation with sample data records provided by a nongovernmental organisation which organises different types of activities for old persons. Aetivitu Where ActivityID = Activity ID number, ActivityName = Activity name, Place = The place to hold the activity, ADate = Date of the activity, SupNo = Supervisor number of the activity, SupName = Name of activtiy supervisor, VolunteerNo = Volunteer number, VolunteerName = Volunteer name, Task = Task responsible by the volunteer in the activity. Assumption: Every volunteer can help in one or more activities. Every activity has it own activity number and has at least two volunteers assigned to it. There is a policy that every activity supervisor must supervise at least one activity, and each activity has only one supervisor. A volunteer can take up different tasks in different activities. (a) Name and describe the THREE types of database anomalies that may happen in the data of the given Activity relation. [6 marks] (b) Explain the term Functional Dependencies, and give FOUR functional dependencies in the given Activity relation. [6 marks] (c) (i) Write down the unnormalized form (UNF) for the Activity relation. [1 mark] (ii) Normalize the Activity relation to the third normal form (3NF). Show ALL your steps by listing out all the relations in 1NF, 2NF and 3NF. Underline the primary key attribute(s) for each relation in your answer. [12 marks] (d) Draw an entity relationship diagram to represent the normalized relations in 3NF given in your answer in Q3 (c) with the given assumptions. [5 marks]