Scribd
Upload
17 views1 page

Every table, if storing the data of

Uploaded by

b.nagnath194
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
17 views1 page

Every table, if storing the data of

Uploaded by

b.nagnath194
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

Every table, if storing the data of real life, has minimum combination of

columns which helps to identify a row uniquely in the table. It is called as


primary key

The remaining columns in the table apart from Primary Key are called as
Non-Keys.

If a Non-key column is only dependent on some of the columns of Primary


Key then it is called as Partial Dependency. Partial Dependency is
undesirable and so it has to be eliminated by removing dependent
columns in separate table
9. If a Non-key column is dependent on another Non-key Column then it is
called as Transitive Dependency. Transitive Dependency is also
undesirable. It has to be eliminated by removing dependent columns in
separate table
10. When there is Partial Dependency or Transitive Dependency present in
the table then there is repetition of fact. This is called as Redundancy
11. Partial Dependency, Transitive Dependency and Redundancy together
create problems in performing operations – Insert, Update and Delete.
These problems are given the names Insert Anomaly, Update Anomaly
and Deletion Anomaly. So data manipulation through SQL is not possible
in such case. Hence we split the table to eliminate these Anomalies and
Redundancies, the process is called a Normalization

You might also like