In your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities...

In your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include:

1. Summarise the ERM's components, and names the entities and their relationship (As given in the Textbook, p.143, Table 4.4)


2. all entities, relationships (including names) and attributes that are relevant,


3. primary keys identified, and


4. include relationship participation - participation (optional / mandatory) symbols and cardinality.

The E-R diagram should be completed using the standards of this unit. Use Microsoft Visio to create the E-R diagram.