comp_VII_Dw - Birla Institute of Technology & Science,...

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 Second Semester 2006-2007 Comprehensive Examination (EC-2 Regular) Course No. : SS ZG515 Course Title : DATAWARE HOUSING Nature of Exam : Open Book Weightage : 60% Duration : 3 Hours Date of Exam : 31/03/2007 (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 In the grocery store data mart star schema, there are 3 dimensions, viz., product, store, & time. The granularity of the sales fact table is product by day by store. The promotions at the stores have a granularity of a week. Can we add the promotion dimension to the existing star schema? Justify your answer. Modify the original star schema in such a way that we can find out the products that were on promotion during a given time period, but did not sell. Write down the steps clearly. Also draw the modified star schema(s).
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/05/2012 for the course CSE ss zg513 taught by Professor Raj during the Spring '11 term at Birla Institute of Technology & Science, Pilani - Hyderabad.

Ask a homework question - tutors are online