Jackie is a new database administer. She notices that many of the tables are poorly constructed. What should she do to create more well-structured tables?
A) Jackie should delete the table and begin again.
B) Jackie should create a new database.
C) There is nothing Jackie can do; once the tables are created they are set.
D) Jackie should normalize the tables.

Question

Quizplus · Accepted Answer

Normalizing the tables is the best choice as it will help Jackie create more well-structured tables. Normalization is the process of organizing data in a database so that it is consistent and avoids duplication of data. This makes it easier to manage and maintain the database. By normalizing the poorly structured tables, Jackie can ensure that the data is consistent and efficient. Deleting the table and starting again or creating a new database are not necessary actions unless the existing database is completely unusable. There is no truth in the statement that once the tables are created they are set, as they can be modified and structured to be more efficient.

Jackie Is a New Database Administer