Entity Relationship Diagram

Film table
language_id is a foreign key in the Film table
  1. One-to-one Relationship
  2. One-to-many Relationship
  3. Many-to-many Relationship
One-to-One relationship
One-to-many relationship
Many-to-Many relationship represented as a pair of one-to-many relationship
  • Conceptual ERD
  • Logic ERD
  • Physical ERD
  • Easier database debugging
  • Can be used as a tool of communication with stakeholders within the business.
  • Aids in requirement gathering.




Data Analyst | BI Analyst | Tableau Expert.

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

Recommended from Medium

Get Flight Data Of Singapore-Kuala Lumpur Air Route Using An API

Baixar Jogo Poker Star Gratis

Jogos gratis para jogar

8 good reasons to not build a mobile application

Part 2: Spin up virtual machine on AWS and use it to host your flask server

Agile, a definition #26

Minikube, kubernetes & Docker: deploy and run containerized Nodejs apps using minikube, on MacOS.

Python Zen in practice

K3s on OCI: A Kubernetes cluster in under 5 mins

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
Yomisola Adegeye

Yomisola Adegeye

Data Analyst | BI Analyst | Tableau Expert.

More from Medium

Types of Relationship in Database

What is an index in SQL?

SQLNotes: Order Details

Top 05 SQL Query Optimization Tips | Devstringx

SQL Query Optimization