Q
Q
Qeinzo2021-10-01 22:33:22
Database design
Qeinzo, 2021-10-01 22:33:22

Why create a third table to link two?

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
61576200b5392687284879.png

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question