Answered step by step
Verified Expert Solution
Link Copied!

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: -

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle Database Architecture

Authors: Thomas Kyte, Darl Kuhn

3rd Edition

1430262990, 9781430262992

More Books