Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Is Married To relationship in Figure 2 - 1 2 a would seem to have an obvious answer in Problem and Exercise 2 -

The Is Married To relationship in Figure 2-12a would seem to have an obvious answer in Problem and Exercise 2-33d-that is, until time plays a role in modeling data. Draw a data model for the PERSON entity type and the Is Married To relationship for each of the following variations by showing the appropriate cardinalities and including, if necessary, any attributes:
a. All we need to know is who a person is currently married to, if anyone. (This is likely what you represented in your answer to Problem and Exercise 2-33d.}
b. We need to know who a person has ever been married
to, if anyone.
c. We need to know who a person has ever been married to, if anyone, as well as the date of their marriage and the date, if any, of the d issolution of their marriage.
d. The san1e situation as inc, but now assume (which you likely did not do in c) that the same two people can remarry each other after a dissolution of a prior marriage to each other.
e. In history, and even in some cultures today, there may be no legal restriction on the number of people to whom one can be currently married. Does your answer to part
c of this Problem and Exercise handle tllis situation or
must you make some changes (if so, draw a new ERD).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708

Authors: Philippa Gardner ,Floris Geerts

2009th Edition

3642037925, 978-3642037924

Students also viewed these Databases questions

Question

8. Explain the relationship between communication and context.

Answered: 1 week ago