Normal Forms based on MFD

A multimedia database schema is in first multimedia normal form (1MNF) if each attribute A has the type of number, string or elementary generalized icon. R is in second multimedia normal form (2MNF) if it is in 1MNF and each non prime attribute A is fully dependent on the primary key. R is in third multimedia normal form (3MNF) if it is in 2MNF and the non prime attributes are not mutually dependent.

Equivalently, we can say that whenever a MFD Xs1 -> As2 holds in R, either (a) X is a superkey of R, or (b) A is a prime attribute of R.