السيناريو
Design a database to track costume rentals for theater productions and events, managing inventory, customer orders, and payments.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
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.