Occasionally one may hear that a data model is “over-normalized,” but just what does that mean? Normalization is intended to analyze the functional dependencies across a set of data. The goal is to ...

An indirect relationship between data elements in a database. For example, social security number is a transitive dependency of date-of-birth (SSN->DOB), because it is dependent on name (SSN->NAME), ...