HDTutorial
EN
How to Correctly Define Many-To-Many Relationships in Database Design

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Correctly Define Many-To-Many Relationships in Database Design

211,559 views October 25, 2019 7:07

Watch on YouTube
ChannelDatabase Star

Chapters

Description from the creator

📝 Get my Database Design Guides to many different sample databases: databasestar.mykajabi.com/lpkj-dbdesign/?video=…
🎓 Get the 7-step framework I use to design any database: databasestar.mykajabi.com/offers/TFwo4zhX/check…

A many-to-many relationship is where many records in one table can relate to many records in another table.

In this video, you'll learn:
What a many-to-many relationship is (with an example)
Why a many-to-many relationship has issues with modeling like a normal relationship
The solution to the problems caused by this relationship
How to update your ERD (Entity Relationship Diagram) to include the new solution

Timestamps:
00:00 Introduction
00:30 What is a many-to-many relationship?
01:27 Student and class example
02:34 Solution to this problem
03:18 Design of the tables
05:47 Name of the table

About this tutorial

Database Star published this 7:07 video tutorial on October 25, 2019. It has been watched 211,559 times on YouTube.

Duration
7:07
Published
October 25, 2019
Views
211,559
Likes
5,154

Tags

Share

Further reading

  • How to Handle a Many-to-Many Relationship in Database Design ... dzone.com

    Learn how to handle many-to-many relationships in database design with an example of creating a database for a university about students and classes.

  • Database Design - Many-to-many web.csulb.edu

    There is a fourth type, the many-to-one relationship, however, that is just the reverse direction of the one-to-many relationship. This article introduces a design pattern for the many-to-many relationship, and shows th…

  • Many-to-many Relationships Definition(A-> B[0], A -> [B]1, A ... relationaldbdesign.com

    1) First Problem: The relational data model cannot handle many-to-many relationships directly and is limited to one-to-one and one-to-many relationships. This means that you must replace the many-to-many relationships t…

This tutorial in other languages