Which statement describes the process of normalizing databases?
A.
All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are
corrected.
B.
Redundant tables are combined into one larger table to simplify the schema design.
C.
Numeric values are checked against upper and lower accepted bounds. All text is purged
of illegal characters.
D.
Columns that contain repeating data values are split into separate tables to reduce item
duplication.
E.
Indexes are created to improve query performance. The data of types of columns are
adjusted to use the smallest allocation.
D
why is not E?
E means optimization, not normalization
Its E, D is wrong