The scenario
Design a database to track costume rentals for theater productions and events, managing inventory, customer orders, and payments.
What is in this drawing
Read the decisions behind it.
01
Included RentalLine to handle many-to-many between orders and costumes with quantity and rental days.
02
Separated Category entity to organize costumes.
03
Linked Payment as optional one-to-one to support unpaid orders.
This ERD pattern suits any rental business with item inventory, customer orders, and optional payment tracking, such as tool rental, equipment rental, or library systems.
More like this