: What is „Relation Database Management Systems” (RDBMS) and how does it differ from „Database Management Systems” (DBMS)? What categories of data integrity exist in RDBMS? How do they ensure the data integrity? (2.1)
: “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.2)
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) (2.3)
