a) A Snowflake Shema is shown in figure below:
![](https://blogger.googleusercontent.com/img/a/AVvXsEi7gACrfJuQ1HAW0Z6WpO1vJpfKvVALeWvFQ3nWRrAzkNtulk8dp4hkvTm3QE-9Bf9qcRW2Ir3mTnaCLBmc4lV0HY0hX08RPWAJJxwz5YdQCVTIBYHoxphEx11l-L13vO0Z60pTX9OZ8NdCWGoYZ1q4m4b141K37R9DL1-XYgdJsioXkWmW6SKqSyIP=w640-h500)
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.