We are interested in building an OLAP application with which we can analyze the grading at our university, where grades are represented as integers from 0 to 4 (4 representing an A). We want to ask questions about average grades for different courses, professors, and departments during different semesters and years. Design a star schema for this application.

What will be an ideal response?

The center of the star (the relationship in the E-R diagram) is Grades. The dimension
tables might be Course, Professor, Department, and Time.