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)
Solution: coming soon
