Question: Design a conceptual MultiDim schema for the university application, taking into account the di erent granularities of the time dimension Consider the data warehouse of
Design a conceptual MultiDim schema for the university application,
taking into account the dierent granularities of the time dimension
Consider the data warehouse of a university that contains information
about teaching and research activities. On the one hand, the information
about teaching activities is related to dimensions department, professor,
course, and time, the latter at a granularity of academic semester.
Measures for teaching activities are number of hours and number of
credits. On the other hand, the information about research activities is
related to dimensions professor, funding agency, project, and time, the
latter twice for the start date and the end date, both at a granularity of
day. In this case, professors are related to the department to which they
are aliated Measures for research activities are the number of person
months and amount.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock