+2 votes
259 views
by (98.9k points)
Suppose that a data warehouse for Big_University consists of the four dimensions Student, Course, Semester and Instructor, and two measures count and avg_grade, where count is the number of students and average grade is the course grade of the student.
Perform following tasks:
i. Design the star schema for the Big_University.
ii. Create a base cuboid for the Big_university database and apply different OLAP operations.

1 Answer

0 votes
by (98.9k points)

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.

 


 

Related questions

+2 votes
0 answers 117 views
+1 vote
1 answer 201 views
asked Nov 30, 2023 by Doubtly (98.9k points)
0 votes
1 answer 103 views

Doubtly is an online community for engineering students, offering:

  • Free viva questions PDFs
  • Previous year question papers (PYQs)
  • Academic doubt solutions
  • Expert-guided solutions

Get the pro version for free by logging in!

5.7k questions

5.1k answers

108 comments

558 users

...