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:

Facility Expenses

Costs associated with the physical locations where businesses operate, such as rent, utilities, maintenance, and security.

Flexible Budget

A budget that adjusts or flexes with changes in volume or activity, providing a more accurate comparison between actual and budgeted performance.

Spending Variance

The difference between the budgeted amount of expense or cost and the actual amount spent.

Tenant-Days

A measure in property management indicating the total number of days tenants occupy a property within a given period.