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

question 47

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

---

Definitions:

Positive Profits

A financial gain that occurs when the revenues generated from business activities exceed the costs and expenses involved in operating the business.

Shut Down

A short-term decision by a firm to cease production due to unfavorable market conditions.

Firm

An entity like a corporation, partnership, or sole proprietorship engaged in selling goods or services for financial gain.

Price

The sum of money needed to buy a product, service, or asset.