Question

In testing, you find that one of the tables in your database has multiple versions of one of the columns, and updating the information requires the user to go to several different places to make sure the update completes. What process should you use to fix this kind of issue?

A. Denormalization
B. Normalization
C. Insertion
D. Compiling

Answer 1

B. Normalization

Step-by-step explanation:

When testing and finding that one of the tables in the database has multiple versions of one of the columns, and updating the information requires the user to go to several different places to make sure the update completes, this is an indication of poor database design. This kind of issue is best fixed by using the process of normalization.