Database Systems

Modelling with MySQL Workbench

Table of Contents

• Conceptual to Logical Design
  • Binary One-One relationship

Conceptual to Logical Design

Checklist

1. 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
2. Resolve many-many relationships
3. 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

---