Question 3

Consider the relation schema Appointment={Patient, GP, Date, Time, Clinic, Room} and the following set Σ of FDs:

• Patient, Clinic, Date → Time

• Patient → GP

• GP → Clinic

• Clinic, Date, Time, Room → Patient

• Patient, Date, Time → Clinic, Room

Is the above relation schema Appointment in BCNF? If not, identify a BCNF decomposition for Appointment. You need to include the main steps used for identifying the BCNF decomposition. Check if this BCNF decomposition is dependency preserving.