We have to design the database for the BADAR AL Sama hospital for patient appointments with doctors.

Do the following tasks:.

Write the case study for the above$-$given scenario based on your understanding. $[1$ mark$]$

Create an ER diagram with at least $3$ entities, different types of attributes, and $3$ relationships based on the case study you have created in step $1.[3$ Marks$]$

Convert the ER diagram created in step $2$ to relational tables with primary and foreign keys. $[3$ Marks$]$

Normalize the tables created in steps $2-3$ up to the $3$rd normal form. $[3$ Marks$]$