Question 3 4 Marks The following relation provides the information related to appointments and tests performed in appointments. One appointment can have many different tests and a test can be performed in many different appointments AppointmentIDDate Time TestPerformedTestCharges 16/03/2017 9:30 AM Biopsy 16/03/2017 9:30 AM Laser 16/03/2017 11:00 AM Laser 16/03/2017 11:00 AM Excision 16/03/2017 1:00 PM Biopsy 16/03/2017 2:00 PM Biopsy $75 $250 $250 $250 $75 $75 (1 mark) (1 mark) primary key of the aboverelation? (a) (b) (c) What is the Explain any one anomaly that exists in the aboverelation. What is the highest normal form (e.g. 1NF or 2NF or 3NF) that the above relation satisfies? Note: You need not show the workout. (1 mark) (d) Normalize the above relation into a set of relations that satisfy 3NF. You need not provide the workout to arrive at the 3NF relation but provide the final3NF relations as per the following format: Relation1 (ID1, aaa, bbb, ...) Relation2 (ID2, ID1, ccc, ddd,...) Foreign key (ID1) referencesRelation1 (1 mark)