O cenário
A bookstore needs to manage used book inventory, customer trade-ins, multi-author books, and sales orders in a relational database.
O que há neste desenho
Entenda as decisões por trás dele.
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.