Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes of each entity.

Task 1:

Design an Entity Relationship Diagram (ERD) to model the above scenario. Identify the different entities and attributes of each entity. (A minimum of 8 entities need to be identified).

Suggest and justify the choice of relationship and cardinality of the relationship. State the

assumptions (if any) made by you to develop the ERD based on your research. Provide detailed

analysis and justification for the selection of entities and attributes based on your research.

Task 2:

Derive a set of relational tables from the ER diagram (Task 1), using appropriate choices for the

table attributes. List the integrity rules and business rules, which you would recommend to

ensure the quality of data. Indicate all necessary key constraints. Critically analyze the

constraints and business rules based on your study of the clinic.