Draw an Entity Relationship Diagram $($ERD$)$ of the proposed Barwon Health Prescription System

based on Crow$$s Foot notation using a professional drawing tool. Please note that you may

have to make some assumptions to meet all business requirements. If you make any

assumptions, do not forget to list them first in your submission.

$1.$ Identify all Entities, their Attributes, Constraints, and Relationships with Cardinalities

$2.$ Identify Primary Key $($PK$)$ in all entities.

$3.$ Implement and label all relationships using Primary$/$Foreign Key $($PK$/$FK$)$ or Associative

Entities

$4.$ Consider using specialization$/$generalization relationships using supertype and subtype

entities with disjoint$/$overlapping and partial$/$total completeness constraints if possible.

$5.$ Provide justifications $($based on business rules or your assumptions$)$ for entities,

attributes, constraints, and relationships$/$cardinalities you considered