Unformatted text preview: ou wish. To obtain copies of the software mentioned, please send me an email
to inform me that you have paid the lab fee and I will add you to the distribution server.
Constructing a university residence data warehouse
In the university accommodation database, an university wants to track all the vacancies taken by every
student each term and academic year. The housing and conferences department (at UBC for example)
wants to see what residences are the most popular, which rooms are the most popular, how long each
student lives in residence, what is the rent they pay over time, how often they ask to transfer, how they
pay for their rooms, whether they respond to special room promotions, do they add a land line, etc, etc.
From the above information, create a star schema of the university data wa...
View Full Document
This document was uploaded on 04/06/2014.
- Spring '14