Assignment 5: Tour Operator Agency Database

Assignment 5: Tour Operator Agency Database
May 20, 2016 by
Assignment 5: Tour Operator Agency Database
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 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 system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:
A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.
A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.
A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.
Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:
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.
Create naming conventions for each entity and attributes.
Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. 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 the required assignment page length.
Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.
The specific course learning outcomes associated with this assignment are:
Explain the fundamentals of how data is physically stored and accessed.
Compose conceptual data modeling techniques that capture information requirements.
Design a relational database so that it is at least in 3NF.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Use technology and information resources to research issues in the strategic implications and management of database systems.
Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.
Answer not yet available
To have this question done by our pool of professional writers, you can resubmit it here
Categories
Uncategorized
Control Functiont Analysis
International Business

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
Assignment 5: Tour Operator Agency Database
Get a 15% Discount on this Paper
Order Now
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with MyCoursebay
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Nursing
Writer did an excellent job! Thank you.
Customer 452693, January 14th, 2022
Database design and optimization
thanks for busting this out so expeditiously. I hope that I get a good grade.
Customer 452715, February 19th, 2022
Psychology
Thanks so very much. The paper is well-researched and adequately referenced. You have been of great help during the pandemic!
Customer 452467, January 31st, 2021
Nursing
Thank you so much for being the best website for assignment help.
Customer 452635, June 24th, 2022
Professions and Applied Sciences
Thank you!
Customer 452707, March 4th, 2022
Nursing
This is great! Thank you
Customer 452679, December 16th, 2021
Technology
Excelled job on the paper!
Customer 452885, December 28th, 2022
Nursing
Thank you for a great paper!!
Customer 452707, November 28th, 2022
Other
Thank you for a well written paper!!!
Customer 452557, January 19th, 2022
Psychology
Good mastery of ABA concepts. Excellent!
Customer 452469, May 14th, 2022
Social Work and Human Services
Excellent Work
Customer 452587, November 22nd, 2021
Education
Thank you so much for all the help, I really appreciate it!
Customer 452631, November 3rd, 2021
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Get top-notch homework help now. 20% off first 10 orders!

NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now