title: Modelling with MySQL Workbench notebook: Database Systems layout: note date: 2020-03-17 13:11 tags: ...
Checklist
- Flatten composite and multi-valued attributes
- Multi-value attributes can be made into another table: do this when the number is likely to be variable/is unknown
- Resolve many-many relationships
- Add foreign keys at crows-foot end of relationships (many side)
- move the key from the one side to the other side
- the optional side of the relationship should get the foreign key
- reduces number of
NULL
values
- reduces number of