User Account

All Pages

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?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Ieee 754 32-bit floating points numbers to decimal values

Convert the following IEEE 754 32-bit floating points numbers to decimal values

  Create a function sortnum to sort the numbers

Objective:  Write  a program to read a set of number,store in an array,and display the smallest,middle value and largest number entered  USING POINTERS NOTE: 1- the user can enter up to 10 numbers 2- create a function sortNum to sort the numbers,and ..

  Determine the largest angle ?

This requires no slipping for any magnitude of the force P applied to the joint

  Question regarding the troubleshooting tables

Imagine that an associate of yours just designed a table with captions outside the table's borders. The font on the Website is black, and the text inside the table is red. He is frustrated because the captions he placed outside of the table are no..

  List the vertices in the order in which each traversal visit

List the vertices in the order in which each traversal visits them.

  Evaluate the natural settings of the test environment

Describe and assess the evaluation method being used by the testing company, i.e., nonvisual and verbal recording of browser activities and tester's vocal comments and evaluate the natural settings of the test environment for Web users

  Create a column of integers 1 through 30

In the next three columns show how each value is represented using the binary, octal, and hex number systems. Identify when and why each of the each three numbering systems is used ?

  Discuss the role of incident containment in an incident

Discuss the role of incident containment in an incident response strategy and how a lack of planning for containment is a potential pitfall for any response strategy.

  Write a program using linkedlist and listiterator

Write a program using LinkedList and ListIterator to obtain the following statements:1. Create a linked list named "number" with these elements: "one", "four" and "three".2. Create a List Iterator named "it1" related to "number".

  Distinguish between traditional and operational bi

Distinguish between traditional and operational BI.

  Discuss the factors that affect query decomposition

Discuss the factors that affect query decomposition.

  Greatest conceivable ability irregularity

He looks to isolate the players as unreasonably as could be expected under the circumstances, in order to make the greatest conceivable ability irregularity between group An and group B. Indicate how the Grinch can carry out the employment in O(nl..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd