Normalization is the process of removing redundant(repetition) data from your tables in order to:
1) improve storage efficiency
2) data integrity and
Normalization is a technique to store data in database.
Anomalies(Problems) in DBMS:
Functional Dependencies :
1) If an attribute or a set of attributes identify the whole tuple(row / record) uniquely then we can say it is functionally dependent.
Types of Functional Dependencies
(i) Trivial Functional Dependency:
If X->Y, and if Y is a subset of X, this is called a Trivial FD.
(ii) Non-Trivial Functional Dependency:
If X->Y, and if Y is not a subset of X, this is called a Non-Trivial FD.
Stay tuned for the next topic!