El escenario
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.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.