Problem:

(a) Define the following terms:

(i) data mining.

(ii) OLAP.

(b) Differentiate between snowflake schema and star schema. Support your answer with appropriate example of each.

(c) Data warehousing is defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process.

(i) Define the term subject-oriented and support your answer with appropriate examples.

(ii) Describe the three important differences that exist between an application oriented system and a subject oriented system.