= Phase P3: Application Scenarios for DB Access (SQL)

== Use-case model

This phase defines the main application use cases and usage scenarios, describing how the implemented database schema will be used by different actors (roles).  
The system supports wedding planning activities such as managing weddings, venues, events, guests and bookings (venue, band, photographer), as well as RSVP and attendance tracking.

== List of Actors / Roles

 * *Bride / Groom (Wedding owner)* - Registered user who manages the wedding, budget, notes, bookings and guest list.
   * [wiki:UseCase0001 UC0001] - User Registration - Create a new account for wedding planning.
   * [wiki:UseCase0002 UC0002] - User Login - Access the application using credentials.
   * [wiki:UseCase0003 UC0003] - Create Wedding - Create a new wedding with date and budget details.
   * [wiki:UseCase0004 UC0004] - Manage Guest List - Add and view guests for the wedding.
   * [wiki:UseCase0005 UC0005] - Create Wedding Events - Create and view scheduled events for a wedding.
   * [wiki:UseCase0006 UC0006] - Book Venue - Create a venue booking for the wedding date.
   * [wiki:UseCase0007 UC0007] - Book Band - Reserve a band for a wedding/reception.
   * [wiki:UseCase0008 UC0008] - Book Photographer - Reserve a photographer for the wedding.

 * *Guest* - Invited person who is stored in the guest list and can RSVP for specific events.
   * [wiki:UseCase0009 UC0009] - RSVP for Event - Submit RSVP response for event invitation.
   * [wiki:UseCase0010 UC0010] - View RSVP Status - View guest RSVP statuses per event.

 * *Wedding Organizer (Assistant)* - Staff role that can manage logistics: events, attendance and seating roles.
   * [wiki:UseCase0011 UC0011] - Assign Attendance / Seating - Assign table number and role per guest per event.
   * [wiki:UseCase0012 UC0012] - View Event Attendance Summary - View attendance list and stats per event.


== Realization details on selection of the most important use cases in the database

The most important use cases (documented in more detail with tested SQL scenarios) are:

 * [wiki:UseCase0003 UC0003] - Create Wedding
 * [wiki:UseCase0006 UC0006] - Book Venue
 * [wiki:UseCase0009 UC0009] - RSVP for Event
 * [wiki:UseCase0011 UC0011] - Assign Attendance / Seating