CS614 Data Warehousing Assignment No 2 Solution Fall Semester 2012

[Vuhelper]

CS614 Data Warehousing Assignment No 2 Solution Fall Semester 2012


Q: Analyze the scenario given below and draw a Star Schema.


Virtual University of Pakistan is going to develop a DWH for its Accounts branch. The officials of accounts branch want the reports regarding ‘deposited fees amount ‘and ‘fine’ on the basis of following:


Student (Student-ID, Name)

Campus (Campus -ID, Name)

Degree Program (Degree Program-ID, Name, Duration, Credit Hours)

Time (Time-ID, Date, Week, Month, Quarter, Year)

Bank (Bank-ID, Name, Branch Name, Branch Code)

Location (Location-ID, Zone, City, Province)

Guidelines

Show the column names along with table names.
Schema should not include any data (column values).
Do not send the archived file (.rar etc