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

The statement that is correct is D, as connections between M:M (many-to-many) tables in a relational database are typically established through the use of a link table or junction table. This table acts as a bridge between the two M:M tables and contains the primary key from both tables, establishing a many-to-one relationship between them. Choices A and B are incorrect as a normalized database should have data arranged in such a way that data is not duplicated, which should prevent multiple occurrences of vendor data. The accountant may have input on the database design, but it is not their primary responsibility. Choice C is incorrect as a normalized database should not result in the destruction of the audit trail, as data should be linked through foreign keys rather than deleted outright.

Which Statement Is Correct