Tour Operator Agency Database Essay - 634 Words

Tour Operator Agency Database Jeremy Clark Dr. Larisa Bulysheva CIS 515 – Strategic Plan For Database Systems August 14, 2013 Tour Operator Agency Database Week 6 Assignment 5 Mike Jennings Enhanced Database Management Strategy Proposal An efficient data structure design requires a thorough analysis of both the rules a business follows and the relational business objects that allow the production of output for the organization. An efficient model of data should as well require little maintenance and oversight if built properly. Designing a data model promoting data redundancy and normalization provides a design that requires minimal modification to handle. (Tupper 2011) For your†¦show more content†¦For the Tour table in Figure 5 the primary key that I chose I made composite to uniquely identify the attributes related to the purchase of a tour. The composite primary key CustomerID,EmployeeID,TourName,TourDate,TourSeason for the Tour table allows this table to almost act like an invoice for each tour sale. Figure 5 Tour Table 5. My tables were in 1NF and because I had no partial dependencies my tables were now in 2NF Proposed Naming Convention and Entity Attributes The table names â€Å"Employee†, â€Å"Customer†, â€Å"Tour†, and â€Å"TourCost† accurately define the data represented within each table. To better associate the data in the Tour with its operational purpose I will rename to TourInvoice. For this organization I’ve gone back and renamed several entities to better associate the entity to the table it belongs to. For example the FirstName attribute in the EMPLOYEE table was renamed to EMPFirstName to associate this first name attribute with the EMPLOYEE FirstName and not Customer First Name which was changed as well. See the captures below for entity and attribute names and their data types. Figure 6 Naming Convention for Employee and Customer Table Figure 7 Naming Convention for TourCost and TourInvoice Table Proposed Entity Relationship Model Figure 8 Many Customers complete one invoice (TourInvoice) at the sale of a tour. One TourInvoice is assigned a PricePerson contained within the TourCostShow MoreRelatedTour Operator Agency Database. Essay697 Words   |  3 PagesA multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveragingRead MoreTour Operator Agency datbase801 Words   |  4 PagesAssignment 5: Tour Operator Agency Database Due Week 6 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires anRead MoreHow Can Tour Operators Use the Internet to Overcome the Problems of Intangibility and Perishability in Selling Holiday Packages?1540 Words   |  7 Pagesinformation-intensive industry and is said to hold together different components belonging to the travel industry, such as airlines, travel agencies, attractions, car rental and several other aspects (Poon, 1993). The main objective of a tour operator is to combine these components to create a holiday package. With the advent of the internet, tour operators can now expand their activities and make available relevant information, conquering new customers (Wyner, 2000). However, in order to do so effectivelyRead MoreNew Technology2240 Words   |  9 Pagesfor our everyday life. Most of the industries have set their new value propositions to adjust themselves to the new technologies. Without exception for tour operating industry, they are experiencing a big impact from those technologies and also responding to them and trying to develop in the trend. This assignment will discuss the influence for UK tour operating industry from new technologies and also the industry’s adjustment to the technologies. 2. Context 2.1. Economic background ThoughRead MoreRecommendations for a Travel Agency3842 Words   |  16 PagesHR Indian Tour Operators Analysis of Customized Tour Services Submitted By: Sumedha Bhardwaj (32156) Sonal Bhat (32157) Bhavika Mehta (32227) Esheet Modi (32228) Mahim Mongia (32229) Jyoti Saxena (32241) Contents 1. Executive Summary 2. Analysis Approach 3. Competency Model for Tourism Agents 4. Field Research: Onsite Mystery Shopping 5. Problems: People and Processes 6. Solutions and Evaluation of Alternatives 7. Recommendations 8. Conclusion Executive Summary Customized Tours form an importantRead MoreTravel Agents5030 Words   |  21 Pagesoffer them advance booking services. Another responsibility of travel agents is to give important pieces of advice to the clients before the holiday such as: weather, vaccination and offer passport and visa services. DIFFERENT TYPES OF RETAIL AGENCIES Independent This is the type of travel agents that has only one business firm. For this reason, it is not part of a chain and is usually owned and managed by a single proprietor. The products and services that this type of travel agent is saidRead MoreConduct a Marketing Audit Major Assignment10193 Words   |  41 Pages | |Code: |National : BSBMKG515A | |Title of Report: |Conduct a marketing audit – Aussie One Travel Agency | |Mode: |Individual project | |Read MoreOnline Travel Agency Supply Chain1684 Words   |  7 PagesTravel Agency Supply Chain Travel Agency Supply Chain With eCommerce technology rapidly improving and the number of people using the Internet increasing everyday, brick and mortar travel agencies are turning to non-traditional methods when developing their supply chain. Over the past 10 years the supply chain of the travel agency has evolved tremendously in order to incorporate the use of websites to promote online sales. In the following paper we will first describe the supply chain forRead MoreAbercrombie And Kent Tourism Systems And Practises Essay1966 Words   |  8 Pagesintermediaries as organisations prefer distributing products directly. This report studies the dimensions of Abercrombie and Kent tourism systems and practises. The report studies the impact of e-business on the distribution strategies of travel agencies and the importance of distribution channels. Moreover, in context with the Abercrombie and Kent the report studies the distribution strategies and its importance on the performance of the company. Overview of the company: Abercrombie Kent wasRead MoreThe Tourism Promotion Efforts Of Tunisia Essay3010 Words   |  13 Pagesis an effective way to promote museum inside and outside. It also contains comments with audio and video about the pieces on display, and the visitor can use it for free by choosing three paths according to his/her desire: †¢ The path of exploration: tour includes all the basic constituent parts of the museum. †¢ The Path mosaic: a private group to enjoy the Roman mosaic round. †¢ The custom path for children: to discover the games and entertainment during the period of the Romans. As a result, thanks