Answered step by step
Verified Expert Solution
Question
1 Approved Answer
course uniy fact table student dimension table area dimension table dimension table course id course_name department student id course id semester id instructor id count
course uniy fact table student dimension table area dimension table dimension table course id course_name department student id course id semester id instructor id count avg_grade student id student name area id major status university area id city province country semester dimension table semester_i id semester instructor dimension table year instructor id dept rank Using this schema, starting with the base cuboid (student, course, semester, instructor), what specific OLAP operations (e.g., roll up from semester to year) should one perform in order to list the following: to list the average grade for all of my students (my instructor_id is 007) to list the average grade for all CS majors to list the average grade for all CS majors in 2012 to list the average grade of English courses for each student to list the average grade of English courses for all students to list the average grade for each student in the year 2012 to list the average grade for all students in the year 2012 How many cuboids does this cube contain (including the base and apex cuboids)? (To make this caculation easier, you may ignore the area dimension of the snowflake.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started