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.
The purpose of this assignment is to promote students′ analytical skills in anal
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
