Devrol Patterson - Outlook X M Question - ClassMarker x M ClassMarker (#0 Question 2 of 4 Points: 24 Your industrial supply company wants to create a data warehouse from which management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in several systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems. a. Use the MIS four-step problem solving process to propose a format along with sample files from the two systems that could supply the data for the data warehouse. [9 Marks] Then answer the following questions: b. What business problems are created by not having these data in a single standard format? Marks) c. How easy would it be to create a database with a single standard format that could store the data from both systems? Identify the problems that would have to be addressed. [3 Marks] d. Should the problems be solved by database specialists or general business managers? Explain. [3 Marks] e Who should have the authority to finalize a single company-wide format for this information in the data warehouse? [3 Marks] f. How do social search semantic search, and mobile search differ from searching for information on the web by using conventional search engines? 14 Marks] S Devrol Patterson - Outlook X M Question - ClassMarker x M ClassMarker (#0 Question 2 of 4 Points: 24 Your industrial supply company wants to create a data warehouse from which management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in several systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems. a. Use the MIS four-step problem solving process to propose a format along with sample files from the two systems that could supply the data for the data warehouse. [9 Marks] Then answer the following questions: b. What business problems are created by not having these data in a single standard format? Marks) c. How easy would it be to create a database with a single standard format that could store the data from both systems? Identify the problems that would have to be addressed. [3 Marks] d. Should the problems be solved by database specialists or general business managers? Explain. [3 Marks] e Who should have the authority to finalize a single company-wide format for this information in the data warehouse? [3 Marks] f. How do social search semantic search, and mobile search differ from searching for information on the web by using conventional search engines? 14 Marks] S