CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 14

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 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