Which statement is correct?
A) in a normalized database, data about vendors occur in several locations
B) the accountant is responsible for database normalization
C) in a normalized database, deletion of a key record could result in the destruction of the audit trail
D) connections between M:M tables are provided by a link table

Question

Quizplus · Accepted Answer

Option A is incorrect because in a normalized database, data about vendors should only be stored in one location to avoid duplication and ensure data consistency. 
Option B is incorrect because database normalization is a task that falls under the responsibility of a database administrator or a data analyst. 
Option C is incorrect as deletion of a key record should not destroy the audit trail but could invalidate related records or cause referential integrity issues. 
Option D is correct because a link table is used to establish connections between two M:M (many-to-many) tables in a relational database.

Which Statement Is Correct