Which of the Following Statements Regarding Normal Forms Is Incorrect

question 25

Multiple Choice

Which of the following statements regarding normal forms is incorrect?

• A) A table is in first normal form if it has multivalued or repeating data elements.
• B) A table that has a single primary key is in second normal form.
• C) Converting a table into second normal form applies only to a table that has a composite key.
• D) A table is in third normal form if it is in second normal form and has no transitive dependencies.

---

Definitions:

Produced Goods

Items that have been manufactured or processed from raw materials, ready for sale and distribution in the marketplace.

Closed Shop

A form of union security agreement where the employer agrees to hire union members only, and employees must remain members of the union at all times in order to remain employed.

American Federation of Labor

A national federation of labor unions in the United States, founded in 1886, focusing on fair labor standards and worker rights.

Arbiter of Disputes

An impartial third party, often a mediator or arbitrator, who is called upon to resolve a dispute or conflict between two or more parties.