An ER model of the case study system. This should conform to third normal form. Students

should be aware there are a number of disjoint subtype entities. Students are able to use

any drawing package to present the ER diagram, but the diagram should use the Crows foot

notation and conform to the standards identified in $($Michael L$.$ Hernandez, $4$th edition$).$

These include that entities are shown in a rectangle with name of entity in grey at top

separated from two columns below with PK$,$ FK identifiers, where appropriate in the first

column and attributes in second column. Primary key attributes to be separated from other

attributes by a line across the rectangle. All entity to be in upper case and attribute names

to be in capitalise. All relationships should be labelled and identified as mandatory or

optional. All connectivity, participation and cardinalities $($if there are specific limits$)$ should

be shown.

ERD Section

This should conform to third normal form. $-$ Must be valid supertype and subtype entities

and hierarchy included. $*$ Crows foot notation and conformance to the standards identified

These include that entities are shown in a rectangle with name of entity in grey at top

separated from two columns below with PK$,$ FK identifiers, where appropriate in the first

column and attributes in second column. Primary key attributes to be separated from other

attributes by a line across the rectangle. All entity to be in upper case and attribute names

to be in capitalise case. All relationships should be labelled and identified as Mandatory or

Optional. $*$ All connectivity, participation and cardinalities $($if there are specific limits$)$ should

be shown. $*$ All appropriate entities, attributes and relationships identified. $*$ Assumption to

be included at the beginning of the report. $-$ Explain the relation among Entities. $-$ All

cardinalities and participation between Entities should be explained. $*$ All the relation of

each entity should be identified. $*$ Data Dictionary $*$ Tables with Data for Each Entity