Download JNTUA MBA 2018 May-June Supply 3rd Sem 14E00319 Data Warehousing And Mining Question Paper

Firstranker's choice

FirstRanker.com

Code: 14E00319

--- Content provided by⁠ FirstRanker.com ---

Time: 3 hours

FirstRanker.com

MBA III Semester Supplementary Examinations May 2018

DATA WAREHOUSING & MINING

(For students admitted in 2014, 2015 & 2016 only)

--- Content provided by FirstRanker.com ---

PART - A

(Answer the following: (05 X 10 = 50 Marks)

1. Explain the components of organizational memory.

   OR

   Explain in detail individual data management.

   --- Content provided by‌ FirstRanker.com ---

2. Explain sharing data between functional units.

   OR

   What are the differences among sharing data between functional units and sharing data between different levels of users? Explain in detail.

--- Content provided by FirstRanker.com ---

3. Explain an advantage of the multi dimensional database structure over the relational database structure for data warehousing applications.

   OR

   What is metadata and explain three reasons why it can be useful?

4. Compare and contrast the data driven and the application-driven approaches to develop a data warehouse? Explain.

   --- Content provided by FirstRanker.com ---

   OR

5. Explain conceptual structure of neural networks in data mining.

   OR

   Explain one significant disadvantage of the decision tree approach to data mining.

   --- Content provided by‍ FirstRanker.com ---

PART - B

(Compulsory question, 01 X 10 = 10 Marks)

Case Study:

A Hospital collaborated with medical college is designing a data warehouse to enable deans, department chair and the superintendent's office to optimize department services, in terms of which services are offered in how many sections and at what times. The data warehouse planners hope they will be able to do this better after examining historical demand for department services and extrapolating any trends that emerge.

--- Content provided by‌ FirstRanker.com ---

Questions:

1. Give three dimension data elements and two fact data elements that could be in the database for this data warehouse.
2. Draw a data cube for this database.
3. Suggest an aggregation that could apply to one of the dimension data elements.

FirstRanker.com

--- Content provided by FirstRanker.com ---