Design a high-level conceptual view of a data warehouse (DW) for Huffman Truckin

Question description

An organization has several operational systems: Customer Relationship Management (CRM) for marketing and sales, Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). They also have external customer data. A wide variety of departments utilize this data: sales, marketing, procurement, human resources, R&D, and senior management.Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft® Visio® that shows the following: Integration layersThe data warehouse, with a Star Schema showing a Fact table and various dimension tables with all their needed fields and relationships, as covered in the class material.Recommended data marts Include arrows to show ETL (extract, transform, and load) locations and direction, and paste a screen shot of the above Visio Star schema along with the DW description in a Word document.