A Table Is in Second Normal Form When It Is

question 28

Multiple Choice

A table is in second normal form when it is in first normal form and _____.

• A)each nonkey column is dependent on the entire primary key field
• B)it contains candidate keys
• C)it allows no data modification anomalies
• D)it contains at least one foreign key field

---

Definitions:

Equal Dignity Rule

A legal doctrine requiring that contracts authorizing someone to conduct a transaction must be executed with the same formality as required for the transaction itself.

Statute of Frauds

A legal doctrine requiring certain types of contracts, such as for the sale of land or goods over a certain value, to be in writing to be enforceable.

Respondeat Superior

A legal doctrine holding employers liable for wrongful acts committed by employees while performing their job duties.

Independent Contractor

A person or entity contracted to perform work for another entity as a non-employee, responsible for their own taxes and benefits.