FIGURE 1-21 Data model for Problem and Exercise 8 a. What is the relationship be
ID: 638467 • Letter: F
Question
FIGURE 1-21 Data model for Problem and Exercise 8 a. What is the relationship between Pet and Store (one-to- one, many-to-many, or one-to-many)? b. What is the relationship between Customer and Pet? c. Do you think there should be a relationship between Customer and Store? 9. Consider Figure 1-12, which depicts a hypothetical three-tiered database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise because of this duplication? Does this duplication violate the principles of the database approach outlined in this chapter? Why or why not? 10. What is your reaction to the representation of the systems development life cycle included in this chapter? Explain any problems you have with it. 11. List three additional entities that might appear in an enterprise data model for Pine Valley Furniture Company (Figure 1-3a). 12. Consider your business school or other academic unit as a business enterprise. a. Define several major data entity types and draw a pre-Explanation / Answer
1)
store to pet is one to many
store has many pets
2)many to many
many customers can buy many pets
3)
yes...customer buy pets from store
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.