The Smart Health Clinic is looking to improve its patient management system by incorporating

a new data model. The clinic handles various activities such as patient registration,

appointment scheduling, medical tests, treatment histories, and billing.

Task:

Design a Conceptual Data Model:

Create an Entity$-$Relationship $($E$-$R$)$ diagram to represent the data model of the

Smart Health Clinic system. Your model should include the following entities:

Patient $($with attributes such as Patient$\_$ID$,$ Name, DOB, Address, and

Contact$\_$Number$)$

Doctor $($including attributes like Doctor$\_$ID$,$ Name, Specialty, and

Contact$\_$Number$)$

Appointment $($featuring Appointment$\_$ID$,$ Date, Time, and Status$)$

Medical Test $($including Test$\_$ID$,$ Test$\_$Name, and Price$)$

Treatment $($with attributes like Treatment$\_$ID$,$ Description, and Cost$)$

Billing $($featuring Bill$\_$ID$,$ Amount, Date, and Payment$\_$Status$)$

Define the relationships between these entities with appropriate cardinalities.

Annotate key business rules that govern these relationships $($e$.$g$.,$ a patient

can have multiple appointments, but each appointment is with one specific

doctor$).$

Discuss Conceptual Integrity:

Explain how entity and referential integrities are maintained in your model.

Identify any potential areas where the model might be normalized to prevent

data redundancy and maintain data integrity.