When Transforming an E-R Diagram into Normalized Relations, the Identifier

question 266

Multiple Choice

When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes:

• A) the primary key of the corresponding relation.
• B) the foreign key in the corresponding relation.
• C) a nonkey attribute in the corresponding relation.
• D) a secondary key in the corresponding relation.
• E) a homonym in the corresponding relation.

---

Definitions:

Excess Capacity

The situation in which a firm or economy can produce more goods or services than currently being produced due to unused resources, often leading to downward pressure on prices and profitability.

Mutual Interdependence

A situation in oligopoly markets where the actions of one firm significantly impact the actions and profits of other firms in the market.

Advertising Expenditures

The amount of money spent on promoting products, services, or brands through various media channels.

Product Differentiation

Differentiating a product or service to enhance its appeal to a certain demographic within the market.