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

question 31

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,but method A is preferable
• E)either A or B will work,but method B is preferable

---

Definitions:

High-stakes Project

A project with a significant level of risk and potential consequences, where outcomes can greatly affect an organization or individuals.

Low-stakes Project

A project with minimal risk and consequences for failure, often involving fewer resources and lower levels of complexity.

Environment

The surrounding conditions, including physical, biological, and social factors, that influence the life of organisms or communities.

Socially Charged

Topics or issues that are heavily laden with emotional implication and societal impact.