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.
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.