Objectives This assessment item is to develop a conceptual data model based on the following case study. It relates to the unit learning outcome numbers 1 and 3 in the unit profile. Assessment task In...

Objectives
This assessment item is to develop a conceptual data model based on the following case study. It relates to the unit learning outcome numbers 1 and 3 in the unit profile.


Assessment task

In this assignment, you are going to perform the entity-relationship data modelling based on the following application scenario.

1

Entities have been identified, named and drawn correctly including super type and sub type entities; associative entities; weak entities (if any).
2

Provided appropriate attributes for all the entities.
3

Provided identifiers for all the entities

4

Drawn correct relationships between entities and named them appropriately.

5

Used proper symbols and shown min and max cardinalities for the relationships. Appropriate symbols have been used for super type and sub type relationships (if any)

6

Provided appropriate justification for assumptions and business rules.

7

Definitions of entities and relationships

8

Coverage-

Whether the modelling has covered the application scenario