{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

sszg515_final - Birla Institute of Technology Science...

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 Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

sszg515_final - Birla Institute of Technology Science...

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

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