When Transforming an ID-Dependent E-R Data Model Relationship into a Relational

question 17

Multiple Choice

When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.

• A)the parent's surrogate key + the child's data key
• B)the parent's surrogate key + a surrogate key in the child
• C)either A or B will work,and neither way is preferable
• D)either A or B will work,and method A is preferable
• E)either A or B will work,but method B is preferable

---

Definitions:

Natural Selection

The process by which organisms better adapted to their environment tend to survive and produce more offspring, a fundamental concept in evolutionary biology.

Fecundity

The potential reproductive capacity of an individual or population, often measured by the number of offspring produced.

Activation

The process of initiating action or the state of being active, often discussed in psychological and physiological contexts.

Parental Investment Model

A theory proposing that the extent and type of investment parents make in their offspring affects the offspring's survival and reproductive success.