For a Binary Many-To-Many Relationship Existing Between Entity Types a and B

question 45

Multiple Choice

For a binary many-to-many relationship existing between entity types A and B:

• A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.
• B) the primary keys of relation A and relation B become foreign keys in a new relation C.
• C) secondary keys are used to establish the relationship.
• D) place the primary key of either entity in the relation for the other entity or do this for both entities.
• E) none of the above.

---

Definitions:

Yield Management

A variable pricing strategy based on understanding, anticipating, and influencing consumer behavior to maximize revenue or profits, especially in airline and hotel industries.

Aggregate Planning

A process in operations management aimed at determining optimal production levels, inventory levels, and workforce levels, to meet predicted demand over a medium-term horizon.

Perishability Of Inventory

refers to the characteristic of goods that causes them to become unsellable after a certain period, requiring careful stock management to minimize losses.

Intangible Outputs

Results or benefits from a process, service, or product that cannot be physically touched or quantified easily, such as reputation or brand value.