CIS 515 STUDY Future Starts Here/cis515study.com CIS 515 STUDY Future Starts Here/cis515study.com | Page 15

This Tutorial contains 2 Papers

CIS 515 WEEK 6 ASSIGNMENT 5 TOUR OPERATOR AGENCY
DATABASE

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