Exercise 1

1. Fill in with records the tables described in the schema from Annex 1 (draw the tables with the data your data in them).

2. Write an SQL select query, which applies the Cube operator on all 3 dimensions, Cube(Week, Store, Group) of the database in Annexe1 with the records you have filled at Exercise 1, and then present the result of the query as a table.

3. Write an SQL query which retrieves the top 3 selling product groups in February, in Braunschweig.

4. Write an MDX query performing the same task as exercise 1.3 (the previous exercise).

Exercise 2

5. What kind of a schema is presented in Annex 1?

6. In which case should we consider migrating from a snowflake schema to a star schema?

7. Considering that the product dimension is subject to often change, how would you transform (draw) the schema in Annex 1, into a Starflake one?


Leave a Reply

Your email address will not be published.