Based on the business rules developed in Task $1,$ construct a logical ERD for the case study using the

Visual Paradigm tool.

$$ Identify all attributes in each entity, including all primary and foreign keys $($transform any

composite and multivalued attributes according to the rules of the relational model$).$

$$ Name all relationships $($i$.$e$.$ you must use verb phrases on both sides of each relationship$)$

$$ Identify the Cardinality and Participation for each relationship.

$$ Resolve all many$-$to$-$many $($M:N$)$ relationships.

$$ Describe any assumptions you have made in a text note on the diagram.