Normalization Exercises |
Convert each of the following schemas to 3NF, showing all intermediate stages, that is, 1NF and 2NF. 1)
BRANCH (Branch#, Branch_Addr, (ISBN,
Title, Author, Publisher, Num_copies))
4) DOCTOR (Doctor#, DoctorName, Secretary, (Patient#, PatientName, PatientDOB, PatientAddress, (Prescription#, Drug, Date, Dosage))) |