Give Each Order–Product Pair a Place

An order contains many products, and a product can appear in many orders. A relational schema represents this many-to-many relationship with an associative entity called OrderItem. Each OrderItem belongs to one Order and one Product, while qty records how many of that product the order contains.