Normalization is a formal technique for analyzing relations based on their primary key (or candidate keys) and functional dependencies (Codd, 1972b). The technique involves a series of rules that can be used to test individual relations so that a database can be nor- malized to any degree. When a requirement is not met, the relation violating the require- ment must be decomposed into relations that individually meet the requirements of normalization.