Which of the the following is a condition for a relation to be in Third Normal Form (3NF) (using the common definition in Silberschatz et al.)?

Question

Accepted Answer

For every nontrivial 𝑋→𝐴 either 𝑋 is a superkey or 𝐴 is a prime attribute (i.e. part of some candidate key)

Answer

Every non‑prime attribute must be fully dependent on every candidate key

Answer

For every nontrivial functional dependency 𝑋 → 𝐴, X must be a superkey

Answer

The schema must already be in BCNF

Crowdly