Question 4 (22 marks) It assesses vour understanding of the advantages of normalisation and how relations that are not in a particular normal form may be non-loss decomposed into relations which satisfy that normal form. The relation Visit is intended to record information about occupancy for a hotel. The following gives the relational heading. Visit(CustomerName, CustomerAddress, DateOfArrival, DateOf Departure, RoomNumber, RoomGrade, CustomerGrade, Breakfast) A sample tuple of the relation is This represents that the fact Angus Wong of 12 Nathan Road, a premier customer, stayed at the hotel between the 10th and 15th of July 2022 , staying in room 1623 , a delux room, with breakfast included. The following are the non-trivial functional dependencies on Visit, which are not implied by its primary key. FD1: CustomerName, CustomerAddress CustomerGrade FD3: RoomNumber RoomGrade FD4: CustomerGrade Breakfast (a) Demonstrate that Visit is subject to insertion, deletion and amendment anomalies. (6 marks) (b) Justify the statement that Visit is not in second normal form (2NF). Write down the headings of relations in 2NF that will result from a non-loss decomposition of Visit. Justify that these relations are in 2NF. (8 marks) (c) Are each of the relations resulting from the decomposition in part(b) in third normal form? Justify your answer. For each relation that is not in third normal form, write down the heading of the relations in third normal form which result from a non-loss decomposition of the relation. Justify your answers. (8 marks)