UseCase003 Implementation - Venue availability check

Initiating actor

User / Wedding organizer

Other actors

Venue manager (optional)

Goal

Check if a venue is available for the selected date/time and prevent double-booking conflicts.

Scenario

Step 1: User opens availability check

The user selects a venue and chooses the desired date/time.

SQL:

SELECT v.venue_id, v.name
FROM venue v;

Step 2: System checks availability

The system checks if there is an existing reservation for the selected time range.

SQL:

SELECT b.booking_id, b.venue_id, b.start_time, b.end_time
FROM venue_booking b
WHERE b.venue_id = :venueId
  AND b.start_time < :selectedEnd
  AND b.end_time > :selectedStart;

Step 3: Result

If no rows are returned -> venue is available. If rows exist -> conflict detected and booking is not allowed.

Demo data

Venue: (example name) Date: (example date) Time: (example time)