Scribd
Upload
299 views3 pages

Data Redundancy in Relational Databases

Data redundancy can destroy database effectiveness by leading to anomalies, but this can be controlled through the use of foreign keys which are common attributes shared between tables. While redundancy is measured by whether eliminating an attribute also eliminates information, controlled redundancies are sometimes included in designs to ensure transaction speed and information requirements are met.

Uploaded by

Viny Wenkz
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
299 views3 pages

Data Redundancy in Relational Databases

Data redundancy can destroy database effectiveness by leading to anomalies, but this can be controlled through the use of foreign keys which are common attributes shared between tables. While redundancy is measured by whether eliminating an attribute also eliminates information, controlled redundancies are sometimes included in designs to ensure transaction speed and information requirements are met.

Uploaded by

Viny Wenkz
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Data Redundancy Revisited

THE RELATIONAL DATA MODEL


Data redundancy leads to anomalies which can
destroy the effectiveness of the database.

This can be controlled by using common attributes


that are shared by tables, called foreign keys.

The real test of redundancy is not how many copies


of a given attribute are stored, but whether the
elimination of an attribute will eliminate
information.
However, there are controlled redundancies
which are often designed as part of the system to
ensure transaction speed and/or information
requirements.

You might also like