The purpose of this assignment is to promote students′ analytical skills in anal

Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!

The purpose of this assignment is to promote students′ analytical skills in analyzing a case scenario and utilizing the given information and resources to design an ER diagram and develop an OLAP database.
You are required to use any available to tool to design an OLAP database based on the scenario.
Develop an ER Diagram that shows all tables, (attributes) and relationships.
The accepted file formats are MS Word or PDF file format.
Include a title page with your name and case project title. Name your file as follow: Lab1_YourLastName.docx.
Coffee Merchant Enterprises (CM) sells coffee from a variety of different countries to consumers in the US. Their sales are all on-line. Their OLTP database for handling their day-to-day operations is shown in the ER Diagram below. Note: Select the image to view larger.
CM wants to make data more available to their marketing analysts so that they can develop more effective marketing programs. They want to accomplish this goal without slowing down the performance of their existing OLTP system. They have decided to create a Data Warehouse to provide the information that the marketing analysts need. Your task is to design the database for the Data Warehouse.
The marketing analysts have asked for the ability to see sales data by product (inventory), consumer, employee who placed the order, and by various date variables including date, week, quarter, year, day of the week, and season. They do not need to see every sale but would need to see product sales summarized for each product on a daily basis.

Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)

NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.

NB: All your data is kept safe from the public.

Click Here To Order Now!