Brodfield Tourist Information Centre - Assignment Example

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.

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.Local Business Table: This contains information of all the local businesses, their location, their business, phone, etc. For this table the primary key is the location.Maps of Tourist Spots Table: Maps of all the tourist spots are contained in this table.

The primary key for this table will be location.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 tourist's accommodation, tourist guide name for the tourist, etc.To ensure that no two queries have access to the tables at any single point of time, commits have been used in the stored procedures to ensure that only one query has access to the table at one point of time.

To ensure security against identity thefts, and data leaks, after the initial intake of sensitive tourist information, no further details have been asked so that there is no need to include such information in stored procedures and hence no queries can be generated which retrieve such sensitive information.To reduce the complexity of the whole system, common primary keys have been chosen like Location and Tourist name. This makes retrieving information simple and precise.5. Two key transactions that need to be developed for the BTIC tourism system are:Tourist searching for an accommodation.Tourist