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:

Dopamine

A neurotransmitter involved in regulating mood, motivation, pleasure, and reward.

Withdrawal

A process or period of time during which one discontinues the use of a substance or abstains from a certain behavior, often leading to uncomfortable symptoms.

Amphetamines

A class of stimulant drugs that increase energy and alertness but can also lead to addiction and adverse health effects.

Epinephrine

Epinephrine, also known as adrenaline, is a hormone and neurotransmitter involved in regulating heart rate, blood vessel and air passage diameters, and metabolic shifts.