The scenario
A high-end fashion rental business needs a database to manage customer rentals of designer clothing. Key decisions include tracking rental periods, pricing, and maintaining item availability.
What is in this drawing
Read the decisions behind it.
01
Modeling rental items as a junction entity with rental and item references, with quantity and price.
02
Including payment history per rental.
03
Using category to group clothing types.
When designing a rental system database for physical goods with inventory tracking and customer transactions.
More like this