Reference no: EM133175263
1. What are the distinguishing characteristics of OLAP and data mining analyses? Compare and contrast OLTP and OLAP queries.
2. What is relational (entity & referential) integrity? What are the possible concerns when updating or deleting primary keys? with examples.
3. Describe normalization. Include in your answer a discussion of redundancy and dependencies and how it relates to normalization. with examples.
4. What is abstraction and why is it important in modeling? with examples.
5. What is metadata? Distinguish technical, business, and process metadata. Give examples.
6. What are the strengths of the dimensional model? How is a dimensional model organized? with examples.
7. What is a conformed dimension and what are its advantages? Give examples.
8. What does "grain" mean and why is it important? Give examples.
9. Describe the contents of the presentation layer in data warehousing. Discuss their respective characteristics