Q3 Consider the following Equipment table with sample data of a studio equipemnt rental company in Hong kong: EOIIIPMENT Where EqNo = unique equipment number, Type = type of equipment; TypeDesc = description of an equipment type; DailyRate = daily rental rate of an equipment; CustID = customer ID; CustName = customer's last name; Phone = customer phone number; StartDate = start date of an equipment rental; RentDay = number of days for a rental; TotalCost = total cost for an equipment rental. Assumption: 1. Each equipment available for rent has a unique number and has been assigned with one equipment type only. Each equipment type has at least one equipment. 2. All equipment with the same equipment type has the same rate for rent. 3. The same equipment cannot be rented for more than once in the same day. 4. A customer can rent the same equipment in different dates. 5. All equipment have been rented for at least once and all customers have rented equipment at least once. (a) Name and describe the THREE types of database anomalies that may happen in the above EQUIPMENT table. [6 marks] (b) (i) Write down the unnormalized form (UNF) for the EQUIPMENT relation. [2 marks] (ii) Normalize the EQUIPMENT relation to the third normal form (3NF). Show ALL your steps from 1NF to 3NF by listing all the relations in INF, 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]