When data are normalized, attributes in the table depend only on the secondary key.

Question

Quizplus · Accepted Answer

When data are normalized, attributes in the table depend on all primary and candidate keys, not just secondary keys. Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down a table into multiple smaller tables and establishing relationships between them. In the resulting normalized tables, attributes depend on all primary and candidate keys to ensure that data is stored in a consistent and efficient manner.

When Data Are Normalized, Attributes in the Table Depend Only