Which normal form requires all determinants to be candidate keys?
- First Normal Form
- Fourth Normal Form
- Second Normal Form
- Third Normal Form
Third Normal Form (3NF) requires that every non-prime attribute is non-transitively dependent on every candidate key in the table. In other words, all determinants must be candidate keys. This eliminates any transitive dependencies and ensures data integrity and consistency.
Loading...
Related Quiz
- How does data compression impact database performance in DB2?
- In addition to IBM Data Studio, which other IDEs are commonly used for DB2 development and administration?
- ________ transactions are handled concurrently in DB2.
- Having too many indexes on a table in DB2 can lead to increased ________ overhead.
- DB2 stored procedures can be written in ________.