Ex 4.10 a, b, c 124 Part 1 Operational Databases 10b Show the result of normaliz

Question

Ex 4.10 a, b, c

124 Part 1 Operational Databases 10b Show the result of normalizing the SUR E4. E4.10a Depict full key functional dependencies, partial SURGER functional dependencies (if any), and transitive functional dependencies (if any) in the SURGERY SCHEDULE Table. SCHEDULE Table to 2M-"- Show the result of normalizing the SURGER FA.10c SCHEDULE Table to 3N EA10 Consider the following relation with sample data. SURGERY SCHEDULE TABLE PatientiD PatientName SurgeonlD SurgeonName NurselD NurseName SurgeryDate SurgeryTypeNurseRole Knee Surgery Dr. Adams Dr. Adams N2 Dr. Adams Dr. Brown Mike Sue Sue Sue 1-Jan 1-Jan 2-Jan 3-Jan oe Knee Surgery 2nd Assistant Ankle Surgery 1st Assistant Elbow Surgery st Assistant N2 N2 Pat Bob Bob Bob CCC Dr.own N3 Tina1-Jan Knee Surgery1st Assistant AAA N3 Tina-11-Jan Hip Surgery 2nd Assistant 1-Jan Hip Surgery 1st Assistant Dr. Adams Dr. Adams Dr. Adams Dr. Brown 2-JanShoulder Surgery 1st Assistant 1-Jan Hip Surgery 1st Assistant Sue Pam N5 . The StUR

Explanation / Answer

patientID , SurgeonID, NurseID are known we can tell PatientName, SurgeonName and NurseName

so PatientName, SurgeonName and NurseName are functional dependent

NurseRole is based on NurseID and surgeryDate or Surgery Type

so NurserRole is a partial Dependancy

Transitive

patient id -> SurgeonID

SurgeonID -> SurgeryType

patient id -> SurgeryType

2NF

PATIENT ID , PATIENT NAME

NURSE ID , NURSE NAME, NURSE ROLE

SURGEON ID, SURGEON NAME

SURGEON ID, SURGERY TYPE , SURGERY DATE, PATIENT ID, NURSE ID, NURSE ROLE

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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