{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

mid_IV_Dw - and the circumstances under which they are...

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 First Semester 2008-2009 Mid-Semester Test (EC-1 Regular) Course No. : SS ZG515 Course Title : DATA WAREHOUSING Nature of Exam : Closed Book Weightage : 40% Duration : 2 Hours Date of Exam : 02/08/2008 (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. 3. Mobile phones and computers of any kind should not be used inside the examination hall. 4. Use of any unfair means will result in severe disciplinary action. Q.1 (a). Dimensional modeling is more restrictive than Entity-Relationship modeling. Comment. Q.1 (b). Several distortions of the classical star schema are permissible. Describe them
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and the circumstances under which they are justified. [4 + 4 = 8] Q.2 Most of the analysis has a time component. Explain what role time dimension plays in such analysis. Why it is recommended to have a separate time dimension rather than having the date as one of the attributes in the fact table? Where from does one get the time dimension? [8] Q.3 Why it is recommended that the dimension tables in a star schema be denormalized? What is the highest normal form of the dimension tables and the fact tables? [8] Q.4 What are inside-out and outside-in queries? What are dimension-focused and fact-focused queries? Give one example of each type of query. [8] Q.5 What are the strengths and weaknesses of the relational technology when it comes to using it for data warehouses? [8] ******* No. of Pages = 1 No. of Questions = 5...
View Full Document

{[ snackBarMessage ]}