Examine Figure CE5-12. Describe the maximum and minimum cardinality for each relationship. Justify these cardinalities.

Change the relationship between Prospect and Phone to N:M, and explain what this means. Change the relationship between Prospect and Work to 1:1, and explain what this means. Explain how each relationship is represented in the design in Figure CE5-14. Show examples of both primary keys and foreign keys in this figure. In Contact, determine whether EmployeeName is part of a primary key or part of a foreign key.

Explain what problem the consultant foresaw in the use of the Name attribute. Explain how that problem was avoided. The consultant added an attribute to the data model that was not part of the users’ world. Explain why that attribute will not add unnecessary complication to the users’

work experiences.