HEALTH CARE ORGANIZATION DATABASE PROJECT

This organization provides following functionalities Emergency Care $24x7$ Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. The Doctor can update the data related to the patient upon diagnosis $($Including the disease diagnosed and prescription$).$ This organization also provides rooms facility for admitting the patient who is critical. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to a doctor. Also, they can be assigned to patients $($to take care of them$).$ The bill is paid by the patient with cash and E$-$banking. Record of each payment made is also maintained by the organization. The record of each call received to provide help and support to its existing person is also maintained.

a$.$ List the names of all relationship types, and specify the $($min$,$max$)$ constraint on each participation of an entity type in a relationship type. justify your choices

b$.$ Draw the ER diagram

c$.$ Convert the ER into a database schema

$,$ A group should submit a report that may be printed or handwritten

$,$ One report is to be submitted by a group

$,$ No need to draw the ER by any tool, it can be hand drawn

d$.$ Write the SQL statements to create the tables

e$.$ Write an SQL statements to insert a row into the tables