상황
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.