Tour Operator Agency Database. Essay - 697 Words

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 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 leveraging their data sources to enable them to forecast and project tour sales appropriately. Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the†¦show more content†¦You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length. Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper. Using the salesperson table described in the summary above, complete the following: Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1). Create a query that can produce results that show the quantity of customers each salesperson has sold tours to. Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in theShow MoreRelatedTour Operator Agency Database Essay634 Words   |  3 Pagesï » ¿ 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 modelRead 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