CIS 515 Course Great Wisdom / tutorialrank.com CIS 515 Course Great Wisdom / tutorialrank.com | Page 16

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