[Computer Science - CS2203 - Databases 1]

1. Normalize the relation below into first, second, and third normal form.

2. Describe the changes required to the relations to meet the standard of first 1NF and then 2NF and lastly 3NF.

3. Provide an Entity Relationship diagram that is in 3NF.

Doctor DoctorID Name .Phone SpecialtyNumber Specialty lSupervisor Patient PatientID Name A4.Phone Email Address AddedDate Alergies DoctorID + Appointment AppointmentID DoctorID Patient ID Appointment Date BloodPressure Weight Treatment Notes | Medicines