Decompose the given relation into relations in 2NF. For each ofthe new relations, draw a functional dependency diagram,
and state if it is in 3NF and why. If your answer is no, describehow to normalise the relation to be in 3NF
(c) The relation appointment is given below: appointment (patientID, patientName, patientAddress, aDate, aTime, nurseiD, nurseName, notes) where the primary key is underlined. It records the details of patient appointments with nurses. (i) Draw the functional dependency diagram to show all functional dependencies in
PayPal Gateway not configured
PayPal Gateway not configured