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.
You might also like to view...
The Class class has a(n) ____ method that, given a string whose value is the name of a class, returns a Class with that name.
A. forName() B. getName() C. forClass() D. getClass()
Summary statistics describe a collection of numbers
Indicate whether the statement is true or false
Basing access control on IP addresses rather than hostnames makes authentication faster because you don't have to resolve hostnames.
Answer the following statement true (T) or false (F)
A(n) ____________________-driven program begins by displaying a list of options from which the user selects one.
Fill in the blank(s) with the appropriate word(s).