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:

At Will

A term used to describe employment which can be terminated by either the employer or the employee at any time, without any advance notice.

Contract Of Employment

A legally binding agreement between an employer and an employee, detailing the terms and conditions of employment.

Reasonable Time

A period of time which is fairly appropriate or usual under the given circumstances, often used in legal contexts to define the duration for fulfilling an obligation or contract.