Design a car rental system. Customers search for available cars, reserve one for a date range, pick it up, return it and pay based on the rental period and any extras.
It must
- The company has branches, each with a fleet of cars of different types.
- Customers search cars by type and date range at a branch.
- A customer reserves a car, picks it up, and returns it.
- The price depends on type, days and extras (insurance, child seat); pricing rules change often.
- A car cannot be reserved twice for overlapping dates.
Keep in mind
- Overlapping reservations of one car must be impossible under concurrent requests.
- Payment itself is out of scope: the design produces the amount.
- One country, one currency to start.