Part A Entity Relationship Modelling and Logical Database Design $(35$ marks$)$

Task $1$ Identify Entities & Develop Business Rules $[10$ marks$]$

Identify all entities and relationships in the case study and develop a set of business rules. You

should follow the syntax given below. Two rules must describe each relationship, one in each

direction.

Each ENTITY$\_1$ May$/$Must Relationship$\_$Verb$\_$Phrase number ENTITY$\_2$

Task $2$ Construct a logical Entity Relationship Diagram $($ERD$)[25$ marks$]$

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.