CS614 Data Warehousing Assignment No 2 Solution Fall Semester 2012

[Vuhelper]

View more random threads:

• cs601 assignment no 4 idea solution spring June 2011
• cs605 assignment no 1 idea solution fall 2011 on 26th...
• Virtual University MCS assignments solutions
• CS304 Object Oriented Programming assignment no 3 fall...
• MGT610 Business Ethics Assignment No.1 Solutuon Fall...
• CS508 Modern Programming Languages Assignment No.3 Fall...
• CS504 Software Engineering - I Assignment No.4 Fall...
• Advance Computer Architecture - CS501 assignment no 5 idea...
• CS410 Visual Programming Assignment#01 Solution &...
• CS302 Digital Logic Design Assignment No.3 Solution Spring...

CS614 Data Warehousing Assignment No 2 Solution Fall Semester 2012


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

Sponsored Links


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