Design a data warehouse for a university's gradebook data to analyze the class performances. Suppose the
data warehouse consisting of the following dimensions: department, semester, course, student, instructor,
and gradebook; and a set of measures you would like to define.
1. Draw a star-schema, based on your consideration of power and convenience of analysis of the
2. Is top 10% in a class a holistic or algebraic measure? Discuss how to develop an efficient (maybe
approximate) methods to compute a query like: find those Engineering students whose final score
is within top 10% in class in at least 80% of the CS courses that he or she has taken?
3. Is it a good idea to merge this data warehouse and the current university's gradebook database
system together into one big data management/analysis system? Why?