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

question 5

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

---

Definitions:

Ligaments

Tough, fibrous connective tissues that connect bones to other bones, providing joint stability.

Tendons

Fibrous connective tissues that attach muscles to bones, transferring the force of muscle contractions to bones to facilitate movement.

Connective Tissue

A type of biological tissue that supports, connects, or separates different types of tissues and organs in the body.

Calcium Ions

Positively charged atoms of calcium that play critical roles in various bodily functions, including muscle contraction, nerve signaling, and blood clotting.