Describe the Entity Relationship Model (ERM) components that consists of the entities, attributes, relationships, and constraints of the project. You also need to identify the mandatory and optional dependencies for the relationships.

7 ENTITIES:

1.PATIENT RECORD

2. MEDICINES

3.PATIENT

4.TREATMENT

5.BILL

6. PAYMENT METHODS

7. DOCTOR

THE ANSWER SHOULD BE GIVEN AS BELOW;

MEDICINES Attributes: - MED_ID (PK) TREAT_ID (FK1) MED_NAME MED_QUANTITY DESCRIPTION REQUESTED_DATE EXPIRY_DATE BILL Attributes: BILL_ID (PK) PATIENT_ID (FK1) MED_ID (FK2) MED_QUANTITY (FK3) AMOUNT DATE PAYMENT_METHOD Attributes: METHOD_ID (PK) BILL_ID (FK1) TYPE DOCTOR Attributes: DOCTOR_ID (PK) NAME CONTACT_NUM EMAIL ADDRESS PATIENT_RECORD Attributes: - RECORD_ID (PK) PATIENT_ID (FK1) TREAT_ID (FK2) MED_ID (FK3) MED_QUANTITY (FK4) DATE COMPLAINT MEDICAL_FINDINGS - DOC_INCHARGE PATIENT Attributes: PATIENT_ID (PK) NAME AGE ADDRESS - CONTACT_NUM TREATMENT Attributes: TREATMENT_ID (PK) TREAT_TYPE DOCTOR This entity will store the information of doctor that in charge to give a treatment for the patient. It contains all the record of DOCTOR_ID, NAME, CONTACT_NUM, EMAIL AND ADDRESS of the doctor that will be in charge of treating the patient. ATTRIBUTES DOCTOR_ID DATA TYPE LENGTH CONSTRAINT Primary key INT 11 NAME VARCHAR 25 Not NULL CONTACT_NUM DESCRIPTION Store the doctor ID number Required attribute Store name of doctor Store the contact number of doctor Multivalued attribute Store the email of doctor Store address of doctor Multivalued attribute INT 12 NULL EMAIL VARCHAR 100 Not NULL ADDRESS VARCHAR 255 Not NULL