シナリオ
A bookstore needs to manage used book inventory, customer trade-ins, multi-author books, and sales orders in a relational database.
この図に含まれるもの
図の背後にある意思決定を読み解く。
01
Model trade-ins as separate TradeIn and TradeInItem tables linked to Customer and Book inventory
02
Use composite key associative table BookAuthor to support many-to-many book-author relationships
03
Normalize sales via Order and OrderItem for many books per order
Reuse for retail or library systems with inventory, orders, authors, and buy-back or trade-in workflows.