Normalized data occurs when attributes in the table depend only on the _______.
A)Data dictionary
B)Primary key
C)Record information
D)Secondary key

Question

Quizplus · Accepted Answer

Normalization involves breaking down a table into smaller, more simplified tables in order to eliminate redundancy and improve data consistency. A key aspect of normalization is identifying the primary key for each table, which is the attribute(s) that uniquely identifies each record in the table. When a table is fully normalized, all attributes will depend only on the primary key and not on any other non-key attributes. Therefore, the correct answer is B (Primary key).

Normalized Data Occurs When Attributes in the Table Depend Only