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

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

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

*****NOTE****** BCNF information not provided. This is where I am having issues with question. If BCNF not possible without information. Please provide 1NF,2NF, and 3NF