Question 3) (13 points) Consider relation R(Visit_ID, Doctor, Patient, Date, Clinic, Nurse, Cost) with the set of functi

[answerhappygod]

Question 3 13 Points Consider Relation R Visit Id Doctor Patient Date Clinic Nurse Cost With The Set Of Functi 1 (31.38 KiB) Viewed 10 times

Question 3) (13 points) Consider relation R(Visit_ID, Doctor, Patient, Date, Clinic, Nurse, Cost) with the set of functional dependencies F={{Visit_ID) → (Doctor, Patient, Date, Clinic, Nurse, Cost), (Doctor, Patient, Date) → (Visit_ID, Clinic, Nurse, Cost). (Doctor) → (Cost). (Clinic)→ (Doctor, Nurse)). In following parts, if R needs to be split, show how the new relations can be joined through PK-FK relationships 1) The relation has two keys. What are these keys, and which attributes are prime attributes? 2) Assume all attributes are simple, is R in 2NF? Why or why not? If it is not, normalize to 2NF. 3) After part 2, is R in 3NF? Why or why not? If it is not, normalize to 3NF. 4) After part 3, is R in BCNF? Why or why not? If it is not, normalize to BCNF.