Changes between Version 3 and Version 4 of Testing and Validation

Timestamp:

05/13/26 17:51:33 (13 days ago)

Author:

193284

Comment:

--

Testing and Validation

@@ -99 +99 @@
 Returns FALSE if the photographer already has a conflicting booking.
 
-== 5. Wedding Financial Summary View Test ==
+== 5. Band Availability Function Test ==
+
+=== SQL Code ===
+
+{{{
+#!sql
+SELECT is_band_available(
+    1,
+    '2026-06-20',
+    '18:00',
+    '22:00'
+);
+}}}
+
+=== Expected Result ===
+
+Returns FALSE if the band already has a conflicting booking.
+
+== 6. Wedding Financial Summary View Test ==
 
 === SQL Code ===
@@ -113 +131 @@
 Displays wedding budget information, total booking expenses, and remaining budget calculations.
 
-== 6. RSVP Overview View Test ==
+== 7. RSVP Overview View Test ==
 
 === SQL Code ===
@@ -127 +145 @@
 Displays grouped RSVP statistics for guests and events.
 
-== 7. Constraint Validation Test ==
+== 8. Constraint Validation Test ==
 
 === SQL Code ===