Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Any help is greatly appreciated: A data warehouse of a telephone provider consists of five dimensions: caller customer, callee customer, time, call type, and call

Any help is greatly appreciated:

A data warehouse of a telephone provider consists of five dimensions:

caller customer, callee customer, time, call type, and call program

and

three measures: number of calls, duration, and amount.

Define the OLAP operations to be performed in order to answer the following queries. Propose the dimension hierarchies when needed.

(a) Total amount collected by each call program in 2012.

(b) Total duration of calls made by customers from Brussels in 2012.

(c) Total number of weekend calls made by customers from Brussels to customers in Antwerp in 2012.

(d) Total duration of international calls started by customers in Belgium in 2012.

(e) Total amount collected from customers in Brussels who are enrolled in the corporate program in 2012.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Database Programming

Authors: Chris Fehily

1st Edition

1937842312, 978-1937842314

More Books

Students also viewed these Databases questions

Question

5. Structure your speech to make it easy to listen to

Answered: 1 week ago

Question

1. Describe the goals of informative speaking

Answered: 1 week ago