Consider the Is_married_to unary relationship in Figure 8-14c. a. Assume that we want to know the date

Question:

Consider the Is_married_to unary relationship in Figure 8-14c.

a. Assume that we want to know the date on which a marriage occurred. Augment this E-R diagram to include a Date_married attribute.

b. Because persons sometimes remarry after the death of a spouse or a divorce, redraw this E-R diagram to show the whole history of marriages (not just the current marriage) for persons. Show the Date_married attribute on this diagram.

c. In your answer to Problem and Exercise 8.63b, is it possible to represent a situation in which the same two people marry each other a multiple number of times? Explain.


Figure 8-14cPERSON Is_married_to Shirley Mack Dawn Kathy Ellis Fred

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Systems Analysis And Design

ISBN: 9781292351629

9th Global Edition

Authors: Joe Valacich, Joey George

Question Posted: