What must be done to certain types of data in a database so that there is a consistent syntax that allows accurate field searching or sorting?
A) normalization
B) metrics analysis
C) unitization
D) subjective coding

Question

Quizplus · Accepted Answer

Normalization is the process of organizing data in a database to reduce redundancy and dependency between different fields. This ensures a consistent syntax and eliminates anomalies that might affect accurate field searching or sorting. By breaking down larger tables into smaller, related tables, normalization helps to avoid duplication of data and inconsistencies in record values.

What Must Be Done to Certain Types of Data in a Database