Function Number: 10
Function Name: Cancel Guest Activity
Link to Function ImplementationFunction Type: Query and Update
Description: This function accepts the following inputs: Guest ID, Activity Name, and Date. This information is used to query a particular record in the table 'assign_activities' and then update its status to 'cancelled.'
Primary Users: Resort staff responsible for tracking guest activities.
Tables Affected: assign_activities
Sample Input: Guest ID = 1, Activity Name = 'Archery', Date = 04/09/2021 10:18 AM
Sample Output: "Activity assignment cancelled"
Notes: This function accepts parameters needed to find a specific record in the table 'assign_activities'. This record is then updated to display activity status as having been cancelled. If the queried activity assignment does not exist in the table, an error message is reported to the user.
Main Menu