Lo scenario
A multi-branch bookstore chain needs centralized purchasing to negotiate supplier discounts while each branch manages local inventory and customer orders. This ERD models branch, supplier, purchase order, inventory, customer, and order entities with their relationships.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
01
Composite keys for BookAuthor and Inventory capture many-to-many relationships
02
PurchaseOrder is linked to Branch and Supplier to centralize procurement
03
Order and OrderLine separate order header from line items for sales
Use this pattern for retail or multi-location inventory systems that centralize procurement but decentralize sales and stock.