Please enable JavaScript.

Coggle requires JavaScript to display documents.

Normalization, References: https://bookdown.org/paranedagarcia/database/no…

- - - - Second Normal Form (2FN)
        
        It makes sure that all columns that are not keys are independent from the primary kery (PK).
      - Boyce - Codd NF
        
        Its similar to the 3FN but it tends to be more strict.
      - Third Normal Form (3FN)
        
        It deletes any transitive dependency.
      - First Normal Form (1FN)
        
        It includes the elimination of repeated groups.
- - - - Trivial functional dependency
        
        A dependent is always a subset of the determinant.
        i.e. If X → Y and Y is the subset of X, then it is called trivial functional dependency
      - Non-Trivial functional dependency
        
        The dependent is strictly not a subset of the determinant.
        i.e. If X → Y and Y is not a subset of X, then it is called Non-trivial functional dependency.
      - Multivalued functional dependency
        
        Entities of the dependent set are not dependent on each other.
        i.e. If a → {b, c} and there exists no functional dependency between b and c, then it is called a multivalued functional dependency.
      - Transitive functional dependency
        
        Dependent is indirectly dependent on determinant.
        i.e. If a → b & b → c, then according to axiom of transitivity, a → c. This is a transitive functional dependency