Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
Tour
Databasing Inquiries
Design a data model that will conform to the following criteria:
• Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.
The database in question provides sufficient data for operational consistency but the redundancy of certain data impedes the general efficiency of the system in place. Therefore, normalization is a major priority for the tour operating company. Specifically, the database is overburdened by duplicate customer records, each of which is created at the time that a new tour is booked. This denotes that the system is decidedly inefficient in presenting data on the whole of our customer base.
First, we propose the use of framing as a data structure as a way of refining the representation of data. According to the text by Minsky (1974), individual frames are used to distill bits of data before drawing a connection between theme. According to Minksy, "Attached to each frame are several kinds of information. Some of this information is about how to use the frame. Some is about what one can expect to happen next. Some is about what to do if these expectations are not confirmed....
We can think of a frame as a network of nodes and relations. The 'top levels' of a frame are fixed, and represent things that are always true about the supposed situation. The lower levels have many terminals -- "slots" that must be filled by specific instances or data." (Minsky, p. 1)
In our emergent data strategy, the top levels would refer to immutable data such as employee names and ID#s. Contrary to the previously existing strategy of databasing, this approach calls for all tour information, including tour clients and all related data, to be subordinated under tour operator accounts. This is consistent with the method of data structuring proposed by Chapple (2011), which indicates that avoiding duplicate data requires the minimization of duplicate columns from the initial data table and, consequently, the creation of "separate tables for each group of related data and identify each row with a unique column (the primary key)." (Chapple, p. 1)
The text goes on to indicate that "the first rule dictates that we must not duplicate data within the same row of a table. Within the database community, this concept is referred to as the atomicity of a table. Tables that comply with this rule are said to be atomic." (Chapple, p. 1)
This means that the best way to manage the…
Works Cited:
Chapple, M. (2009). Normalizing Your Database: First Normal Form (1NF). About Databases.
Minksy, M. (1974). A Framework for Representing Knowledge. MIT-AI Laboratory Memo 306.
E-Commerce on Business Strategy The purpose of this literary review is to determine the effects and impacts of e-commerce on business strategies and internal processes with particular emphasis on the travel industry. Our review will include material from several different sources including the Sloan Management Review, Travel Weekly and white papers from Ernest & Young. We will begin by defining E-commerce and the impact of it in the new economy. Subsequently we
In this regard, Higgins (2002) reports that Micros Systems Inc. introduced a custom application specifically for the hospitality industry early on, and despite the lingering effects of the September 11, 2001 terrorist attacks on the market, this company and others such as BDM International Inc. are continuing their efforts to provide hotels, restaurants and other organizations competing in the hospitality industry with the information technology they need to become
" According to Kaur (2009) Many government and tourist agencies have adapted their organizations to offering services that are related to ecotourism activities. A high fiscal commitment is also contributed by the Ministry for its development. For instance, a total of RM1,009 billion was allocated for the development of the tourism industry during the Eighth Malaysia Plan [8 MP] (Eighth Malaysia Plan, 2001 in: Kaur, 2009). Malaysia claims a vast range
LO1 Human resources management applies the concept of hiring and developing employees so they ultimately contribute more value to an organization or business. As it applies to tourism, people hired by the tourism industry are often instructed to work low paying, low skill jobs that do not encourage better workers, nor improvement within the workplace. This can hurt the industry because it is important to understand that tourism as a whole
International Regulation of Tourism in Antarctica Since the mid-1980s, Antarctica has been an increasingly popular tourist destination, despite the relative danger of visiting the largest, least explored -- and arguably least understood -- continent on earth. Beginning with the 1959 treaty establishing Antarctica as an international zone free of claims of sovereignty by nation's that had been instrumental in establishing research stations there, there has been almost constant negotiation about how
In summary, we recommend that the IESBA reconsiders the proposals in the Exposure Draft and provides more guidance on safeguards applicable to sole practitioners and small accounting firms to ensure that the benefits of the changes outweigh the costs to SMEs. Under a principle-based approach, there should be safeguards and practical relief for all practitioners rather than rules-based outright prohibitions. The rewrite of this Independence component of the Code