Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!