Solution-Data warehouse consists of four dimensions

Data warehouse consists of four dimensions

Assignment Help Basic Computer Science

Reference no: EM131077293

Suppose a market shopping data warehouse consists of four dimensions: customer, date, product and store and two measures: count and avg_sales, where avg_sales stores the real sales in dollar at lowest level but the corresponding average sales at other levels.

(i) Draw the star schema diagram (sketch it, do not have to mark every possible level, and make your implicit assumptions on the levels of dimension when you draw it).

(ii) If one also wants to compute standard deviation as a measure, what other intermediate measures need to be introduced to make the computation efficient?

Reference no: EM131077293

Questions Cloud

Store the list''s entries in an instance of linked list : Consider an ADT front list , which restricts insertions, removals, and retrievals to the first item in the list. Define and implement a class for the ADT stack that is a descendant of Front List.

Benefits and challenges of enterprise application : Based on what you've learned about the benefits and challenges of enterprise application integration and how EAI can contribute to the business value, write a 2-3 page memo to your IT manager in which you advocate for or against the integration of..

Estimate the half-power cut-off frequency : 1. Derive the transfer function for each of the filter circuits given in tin FIGURE 1 and sketch Bode plots for each circuit (amplitude and phase).

Determining the rest for kernel data : Assuming 64KB of program flash memory and 64KB of data SRAM, assign values to BMXxxxBA special function registers to partition the program flash memory into 50KB for kernel program and rest for user program; and partition the data SRAM into 10KB f..

Data warehouse consists of four dimensions : Suppose a market shopping data warehouse consists of four dimensions: customer, date, product and store and two measures: count and avg_sales, where avg_sales stores the real sales in dollar at lowest level but the corresponding average sales at o..

Create a power point slide show : Choose an historical event, short story, speech, or other document, create a power point slide show from the document. The slide show has a title slide that displays your name and the title of your slide show, table of contents slide that provides..

Corresponding iceberg cube : Data Warehousing and OLAP for data mining (a) Suppose the base cuboid of data cube contains only two cells (a1, a2, a3 ...a10) (b1, b2, b3 ....b10) Where ai = bi where i is an odd number otherwise ai ≠ bi.

Explain two major components of sql : 1. What type of integrity is enforced when a primary key is declared? 2. Explain why it might be more appropriate to declare an attribute that contains only digits as a character data type instead of a numeric data type. 3. Explain two major compon..

Workbook and a worksheet group in excel : What is the difference between a Workbook and a Worksheet group in excel?

User Account

All Pages

Data warehouse consists of four dimensions

Reference no: EM131077293

Reference no: EM131077293

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT