i) Course, ii) Student, iii) Time & measure Aggregate marks Create a Cube and describe following OLAP operations.
i)Slice ii) Dice iii) Roll up iv) Drill down v) Pivot

Dimensions : course, student, time fact : Aggregate marks.

• Each cell gives aggregate marks for each student, for each course year wise.

1. Slice : It is used to obtain a particular slice of the cube.

example : Aggregate marks of all students for all courses in the year 2016. …