Situation: You work for a retail company that has stores and operations across "the Americas" - North America, Central, and South America. For business purposes, Central and South America are part of the same overall region and management structure, while North America (U.S., Canada) is a separate region. Currently your company has no data warehouses, data marts, operational data stores, or any other integrated stores of data used for reporting, BI, and analytics. Your company also has an Internet presence with a website from which customers can purchase products. For purposes of this assignment, you are interested in the following seven applications: 1. Supply Chain Operations. North America Region - this application manages all supply chain functions for the company's North America Region. The functions managed by this application include materials and inventory management; vendor management; materials ordering and defective material return; shipping and logistics; warehouse management; etc. 2. Supply Chain Operations. Central/South America Region - this application is identical to the Supply Chain/North America Region application described above, except that it performs the supply chain functions for all of Central and South America. 3. Customer Relationship Master System, Central/South America Region this application contains a master list of all of the company's customers who live in the Central and South America Region. For each customer we also a complete sales history, the names of their top officers and key employees, and other important information that gives us a complete picture of "everything we need to know" about that customer. 4. Customer Relationship Master System. North America Region - this application is identical to the one described above, except that it contains the aforementioned information about all of the company's customers who live in provinces and territories that are included in the North America Region. 5. In-Store Sales System. Central/South America Region - Each of the company's stores has a point-of-sale (POS) system that handles all product purchases, payments, returns, and refunds. All of the stores in the company's Central and South America Region feed data daily from each POS system to a centralized In-Store Sales System for the entire Central and South America Region, which summarizes all sales within the Central and South America Region and also maintains a history of past sales as well. 6. In-Store Sales System. North America Region - This application is identical to the one described above, except that it consolidates and organizes sales data from all of our stores in the North America Region. 7. Online Sales System. North America and Central/South America Regions (combined) - This application handles all Internet sales for all customers regardless of where they live in the Americas, and is a separate sales system than either of the in-store sales systems described above. (For purposes of this assignment, assume that only residents in the Americas - e.g., not in Europe, Asia, or Australia - can purchase products online.) Question \#1 (10 Points) For the scenario described above draw the high-level architecture for a fully centralized enterprise data warehouse (EDW) to support the analytical needs of the entire company. (Helpful hint: make sure that you fully understand what "centralized EDW" means and what one looks like!) Now presume that your company's Chief Information Officer (CIO) is a strong believer in smaller-scale efforts rather than large, enterprise-intensive ones such as CIF or the Dimensional Data Warehouse Bus Architecture. The CIO directs you to define the architecture for a Front End Data Mart approach. (Another helpful hint: make sure you fully understand what the "front end data mart" architecture means and what one looks like...all of it, the entire end-to-end architecture!) Draw the complete high-level architecture for this company's front-end data marts. Make sure you clearly show your data flows from each source component to each target component. The front end data marts on your diagram must reflect the most logical setup, based on the company's operational description and its source systems described at the beginning of this assignment