Design a data warehouse for a university's gradebook data to analyze the class performances. Suppose the data warehouse consisting of the following...

Design a data warehouse for a university's gradebook data to analyze the class performances. Suppose thedata 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 thewarehouse2. Is top 10% in a class a holistic or algebraic measure? Discuss how to develop an efficient (maybeapproximate) methods to compute a query like: find those Engineering students whose final scoreis 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 databasesystem together into one big data management/analysis system? Why?