Sketch diagram for data warehouse of shop by star schema

Assignment Help Database Management System

Reference no: EM1369977

Suppose that a data warehouse for a video game shop consists of the three dimensions: time, player, and game, and the two measures number of games played and price paid per game

a) Draw a schema diagram for the above data warehouse using the star schema.
b) Starting with the base cuboid [month, player, game], what specific OLAP operations should be performed in order to

i. Find the total no of players who played World of Warcraft in 2010.
ii. Find the total no of games played by all the players every year.
iii. Find the monthly price paid by each player.

Reference no: EM1369977

Questions Cloud

Create program to read identifier-print what entered : Create c++ program which reads the identifier just print what entered. Then check that all characters in a identifier are valid, that is "A..Z 0..9..."

Important information about iso 14001 : What is the purpose of this measurement and evaluation and is it required for certification?

Compute equilibrium levels of output and interest rate : The following equations describe an economy, compute the simpler government spending multiplier in our open economy that applied under constant interest rate and equilibrium levels of output and interest rate

Make this assignment according to the apa guidelines : Make this assignment according to the APA guidelines found in the GCU APA Style Guide and located on the Student Success Center

Sketch diagram for data warehouse of shop by star schema : Assume that data warehouse for video game shop consists of th three dimensions: time, player, and game, and two measures number of games played and price paid per game. Sketch schema diagram for data warehouse using the star schema.

How can hr manager steve enforce discipline : When Steve requests the department heads to implement corrective measures, few take him seriously. Analyze how Steve and his team can enforce discipline at the workplace by addressing each of his issues.

Find the government tax revenue : Assume NJ government decides to impose a $1,000 per student tax on colleges Every college has to pay $1,000 for each student enrolled.

Importance and benefits of critical thinking : Example from your personal experience in applying critical thinking to a work-related decision, and the importance and benefits of critical thinking in the decision-making processes.

Estimating profit maximizing price : Assume there're three firms with the same individual demand function. This function is Q=1,000-40P. Assume each firm had the diffeerent cost function these functions are: Firm 1: 4,000+ 5Q

User Account

All Pages