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:

HR Department

The department within an organization responsible for managing human resources, including recruitment, training, employee relations, and benefits administration.

Simulation

The technique of creating a model of a real-world situation or system to study its operation and explore outcomes.

Computer-based Training

Educational and training programs delivered through computers, utilizing software, internet resources, or multimedia for instructional content.

Information Technology

The use of computers and software to manage information, including the processing, storing, and dissemination of data.