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

question 59

Multiple Choice

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.

• A)the parent entity must also use a surrogate key
• B)the relationship remains an ID-dependent relationship
• C)the relationship changes to a non-ID-dependent relationship
• D)A and B
• E)A and C

---

Definitions:

Investment Plan

A strategy developed by individuals or financial advisors to allocate assets with the goal to meet future financial goals.

Expense

Costs or charges incurred in the operation of a business or the execution of a transaction.

RRSP

Registered Retirement Savings Plan, a Canadian investment vehicle for individuals to save for retirement while taking advantage of tax deferrals.

Years

Years are units of time that measure the duration or length of time an event has occurred or is expected to occur, usually related to financial calculations or investments.