Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Questions 1 - Do a Rollup operation on Table 1 , by country, name the result Table 2 . 2 - Do a slice operation

Questions 1- Do a Rollup operation on Table 1, by country, name the result Table 2.2- Do a slice operation on Table 2, to get sales in 2018, name the result Table 3.3- Execute the operation on Table 2: Dice (Country = KSA OR Tunisia , Year =2019 OR 2018),name the result Table 4.4- Executetheoperation onTable2: Dice(town=ParisORJeddahORTunis,Year=2019 OR 2018), name the result Table 5.5- Do a Drill down operation on Table 3, to get the sales by semester. We suppose that the semesters have equal sales, name the result Table 6.6- Do the Pivot operation on the Table 3, name the results table 6.7- Exercise 2: Using Table 1(or cube), Write the following OLAP Queries: Q1: : Get the total of sold cars by Town, and colour (exp. Paris 350 for white cars) Q2: Get the total sold cars by country, year, and colour Q3: Get the 2 colours with the highest number of sold cars. Q4: Get the country that account the highest number of sold cars

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_2

Step: 3

blur-text-image_3

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

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions