Get my free SQL Cheat Sheets: https://www.databasestar.com/getsql...
Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd...
A manytomany relationship is where many records in one table can relate to many records in another table.
In this video, you'll learn:
What a manytomany relationship is (with an example)
Why a manytomany 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 manytomany 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