Problem: We have an app where multiple societies and play arenas are registered. Each society/playarena has some amenities ( Swimming pool, Tennis court, badminton court ) etc.

An admin can add/remove amenities and add/remove number of parallel booking allowed for a particular amenity. Example: There can only be 10 people in a swimming pool at a time.

Each slot can be in a quantum of suppose 15 mins for any particular society. Like 12:00 - 12:15, 12:15-12:30, 12:30-12:45, 12:45-13:00 are valid slots. Also the user can book for multiple slots at one go.

You need to provide DB design and interface which models and performs following actions:

• View Available slots for particular amenity for a particular day
• Not allow more than number of parallel bookings allowed for a particular slot
• Book slots which may span over multiple slot quantum ( example of 15 mins )