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.
  • UC0001 - User Registration - Create a new account for wedding planning.
  • UC0002 - User Login - Access the application using credentials.
  • UC0003 - Create Wedding - Create a new wedding with date and budget details.
  • UC0004 - Manage Guest List - Add and view guests for the wedding.
  • UC0005 - Create Wedding Events - Create and view scheduled events for a wedding.
  • UC0006 - Book Venue - Create a venue booking for the wedding date.
  • UC0007 - Book Band - Reserve a band for a wedding/reception.
  • 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.
  • UC0009 - RSVP for Event - Submit RSVP response for event invitation.
  • UC0010 - View RSVP Status - View guest RSVP statuses per event.

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

Use-case model diagram (optional)

The use-case model diagram is optional. The project provides a relational schema diagram from Phase P2 as an attachment.

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:

• UC0003 - Create Wedding
• UC0006 - Book Venue
• UC0009 - RSVP for Event
• UC0011 - Assign Attendance / Seating