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

CentactaNumber$)$

Doctor $($including attributes like Doctoreald, Name, Specialty, and

ContactaNumber$)$

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 Bilh, 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 inteqrity.