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:

Wellness Strategies

Approaches or plans designed to promote overall health and well-being by addressing physical, mental, and emotional health aspects.

Routine Exercise

A regular physical activity regime followed for the purpose of improving or maintaining physical fitness and overall health.

Fortified

Often refers to food or drinks that have had nutrients added to them that do not naturally occur in those products, to enhance their nutritional value.

Vitamin D

A fat-soluble vitamin essential for bone health, immune function, and reducing inflammation.