Database Systems

Modelling with MySQL Workbench

Modelling with MySQL Workbench

Table of Contents

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


Edit this page.