Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle PL SQL Language Pocket Reference

Authors: Steven Feuerstein, Bill Pribyl, Chip Dawes

4th Edition

0596514042, 978-0596514044

More Books

Students also viewed these Databases questions