Please enable JavaScript.

Coggle requires JavaScript to display documents.

Normalisation DB - Coggle Diagram

- - - - remove all multi-valued attributes
      - prohibits nesting or repeating groups in tables
        
        a relation is in the 1NF if it has a fixed number of column, all of whose values are atomic.
      - Second Normal Form
        
        remove all transitive dependensies
        
        prohibits a composite primary key
        
        A relation is in the 2NF if the relation is in the 1NF and each nonkey column depends on all candidate keys, not on a subset of any candidate key
        
        Third Normal Form
        
        PK has more than 1 field: all fields are depend on whole key
        
        prohibits transitive dependencies
        
        A relation is in the 3NF if the relation is in the 2NF and each nonkey column depends only on candidate keys, not on other nonkey columns