Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Appointment (DoctorID, AppointDate, AppointTime, DoctorName, PatientID, PatientName, SurgeryNo) Primary Key ={ DoctorID, AppointDate, Appoint T ime } and you have the following functional dependencies: -
Appointment (DoctorID, AppointDate, AppointTime, DoctorName, PatientID, PatientName, SurgeryNo) Primary Key ={ DoctorID, AppointDate, Appoint T ime } and you have the following functional dependencies: - FD1: \{DoctorID, AppointDate, AppointTime }{ PatientID, PatientName } - FD2: \{DoctorID\} DoctorName\} - FD3: \{PatientID\} { PatientName, SurgeryNo - FD4: \{DoctorID, AppointDate\} \{SurgeryNo\} - FD5: \{AppointDate, AppointTime, PatientID\} \{DoctorID, DoctorName } According to the functional dependencies given above, which one(s) of them violates corresponding NF? Explain each of them. a) [15 pts] First Normal Form (1NF): None FD1 FD2 FD3 FD4 FD5 b) [15 pts] Second Normal Form (2NF): None FD1 FD2 FD3 FD4 FD5 c) [15 pts] Third Normal Form (3NF): None FD1 FD2 FD3 FD4 FD5
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started