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 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.1In 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).  Q.2
This is the end of the preview.
access the rest of the document.
data mart, Hotels, Star schema, Motel, Hotel chains