The PatientVisit relation keeps information about the patients\' visits to docto

Question

The PatientVisit relation keeps information about the patients' visits to doctors Identify the functional dependencies in the relation. Is this relation in 2NF, 3NF and BCNF, and why? If not, you're your steps performing the normalization to transform the relation into 2NF, 3NF, and BCNF. Show all referential integrity constraints in the relational model that result from the normalization. Identify the functional dependency in each relation in the final relational model produced in b.model produced in b.

Explanation / Answer

a. patientIDDoctorID->visitDate

patientID->name

patientID->Address

DoctorID->DoctorName

b.in 2NF relation is decomposed nonkey attributes are fully fuctional dependancy

patientIDDoctorID->VisitDate

next name,address and doctor name are in another table

in 3NF relation decomposed name doctor name and address

patientIDDoctorId->VsitDate

name->address

DoctotName->name

in BCNF relation

patientID->name

patientIDDoctorId->VsitDate

c.after final relation fuctional dependancys are

patientId->name

patientIDDoctorId->VsitDate

name->address

DoctotName->name

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.