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:Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:Your assignment must follow these formatting requirements: