Stored Functions and Procedures

Description

This section contains reusable SQL functions and procedures used for calculations, validation, and reporting.

1. calculate_wedding_total_cost()

Description

Calculates the total cost of a wedding using venue, photographer, and band bookings.

2. is_venue_available()

Description

Checks whether a venue is available for a selected date and time interval.

3. is_photographer_available()

Description

Checks whether a photographer is available for a selected date and time interval.

4. generate_rsvp_summary()

Description

Returns RSVP statistics for a selected event.

SQL Code

{{collapse(View SQL Code) <syntaxhighlight lang="sql"> PASTE SQL FROM advanced_functions.sql </syntaxhighlight> }}