Print Lodging History

Function Number: 16

Function Name: Print Lodging History

Function Type: Query (Four Tables)

Description: This function accepts a Guest ID number as input and will output a table describing a guest's lodging history at the resort. If a reservation has been cancelled, it's records will have been deleted from this table and will therefore not be displayed.

Primary Users: Resort staff responsible for managing guest reservations and assigning lodging to guests

Tables Affected: guests, booking, assign_lodging, and reservation

Sample Input: Guest ID = 1

Sample Output: A table displays all lodging assignments associated with Guest ID 1 that have not been cancelled.

Notes: This function queries four tables in order to gather all output information. If the provided Guest ID does not exist, or if it does not yet have any lodging history, or if any other error occurs, the appropriate message will be displayed to the user.