Which of the following is a function of normalization?
A) assigning primary keys
B) assigning incremental numbers to records
C) minimizing duplication of information
D) converting primary keys to foreign keys

Question

Quizplus · Accepted Answer

Normalization aims to minimize duplication of information by breaking down data into smaller, logical tables and establishing relationships between them. This helps to ensure data consistency and avoid data anomalies. While assigning primary keys and incremental numbers to records are aspects of normalization, they are not its primary function. Converting primary keys to foreign keys is more related to establishing relationships between tables in a database, rather than normalization itself.

Which of the Following Is a Function of Normalization