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).

Don't use plagiarized sources. Get Your Custom Essay on
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
Just from $13/Page
Order Now

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?

 

NOTE:
We have worked on a similar assignment and our student scored better and met their deadline. All our tasks are done from scratch, well researched and 100% unique, so entrust us with your assignment and I guarantee you will like our services and even engage us for your future tasks. Click below button to submit your specifications and get order quote

Get started