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$]$