Answered step by step
Verified Expert Solution
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 a would seem to have an obvious answer in Problem and Exercise dthat 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 d
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 sane 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started