= 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.