Use-case 0007 - Book Band

Initiating actor: Bride / Groom (Wedding owner)

Other actors: Wedding Organizer (Assistant)

Description

The user reserves a band for the wedding reception/party. Booking includes time window, status and links the wedding with the band.

Scenario

1. The user opens the "Bands" section.
2. The system lists all bands with details.

SET search_path TO project;

SELECT band_id, band_name, genre, equipment, phone_number, price_per_hour
FROM band
ORDER BY band_name;

3. The user selects a band and chooses "Book".
4. The system shows booking form: date, start_time, end_time, status.
5. The user submits booking.
6. The system inserts the band booking.

SET search_path TO project;

INSERT INTO band_booking("date", start_time, end_time, status, band_id, wedding_id)
VALUES (:date, :start_time, :end_time, :status, :band_id, :wedding_id)
RETURNING booking_id;

7. The system confirms and shows booking status.