Please enable JavaScript.

Coggle requires JavaScript to display documents.

DBMS - Coggle Diagram

- - - - Reflexivity rule
      - Augmentation rule
      - Transitivity rule
      - sound: this axiom does not generate any incorrect functional dependencies
      - complete: can generate all F+ for a given set F of functional dependencies
    - - Extraneous attributes
  - - - relation instance: refer to a specific instance of a relation
    - - domain: refer to a set of permitted values for a attribute
        
        atomic: if elements of the domain are considered to be indivisible units.
- - - - Selection: selects tuples satisfying a given predicate.
      - Projection: produces the relation.
      - Rename
    - - Cartesian-product: Combine information from any two relations.
        
        n_1 * n_2 ways
      - Join: combines a selection and a cartesian product into a single operation.
      - Union
        
        Same set of attributes
        
        Attribute domains must be compatible.