Database Assuagement
CIS3310 NORMALIZATION Assignment #2
Convert each of the following schemas to 3NF, showing all stages, that is, 1NF and 2NF.
1. CLIENT (Client#, Name, Location, Manager#, Manager_name, Manager_location, (Contract#, Estimated_cost, Completion_date, (Staff#, Staff_name, Staff_location)))
2. PATIENT (Patient#, Name, DOB, Address, (Prescription#, Drug, Date, Dosage, Doctor#, Doctor, Secretary))
3. DOCTOR (Doctor#, DoctorName, Secretary, (Patient#, PatientName, PatientDOB, PatientAddress, (Prescription#, Drug, Date, Dosage)))
4. WHOLESALER (customerID, customerName, model, size, day, numberSold, price)
5. MANUFACTURING (orderDate, deliveryDate, supplier, partID, material, price)
6. EXAM ADMINISTRATION(studID, studName, courseID, courseTitle, acadYear, examSession, mark, degreeCourse