Entity-Relationship Model v.02

A full-page width image in PNG format of the latest version of the diagram (ERModel_vNN.png)

Entities

List all entities and relationships with the following information for each of them

Entity/relationship name: one paragraph of explanation, what does the entity/relationship represent, why it is needed, why is it modeled the way it is

Candidate keys: If you have multiple candidates for the primary key, list them and explain which one you chose as the primary key and why you chose it as the primary key

List of entity attributes, for each of them: the data type (numeric/text/date/…) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, …)

NAME OF ENTITY/RELATIONSHIP

DESCREPTION OF THE ENTITY/RELATIONSHIP

• Candidate Keys:
  • NAME_OF_KEY (TYPE OF KEY)
• Attributes:
  • NAME_OF_ATTRIBUTE (TYPE, Required/Optional) - DESCREPTION

Relationships

List all entities and relationships with the following information for each of them

Entity/relationship name: one paragraph of explanation, what does the entity/relationship represent, why it is needed, why is it modeled the way it is

Candidate keys: If you have multiple candidates for the primary key, list them and explain which one you chose as the primary key and why you chose it as the primary key

List of entity attributes, for each of them: the data type (numeric/text/date/…) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, …)

Entity-Relationship Model History

List of each version, with a one-sentence explanation of the changes in each version, i.e. what was corrected in that version compared to the previous one. If you made the correction at the request of the teacher/assistant based on a ticket posted in the system, you can link to the ticket instead of an explanation.