Why create a third table to link two?

Q

Qeinzo2021-10-01 22:33:22

Database design

Qeinzo, 2021-10-01 22:33:22

Now I watch logical models of a DB. Please explain why in the example below we created the "Order Details" table? Why couldn't the first and last tables be joined together?

spoiler

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Alexander, 2021-10-01
@Qeinzo

Because the same item can be in multiple orders, and the same order can have multiple items

Similar questions

R

R000M2015-05-26 13:08:15

Why won't Thunderbird and Outlook recognize WoSign's SSL certificate? 2Reply

A

Alexsey2014-12-06 14:33:44

Logical database design. ER diagrams ? 0Reply

S

Stanislav2019-05-03 19:04:50

Django ORM: database structure and query building for dynamic filter? 1Reply

Z

z0ng2019-05-04 14:04:01

What is the best way to organize a database for playlists with music? 1Reply

A

Andrey Boychenko2019-05-08 14:24:44

Layered structure of categories, subcategories, features and products? 1Reply

Didn't find what you were looking for?

Ask your question