Explaining star and snow flake schemas of data warehouse


Question 1) Explain Data Visualization and Hierarchical clustering as a Data Mining technique in detail.

Question 2) Describe the Independent Data Mart, Dependent Data Mart and Federated Data Mart architectures of Data Warehouse, Compare each type with appropriate diagrams.

Question 3) Explain the Data Mining Process with appropriate diagram, describe each component.

Question 4) Distinguish Star and Snow flake schemas of Data warehouse.

Question 5) Write down the example of statistical techniques which can be used for prediction'

Question 6) What do you mean by association mining? Give appropriate example'

Question 7) Explain different application areas of Data Mining'

Question 8) Write down the name of some of the analytical models used in Data Mining.

Question 9) Explain the process of E.C.T.L. with appropriate diagram and examples of each stage.

Question 10) Distinguish Multidimensional Databases and Relational Databases. How we can achieve multidimensional storage using relational databases.

Question 11) Describe Decision tree and Rule Induction as methods of Data Mining with suitable examples.

Question 12) Describe the terms: Supervised Learning, Unsupervised Learning Semi Supervised Learning.

Question 13) Write brief note on:

i) Link analysis.

ii) Data Mining is a process of Knowledge discovery.

Question 14) Write down the difference between MOLAP and ROLAP.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Explaining star and snow flake schemas of data warehouse
Reference No:- TGS08613

Expected delivery within 24 Hours