A Relation Is in Second Normal Form (2NF) If It

question 93

Multiple Choice

A relation is in second normal form (2NF) if it is in first normal form (1NF) and:

• A) if the only determinants it contains are candidate keys.
• B) no non-key attribute is dependent on only a portion of the primary key.
• C) it does not contain any repeating groups.
• D) computed fields are eliminated.

---

Definitions:

Producer Surplus

The difference between the amount that a producer is paid for a good or service and the lowest amount they are willing to accept for that good or service.

Consumer Surplus

The gap between the price consumers are prepared to pay and the actual price they pay for a product or service, signifying the advantage received by consumers.

Price Floor

A legal minimum price below which a good or service cannot be sold.

Pharmaceutical Companies

Pharmaceutical companies are businesses licensed to research, develop, market, and distribute drugs, typically in the context of healthcare.