|
1. |
What business events are typically encountered by a merchandising firm? |
|
|
2. |
How do the business events for a service firm differ from those of a merchandising firm? How are they similar for the two firms? |
|
|
3. |
How are event-driven systems different from traditional transaction processing systems? |
|
|
4. |
What is meant by the idea of “storing data at the event level”? |
|
|
5. |
Why is it important to capture the who, what, where, and when in describing business events? |
|
|
6. |
a. |
What is file management? |
|
b. |
How are the applications-based file and database approaches to data management the same? How are they different? |
|
|
c. |
What are the relative advantages of the database approach? |
|
|
7. |
What do the concepts of data warehousing and data mining mean? |
|
|
8. |
a. |
What is an entity? |
|
b. |
What is an attribute? |
|
|
c. |
What is a relationship? |
|
|
d. |
What is a key attribute? |
|
|
9. |
Why is it preferable to use a numeric-based attribute as the key attribute? |
|
|
10. |
Why is it important that you identify all of the important relationships when developing an entity-relationship (E-R) diagram? |
|
|
11. |
What are the relative advantages of the relational and object-oriented database models (Technical Insight 3.3)? |
|
|
12. |
a. |
What is a relation? |
|
b. |
What is a tuple? |
|
|
c. |
What is an attribute in a relational data model? |
|
|
d. |
What is referential integrity? |
|
|
13. |
Compare and contrast the data structures for data stored in a file and data stored in a relational table. |
|
|
14. |
(Appendix A) What is different about a recursive relationship in comparison to other relationships in a data model? |
|
|
15. |
(Appendix A) What is different about the information provided through cardinality constraints versus participation constraints? |
|
|
16. |
What is the importance of an E-R diagram in facilitating event-driven systems and the integration of data between business processes? |
|
|
17. |
(Appendix B) How is a composite key implemented in a relational database model? |
|
|
18. |
(Appendix B) What is the difference in implementation of a one-to-many and a one-to-one relationship in a relational database model? |
|
- 3147 reads
