Discussion Questions

1.

Using the descriptions provided in Figure 3.4, identify the key event data you would want to capture based on the 4 W’s (who, what, where, and when).

2.

“The database approach to data management is the only approach that makes sense for most organizations in today’s economic and technical environment.” Do you agree? Discuss fully.

3.

“Our company’s database contains some very sensitive information about our customers. Shouldn’t we keep that in a separate file so that those who shouldn’t have access to it (like the payroll supervisor and the receptionist) can’t look through it?” Discuss.

4.

Examine Figure 3.18 and Figure 3.19. Using the combination of the E-R diagram and the schema, identify each of the referential integrity constraints that should be considered. Explain why each is necessary.

5.

(Appendix A) Examine Figure 3.18 and the five relationships. Determine the cardinality constraints for each of the relationships. Be prepared to defend the rationale for your selection.