Changes between Version 1 and Version 2 of ERModel
- Timestamp:
- 05/01/26 17:17:32 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v1 v2 1 Entity-Relationship Model v.NN - where NN is the current version 2 Diagram 1 == Entity-Relationship Model v.02 3 2 4 3 A full-page width image in PNG format of the latest version of the diagram (ERModel_vNN.png) 5 4 6 Data requirements5 == Data requirements 7 6 8 7 List all entities and relationships with the following information for each of them 9 8 10 9 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 10 11 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 12 13 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, …) 14 15 == Entity-Relationship Model History 16 15 17 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.
