How to make an order table with a floating number of items?

Question

Database design

Tell me how to make a table of orders with a floating number of products?
How to store all products and their quantities in a table, so that later we can open this order and get the values ​​\u200b\u200bof these products and prices from other tables.

Answer 1

This is called a many -to-many relationship :
Example-many-to-many relationship