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

Опубликовано: 02 Апрель 2019
на канале: Database Star
177,154
4.2k

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd...

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


Смотрите видео How to Correctly Define Many-To-Many Relationships in Database Design онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Database Star 02 Апрель 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 177,15 раз и оно понравилось 4.2 тысяч людям.