| 5 | | == Data requirements |
| | 5 | == Entities |
| | 6 | |
| | 7 | List all entities and relationships with the following information for each of them |
| | 8 | |
| | 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 | 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 | |
| | 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 | **NAME OF ENTITY/RELATIONSHIP** |
| | 16 | |
| | 17 | DESCREPTION OF THE ENTITY/RELATIONSHIP |
| | 18 | |
| | 19 | * **Candidate Keys:** |
| | 20 | * NAME_OF_KEY (TYPE OF KEY) |
| | 21 | * **Attributes:** |
| | 22 | * NAME_OF_ATTRIBUTE (TYPE, Required/Optional) - DESCREPTION |
| | 23 | |
| | 24 | |
| | 25 | == Relationships |