The scenario
A bookstore needs to manage used book inventory, customer trade-ins, multi-author books, and sales orders in a relational database.
What is in this drawing
Read the decisions behind it.
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.
More like this