Data redundancy occurs:
A)When shared databases are utilized.
B)When inventory has the same data in its files as sales has in its files.
C)When customer addresses are needed by both shipping and billing.
D)In all properly designed database management systems.

Question

Quizplus · Accepted Answer

Data redundancy occurs when the same data is stored in multiple places, such as in the inventory and sales files in this example. This can lead to inconsistencies and errors in data management. Shared databases and the need for customer addresses in multiple departments are not necessarily indicators of data redundancy. The statement "D) In all properly designed database management systems" is incorrect as proper database design aims to minimize data redundancy.

Data Redundancy Occurs