StudentShare solutions
Triangle menu

Brodfield Tourist Information Centre - Assignment Example

Not dowloaded yet

Extract of sample
Brodfield Tourist Information Centre

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 ...Show more

Summary

3.One of the several features of the developed BTIC tourism model is the billing feature which requires the tourist to provide sensitive information like credit card details, bank account number or even social security number in some cases. Taking this into consideration, Security is the key factor in the BTIC tourism model…
Author : jaren94
Brodfield Tourist Information Centre essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Brodfield Tourist Information Centre"
with a personal 20% discount.
Grab the best paper

Related Essays

Apple Tree Lane Child-Care and Nursery Centre
Apple Tree Lane Child-Care and Nursery Centre is a privately-owned nursery utilising local rental space in the village hall in order to maximize customer volume and provide more efficient child care services.
12 pages (3000 words) Assignment
Sales and Merchandising: Home Centre
This research is being carried out to critically evaluate current approaches to merchandising decisions and advise on their improvement; demonstrate strategies using following concepts to illustrate the home Centre strategies; and advise on an appropriate sourcing and buying strategy in context of Home Centre’s retail management. The report provides recommendations on the required changes to be made in the new outlet.
16 pages (4000 words) Assignment
Scottich Dolphin Centre, Spey Bey, Moray
But the question is how well this can be achieved the things that should be done to accomplish the vision. Tourism that is done on the basis of visitors engaging with the wild animals is substantially attracting more interests from different governments, researchers and the industry of tourism.
14 pages (3500 words) Assignment
Tourist Destination
2; Lubbe, 2003, p.2). Eminent scholars and experts have defined tourism as a collection of industries, services and activities that delivers an overall travel experience including accommodations, transportations, fooding and lodging, and other associated hospitality services (PRM, n.d).
12 pages (3000 words) Assignment
Wireless Network System for an IT Training Centre
Users can access the network without any physical contact with the main server. This facility has been made available by the introduction of modulation techniques into networking. The information to be shared between the users is made to superimpose on certain radio frequencies acting as carriers.
14 pages (3500 words) Assignment
Project Analysis St. Mary Shopping Centre Thornbury
The proposed site is located in St. Mary Street, Thornbury Town, that is in South Gloucestershire County and the proposal was to make the shopping centre with the name and style of St. Mary shopping Centre. The site is in the ownership of South Gloucestershire Council and can be leased on a long term basis.
16 pages (4000 words) Assignment
Tourist Industry
The Information Communication Technology (ICT) is under utilized. Few managers are trained in the fine points of the ICT systems and don't realize that it can be used for remote decision-making and storing/capturing information. Staff is unhappy with the arrangement of incentive scheme and tension is running high between the local management and the sales staff.
18 pages (4500 words) Assignment
Project Management: The Grove Student Retreat Centre
The researcher analyzes his duties as Project Manager and leader of the project team as to make an appeal to everyone for support, understanding and full cooperation towards our new colleagues, provide them with support and intervention, whenever needed and I initiate full-day training sessions on leadership and communication skills.
12 pages (3000 words) Assignment
Stereotypes and the tourist role
people to visit various destination places, increasing the need for exploring the adventurous positions and artistic places worldwide and creation of the tourist destinations in numerous countries for making the tourism industry an integral part of their economies (Bender,
8 pages (2000 words) Assignment
The Call Centre and Tengo Ltd
tomer service division has recently suffered from a consistently increasing employee turnover which has now surpassed the industry benchmark of average employee turnover. The customer contact centre has also received repeated complaints of poor customer service quality as a
10 pages (2500 words) Assignment
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation