Ch 03: Normalization: Some Generalities

Second, the decomposition process is basically a processof taking projections…

Nonloss is not strictly the same as information equivalent.

Normalisation is done against RELVARs

EQD Equality Dependency

Update anomaly is usually caused by FD

In general, BCNF is the solution to the problems caused by the kinds of anomalies listed above.

Higher level of normalisation => more redunancies and fewer update anomalies.

Decomposition adds constraints (multi-RELVAR)

Normal form is equivalent to canonical form of data.