1 - The star schema shown in the scenario above describes part of the database that will

provide decision-support for a property sales company. Describe the main

characteristics of fact and dimension tables, and discuss the purpose of the tables

shown in the star schema.

2 - Identify three types of analysis that the star schema (shown in the scenario) can

support about property sales.

3 - What do Slowly Changing Dimensions (SCDs) represent to a database designed for

decision-support?

4 - What are the three key features that all Online Analytical Applications (OLAP) share?

5 - Explain why a data warehouse is well equipped for providing the data for data mining.

6 - Identify the factors that have led to the growing popularity of data mining.

7 Discuss the relationship between data mining, OLAP and data warehousing.

8 There are a growing number of data mining tools. Describe four key features that

these tools offer the analyst.

 

1 - The star schema shown in the scenario above describes part of the database that willprovide decision-support for a property sales company. Describe the maincharacteris±cs of fact and dimension tables, and discuss the purpose of the tablesshown in the star schema.2 - Iden±fy three types of analysis that the star schema (shown in the scenario) cansupport about property sales.3 - What do Slowly Changing Dimensions (SCDs) represent to a database designed fordecision-support?4 - What are the three key features that all Online Analy±cal Applica±ons (OLAP) share?5 - Explain why a data warehouse is well equipped for providing the data for data mining.6 - Iden±fy the factors that have led to the growing popularity of data mining.7 Discuss the rela±onship between data mining, OLAP and data warehousing.8 There are a growing number of data mining tools. Describe four key features thatthese tools oFer the analyst.

Attachments:

• 1495183050-Questions.docx