Changes between Version 4 and Version 5 of Testing and Validation

Timestamp:

05/13/26 20:09:52 (13 days ago)

Author:

193284

Comment:

--

Testing and Validation

@@ -145 +145 @@
 Displays grouped RSVP statistics for guests and events.
 
-== 8. Constraint Validation Test ==
+== 8. Vendor Booking Overview View Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+SELECT *
+FROM vw_vendor_booking_overview;
+}}}
+
+=== Expected Result ===
+
+Displays venue, photographer, and band booking information for weddings.
+
+== 9. Upcoming Weddings View Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+SELECT *
+FROM vw_upcoming_weddings;
+}}}
+
+=== Expected Result ===
+
+Displays weddings scheduled for future dates only.
+
+== 10. RSVP Summary Procedure Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+CALL generate_rsvp_summary(1);
+}}}
+
+=== Expected Result ===
+
+Displays NOTICE messages containing accepted, declined, and pending RSVP counts for the selected event.
+
+== 11. Constraint Validation Test ==
 
 === SQL Code ===