DB- week4

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 using Microsoft^® Visio^® that shows the following:

• Integration layers
• The data warehouse
• Recommended data marts 

Include arrows to show ETL (extract, transform, and load) locations and direction.