Database Systems
Modelling with MySQL Workbench
Modelling with MySQL Workbench
Table of Contents
Conceptual to Logical Design
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)
Binary One-One relationship
- 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