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

 


2) CLIENT (Client#, Name, Location, Manager#, Manager_name,  Manager_location, (Contract#, Estimated_cost, Completion_date, (Staff#, Staff_name, Staff_location)))
 

 


3) PATIENT (Patient#, Name, DOB, Address, (Prescription#, Drug, Date, Dosage, Doctor, Secretary))

 

4)  DOCTOR (Doctor#, DoctorName, Secretary, (Patient#, PatientName, PatientDOB, PatientAddress, (Prescription#, Drug, Date, Dosage)))