Changes between Initial Version and Version 1 of UseCase0007


Ignore:
Timestamp:
01/10/26 18:01:42 (10 days ago)
Author:
193284
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0007

    v1 v1  
     1= Use-case 0007 - Book Band =
     2
     3'''Initiating actor:''' Bride / Groom (Wedding owner)
     4
     5'''Other actors:''' Wedding Organizer (Assistant)
     6
     7== Description ==
     8The user reserves a band for the wedding reception/party. Booking includes time window, status and links the wedding with the band.
     9
     10== Scenario ==
     111. The user opens the "Bands" section.
     122. The system lists all bands with details.
     13
     14{{{
     15SET search_path TO project;
     16
     17SELECT band_id, band_name, genre, equipment, phone_number, price_per_hour
     18FROM band
     19ORDER BY band_name;
     20}}}
     21
     223. The user selects a band and chooses "Book".
     234. The system shows booking form: date, start_time, end_time, status.
     245. The user submits booking.
     256. The system inserts the band booking.
     26
     27{{{
     28SET search_path TO project;
     29
     30INSERT INTO band_booking("date", start_time, end_time, status, band_id, wedding_id)
     31VALUES (:date, :start_time, :end_time, :status, :band_id, :wedding_id)
     32RETURNING booking_id;
     33}}}
     34
     357. The system confirms and shows booking status.