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.

ENTITY - explain each entity with their attributes and constraints below in a form of Table like in the picture given (example) 1. Patient Record 2. Patient 3. Treatment 4. Medicines 5. Bill 6. Payment Method 7. Doctor

EXAMPLE:

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 Table2: patients FIELD NAME DESCRIPTION TYPE LENGTH patient_id Patient id number INT 11 fname First name of patient VARCHAR 64 Iname Last name of patient VARCHAR 64 patient_type Type of patient VARCHAR 64 age Age of patient INT 2. address Address of patient TEXT