Tuesday 21 August 2012

ERD making tips

  • Make a list of potential entities and attributes that scenario mentions
  • Draw your entities and their relationships.(Do not forget relationship types!)
  • If needed, consider using super and subtypes to handle some requirements of the scenario better.
  • Give each entity their attributes and feel free to add extra ones to make your database more encompassing.
  • Fix up any many to many types by adding composite entities.
  • Read the given scenario again and make sure that your ERD handles all its requirements.

No comments:

Post a Comment