Normalization Exercises

Convert each of the following schemas to 3NF, showing all intermediate stages, that is, 1NF and 2NF.

 

BRANCH (Branch#, Branch_Addr, (ISBN, Title, Author, Publisher, Num_copies))

 

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

 

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