If a Table Has Multiple Candidate Keys and One of Those

question 4

Multiple Choice

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute.

• A) Boyce-Codd normal forms
• B) redundancies
• C) time-variances
• D) partial dependencies

---

Definitions:

Selling Price

The price at which an item or service is offered to buyers.

Variable Costs

Costs that change in proportion to the level of goods or services produced by a business.

Expenses

Outflows or using up of assets as part of operations of a business to generate revenue.

Contribution Margin

The difference between sales revenue and variable costs of a product or service, indicating how much revenue contributes toward covering fixed costs and generating profit.