A Binary One-To-Many Relationship in an E-R Diagram Is Best

question 305

Multiple Choice

A binary one-to-many relationship in an E-R diagram is best represented by:

• A) the creation of a separate relation; the primary key of this new relation is a composite key consisting of the primary key for each of the two entities in the relationship.
• B) adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship.
• C) adding the primary key attribute (or attributes) of the entity on the many side of the relationship as a foreign key in the relation that is on the one side of the relationship.
• D) creating a relation with a composite primary key and nonkey attributes.
• E) none of the above.

---

Definitions:

Opportunity Costs

The cost of foregone alternatives, representing the benefits one could have received by taking an alternative action.

Capital Budgeting

The process by which a business evaluates and selects long-term investments that are worth more than their cost to achieve specific financial goals.

Straight-Line Depreciation

A method of calculating the depreciation of an asset, where the asset's cost is evenly spread over its useful life.

Yearly Depreciation

The accounting process of allocating the cost of a tangible asset over its useful life, reflecting the asset's consumption, wear, and tear over time.