sszg515_final - Birla Institute of Technology &...

Info iconThis preview shows pages 1–2. 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 2003-2004 Comprehensive Examination (EC-3 Regular) Course No. : SS ZG515 Course Title : DATA WAREHOUSING Nature of Exam : Open Book Weightage : 50% Duration : 3 Hours Date of Exam : 16/11/2003 (FN) Note : Attempt all the questions. Start each answer from a fresh page. Q. 1. Identify the tasks that must be performed while refreshing the data warehouse? Give a detailed account. [5] Q. 2. Snowflaking is a process in which some dimensions are normalized. Consider the Grocery Store Retail Sales Data Mart . There are three dimensions, Product, Location, and Time. (a) List all the relevant attributes and normalize these dimensions (show all the Functional Dependencies). (b) What are the disadvantages of doing so? Discuss for each dimension separately. (c) Are there any advantages of snowflaking? If yes, give situations where it is recommended to snowflake your dimensions. [5 + 3 + 2 = 10]
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/14/2010 for the course CSE SS ZG515 taught by Professor Naveneetgoyal during the Summer '10 term at Birla Institute of Technology & Science.

Page1 / 2

sszg515_final - Birla Institute of Technology &...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online