Tips for creating an ERR Diagram — Design tips

Informal guidelines for relation design:

Tip 1: The schema design process should be considered an iterative refinement process

Tip 2: Proper Naming of Schema Constructs

Tip 3: Design choice entity type, attribute or relationship type

Tip 4: Choosing between Binary and Ternary…

Tip 5: Design Choices for Specialization/Generalization

Tip 6: The diagram should be connected, no part should be isolated

Tip 7: Test the relationships cardinality

  • Use extreme cases
  • Use 1:1
  • Other cases that must be true according to the description of the problem
  • Other cases that must be false according to the description of the problem

Tip 8: Test that the relationship has the correct degree

  • Test 1: Is it possible that there are more entities in a relationship instance than the degree of the relationship? If yes, then there is a problem
  • Test 1: Is it possible that there are fewer entities in a relationship instance than the degree of the relationship? If yes, then there is a problem
  • If the is a relationship between 2 entities of the entity types, then unary
  • If the is a relationship between 2 entities of 2 different entity types, then binary
  • If the is a relationship between 3 entities of 3 different entity types, then ternary.

Tip 9: Identify the entity types, relationship types and attributes directly in the document with different colors

Other useful resources & link

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Creating a docker image of a web application written in Go Lang #100DaysOfCode

AuroraFS

How To Set Up a Mailserver Within a Docker Swarm

How To Set Up A Mailserver Within A Docker Swarm

Junior vs. Senior vs. Staff Engineer

Understanding DevOps Tool — Docker Compose

Understanding DevOps Tool - Docker Compose

Compare Rails routes. The quick way.

How to create your first Slack bot mockup

Secure Hybrid Cloud Video Transport With Haivision and Microsoft Azure

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alvaro Andres Pinzon Cortes

Alvaro Andres Pinzon Cortes

More from Medium

How To Beat Imposter Feelings

How to quantifiably improve maintainability of your code using Code Climate for free on GitHub

A better way to view and define failure

What Do Engineers Even Do?