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

CI/CD with Github, Travis, and DigitalOcean

Advanced Pandas

Chatbot with QnA maker & Azure Bot Services

Orchestration Pattern

OutSystems Engineering Blog Highlights in 2018

Tbank — Debut

How to send logs to a particular Splunk index using Fluent Bit

The Benefits of Cloudscaff Scaffold Management Software

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

SELECT statement for SQL

SELECT statement for SQL

What is an index in SQL?

SQL Exercises 8 — Subqueries