“ABC hospital has a number of departments, rooms, doctors, nurses, and other staff working. Patients having different conditions visit
and get checkup done from the doctors and if necessary they are admitted and discharged after recovering.”
1) Build an entity-relationship diagram for the above scenario, deriving relations and validating relations using normalization up to third
normal form.
2) From the ER diagram in first part, create a database (DB) using ‘Data Definition Language’ (DDL). Define how would you insert, delete
and update records from your ‘Doctors’ table using ‘Data Manipulation Language’ (DML) .