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 Candidatesgiven 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.1Explain in detail, the kind of things RDBMS vendors are doing to make their product more suitable for data warehousing & OLAP.  Q.2In 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%.
This is the end of the preview.
access the rest of the document.