Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2- (2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions: Item, Time and Location. The values (i.e., facts) show the

image text in transcribed

2- (2 points) [OLAP Operations] Assume we have a data cube consists of three dimensions: Item, Time and Location. The values (i.e., facts) show the revenue in thousand dollars. Assume we have the following hierarchy: Page 1 of 5 Which OLAP operations should be performed in order to answer the following questions: a) [1 point] Total revenue earned by selling Mobil and Modem in Canada in Q1. b) [1 point] Total revenue earned by each item in each Quarter. 3- (1.5 points) [Predictive Analytics] The following decision tree is for the concept "buy computer" that indicates whether a customer at a company is likely to buy a computer or not. Determine if the following instances will buy a computer and explain the steps (If the tree cannot provide the value for the instance, explain why): a) [0.5 point] Alex is a young student. b) [0.5 point] Jon is middle aged with an excellent credit_rating. c) [0.5 point] David is a teenager with an excellent credit rating

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

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions

Question

Define organisational structure

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago

Question

* What is the importance of soil testing in civil engineering?

Answered: 1 week ago

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago