Database Normalization Tutorial

Normalization is a technique for producing a set of relations with desirable prop, given the data requirements of an enterprise...

1: Insertion Anomalies:

2: Deletion Anomalies:

3: Modification Anomalies:

FUNCTIONAL DEPENDENCY:

FD describes relationship b/w Attribute in a relation. For Example, if A & B are Attribute of

a relation R, B is functionally dependent on A (A--->B), if each value of A is in R is associated with exactly

one value of B in R...

A (on the left side of arrow) is known as Determenant, which is any Attribute on which same

other Attribute is fully functionally dependent...

FULL FUNCTIONAL DEPENDENCY:

If A--->B but B isn't functionally dependent on any proper subset of A...

TRANSITIVE DEPENDENCY:

If A, B, C are Attribute of a relation such that A--->B & B--->C than C is transitively dependent on

A via B, (provided that A is not functionally dependent on B or C)...