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)…