Dataware House and Mining(MCA-204)

R.C. Institute of Technology

(Affiliated to Guru Gobind Singh Indraprastha University)

Nazafgarh-43

Assignment:Dataware House and Mining(MCA-204)                  Date: 4 Feb, 2013

Purpose: This assignment covers questions from unit-I. It will help students to understand-

· Basic components of DWH.

·Inforamtion Package Diagram.

·Star Schema.

·Models in DWH.

Q1. Difference between OLTP and OLAP.

Q2. What are the component of DWM.

Q3. BigBook, Inc. is a large book distributor with domestic and international distribution channels. The company orders from publishers and distributes publications to all the leading booksellers. Initially, you want to build a data warehouse to analyse shipments that are made from the company’s many warehouses. Determine the metrics or facts and the business dimensions. Prepare an information package diagram.

Q4. What are hierarchies and categories as applicable to a dimension table?

OR

In a STAR schema to track the shipments for a distribution company, the following dimension tables are found: (1) time, (2) customer ship-to, (3) ship-from, (4) product, (5) type of deal, and (6) mode of shipment. Review these dimensions and list the possible attributes for each of the dimension tables. Also, designate a primary key for each table.

Q5. You are the data design specialist on the data warehouse project team for a retail company. Design a STAR schema to track the sales units and sales dollars with three dimension tables. Explain how you will decide to select and build four two way aggregates.

Q6. Difference between ROLAP and MOLAP.

Q7. Describe slowly changing dimension. What are the types, explain each type briefly.

Book : DATA WAREHOUSING FUNDAMENTALS by PAULRAJ PONNIAH

Deepak Singh

(Assistant Professor)