Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q5. Total of 20 points) Suppose that a data warehouse of a local chain store consists of three dimensions: 1) date, 2) location, and 3)
Q5. Total of 20 points) Suppose that a data warehouse of a local chain store consists of three dimensions: 1) date, 2) location, and 3) product_type; and one measure dollar_sold, where dollar_sold is the dollars sold of a certain type of product on a certain date at a specific location. product_type may be "electronics", "food", or "books" A) (IO points) Draw a star schema diagram for the data warehouse. You may design your own attributes for the dimension tables. (You can use any design or drawing products. If you don't have any at hand, you might consider the online tool ERDPlus: https://erdplus.com) B) (10 points) Starting with the base cuboid [date, location, product_typel, what specific OLAP operations should be performed to list the total dollars sold of electronics at the branch store(s) at Mong Kok in April 2018? You may make your own assumptions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started