Question: (b) Differentiate OLTP and OLAP operations. A University data warehouse consists of four dimensions with student, course, year_of_study, faculty and two measures count and avg

 (b) Differentiate OLTP and OLAP operations. A University data warehouse consists

(b) Differentiate OLTP and OLAP operations. A University data warehouse consists of four dimensions with "student, course, year_of_study, faculty" and two measures "count and avg grade. When at the lowest conceptual level (student, course, year_of_study, faculty), the avg grade measure stores the actual course grade of the student. At higher conceptual level, avg grade stores the average grade for the given combination. (a) Construct a Fact Constellation schema diagram for the data warehouse. (b) Starting with the base cuboid [student, course, year_of_study, faculty], List out specific OLAP operations which should be performed in order to list the average grade of CS courses for all students in University. (c) If each dimension has 5 levels (including all), such as "student

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!