= Testing and Validation =

== Description ==

This section contains SQL scenarios used for testing trigger behavior and advanced database validation.

== 1. Venue Booking Conflict Test ==

{{{
INSERT INTO venue_booking(
    "date",
    start_time,
    end_time,
    status,
    price,
    venue_id,
    wedding_id
)
VALUES (
    '2026-06-20',
    '18:00',
    '22:00',
    'confirmed',
    5000,
    1,
    1
);
}}}

Expected Result:
The trigger prevents overlapping bookings.

== 2. RSVP Validation Test ==

{{{
INSERT INTO attendance(
    status,
    table_number,
    role,
    guest_id,
    event_id
)
VALUES (
    'attending',
    3,
    'Guest',
    1,
    1
);
}}}

Expected Result:
Guests who declined RSVP cannot be marked as attending.