シナリオ
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.
この図に含まれるもの
図の背後にある意思決定を読み解く。
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.