Reference no: EM132291066

Assignment -

Statements -

1. When a client books a treatment, they are asked to pay a deposit, and the payment reference and amount of the deposit is recorded. They need to pay the remaining amount after completing each treatment in each session (or visit).

2. OPC keeps records of the clients' medical history, which includes their medical condition (if any) and their current medication (if they are taken any), as well as the name of the therapist who did their treatment's in each visit.

Your task - Create an ERD for each of the above statements that describe the current business rules for OPC. For each new statement being the business rule, extend the ERD to include the additional business rule in the ERD.

Use Crows Foot notations and include all of the following in each part:

• All entities with Primary key and any foreign key attributes;
• The relationships between entities;
• The cardinality and optionality of each relationship;
• Any M:N relationships are be resolved to 1:M relationships.
• Include your student ID and full name under the ERD then copy the whole ERD as an image to your Word Document.

This assessment task will assess the following learning outcome/s:

• be able to model complex business rules using Entity Relationship Diagrams (ERDs).

Attachment:- Assignment File.rar