How different normal forms reduces data redundancy?
Answers
Answer:
Reduce data redundancy
An existing ER diagram was presented earlier and illustrated how the entities in the diagram could be represented as tables.
Now I will show you how to examine your tables to ensure they reduce data redundancy and allow records to be
added,
updated, and
deleted
without inadvertently changing or removing important information.
If you are stuck and do not know how to proceed with your database design, focus on creating tables where each table represents a single entity. This is the easiest way to create a solid database design.
What is Data Redundancy?
Data redundancy occurs in database systems which have a field that is repeated in two or more tables. When customer data is duplicated and attached with each product bought, then redundancy of data is a known source of inconsistency, since the entity "customer" might appear with different values for a given attribute.
Data redundancy leads to data anomalies and corruption and should be avoided when creating a relational database consisting of several entities. Database normalization prevents redundancy and makes the best possible usage of storage. The proper use of foreign keys can minimize data redundancy and reduce the chance of destructive anomalies appearing. Concerns with respect to the efficiency and convenience can sometimes result in redundant data design despite the risk of corrupting the data.
Hope this answer helps you.