a) A Snowflake Shema is shown in figure below:
b) base cuboid [student, course, semester, instructor]
The specific OLAP operations to be performed:
1. Roll-up on course from course_id to department.
2. Roll-up on a student from student_id to university.
3. Dice on course, student with department =”CS” and university = “biguniversity”
4. Drill-down on a student from the university to student_name.