Organizational Understanding and Data Understanding - Data Mining for the Masses - page 22

REVIEW QUESTIONS
1) What is data mining in general terms?
2) What is the difference between a database, a data warehouse and a data set?
3) What are some of the limitations of data mining? How can we address those limitations?
4) What is the difference between operational and organizational data? What are the pros and
cons of each?
5) What are some of the ethical issues we face in data mining? How can they be addressed?
6) What is meant by out-of-synch data? How can this situation be remedied?
7) What is normalization? What are some reasons why it is a good thing in OLTP systems,
but not so good in OLAP systems?
EXERCISES
1) Design a relational database with at least three tables. Be sure to create the columns
necessary within each table to relate the tables to one another.
2) Design a data warehouse table with some columns which would usually be normalized.
Explain why it makes sense to denormalize in a data warehouse.
3) Perform an Internet search to find information about data security and privacy. List three
web sites that you found that provided information that could be applied to data mining.
Explain how it might be applied.
4) Find a newspaper, magazine or Internet news article related to information privacy or
security. Summarize the article and explain how it might be related to data mining.