| | 1 | Entity-Relationship Model v.NN - where NN is the current version |
| | 2 | Diagram |
| | 3 | |
| | 4 | A full-page width image in PNG format of the latest version of the diagram (ERModel_vNN.png) |
| | 5 | |
| | 6 | Data requirements |
| | 7 | |
| | 8 | List all entities and relationships with the following information for each of them |
| | 9 | |
| | 10 | 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 |
| | 11 | 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 |
| | 12 | List of entity attributes, for each of them: |
| | 13 | the data type (numeric/text/date/…) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, …) |
| | 14 | Entity-Relationship Model History |
| | 15 | 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. |
