We have to design the database for the BADAR AL Sama hospital for patient appointments with doctors.Do the following tasks:$\mathrm{.}1.$ Write the case study for the above$-$given scenario based on your understanding. $[1$ mark$]2.$ 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$]3.$ Convert the ER diagram created in step $2$ to relational tables with primary and foreign keys. $[3$ Marks$]4.$ Normalize the tables created in steps $2-3$ up to the$3$rd normal form. $[3$ Marks$]$