functional dependencies and normalization for relational databases

Functional Dependency and Normalization for Relational Datab…. The normalization procedure provides database designers with: A formal framework for analyzing relation schemas based on their keys and on the functional dependencies.

Functional Dependency and Normalization for Relational Datab… from image1.slideserve.com

Functional dependency can be defined as relationship that exits between attributes in relation. Functional dependencies are used to create relation in.

Source: image.slideserve.com

Every dependency in F has a single attribute for its RHS. 2. We cannot remove any dependency from F and have a set of dependencies that is equivalent to F. 3. We cannot replace any dependency X -> A in F with a dependency Y -> A, where Y proper-subset-of X ( Y subset-of X) and still have a set of dependencies that is equivalent to F.