{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

comp_IV_dw - Birla Institute of Technology Science Pilani...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Birla Institute of Technology & Science, Pilani Distance Learning Programmes Division First Semester 2008-2009 Comprehensive Examination (EC-2 Regular) Course No. : SS ZG515 Course Title : DATA WAREHOUSING Nature of Exam : Open Book Weightage : 60% Duration : 3 Hours Date of Exam : 27/09/2008 (AN) Note: 1. Please follow all the Instructions to Candidates given on the cover page of the answer book. 2. All parts of a question should be answered consecutively. Each answer should start from a fresh page. Q.1 Explain in detail, the kind of things RDBMS vendors are doing to make their product more suitable for data warehousing & OLAP. [10] Q.2 In a university data warehouse, give a star schema to capture the attendance of students in different courses. It is required to generate a report that would give the semester wise percentage attendance in different courses. Suggest any aggregate(s) that would facilitate in generation of this report. Give aggregated schemas also. It is given that the average attendance in courses is 50%.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online