If your database table has a lot of redundant data,how can you fix it?
A)delete the redundant data
B)eliminate the table
C)split the table into two and use a foreign key
D)split the table into two and use a composite key

Question

Quizplus · Accepted Answer

The best way to fix redundant data in a database table is to split it into two tables and use a foreign key relationship. This reduces data duplication and improves data integrity. The original table can be left with only unique data while the redundant data can be moved to the second table with a foreign key linking it back to the original table. This approach allows for better organization and faster data retrieval. Deleting data or eliminating the table altogether may result in loss of important data, and splitting the table with a composite key may not be necessary if the foreign key approach can sufficiently address the redundant data issue.

If Your Database Table Has a Lot of Redundant Data,how