You are here

Review Questions

27 August, 2015 - 17:17

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?