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 data

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?

 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online