El escenario
Design a database to track costume rentals for theater productions and events, managing inventory, customer orders, and payments.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
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.