Generated queries need to be simple and effective to enhance the operation speed of the system.
Customer Information Table: This table will hold all of the possible information related to the tourist such as the name of the tourist, phone number, address, etc. Here the Tourist name will be the Primary key.
Information Guide List: This table has information of the Tourist Information Guides and the tourist names each of them handled, their supervisor, demographic information of each of the Information Guide, etc. The primary key for this table will be the Tourist Name.
Tourist Guide Table: Tourist Guide table contains information of the tourist guides, their demographic information and the tourist name they are supposed to guide and the start/end dates for each of the tourist. Here too the primary key will be the tourist name.
Reservation Table: The reservation table contains information of the tourist name, the start and the end dates of stay of the tourist, secure information such as credit card details, account details, social security numbers, and other information like the location of the touri ...