Question 4 (20 marks) This question is based on Section 5 of Block 2. It assesses your understanding of the advantages of normalisation and how relations which are not in a particular normal form may be non-loss decomposed into relations which satisfy that normal form. The relation Vaccine is intended to record information about infants and their vaccinations: when a particular infant had a particular vaccination; where the vaccination took place; who administered the vaccine. The following gives the relational heading: Vaccine (VaccineCode, InfantId, Date, InfantName, InfantAddress, MedicalCentreCode, MedicalCentreName, MedicalCentreAddress, NurseId, NurseName) Besides the functional dependencies with the primary key as their determinant, Vaccine has the following non-trivial functional dependencies: FD1: InfantId InfantName FD2: InfantId InfantAddress FD3: MedicalCentreCode MedicalCentreName FD4: MedicalCentreCode MedicalCentreAddress FD5: NurseId NurseName (a) Give examples to demonstrate that Vaccine does not prevent insertion or amendment anomalies. (4 marks) (b) Justify the statement that Vaccine is not in second normal form (2NF). Write down headings of the relations in 2NF that will result from a non-loss decomposition of Vaccine. Primary keys of these relations should be underlined. (6 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 headings of the relations in third normal form that result from a non-loss decomposition of that relation. Again, primary keys should be underlined. (10 marks