Please enable JavaScript.

Coggle requires JavaScript to display documents.

ERD & Relational models - Coggle Diagram

- - - - Weak
      - Strong
  - - - Simple
      - Composite
      - Single valued
      - Multi-valued
      - Derived
  - - - Degree of relationships
        
        unary
        
        binary
        
        ternary
        
        n-ary
      - Cardinality ratio
        
        1-1
        
        1-n
        
        n-1
        
        n-n
      - Participation constraints
        
        Partial
        
        single line
        
        Total
        
        double line
- - - - CREATE
      - ALTER
      - RENAME
      - DROP
    - - INSERT
      - UPDATE
      - DELETE
    - - SELECT
    - - GRANT
      - REVOKE
    - - ROLLBACK
      - SAVEPOINT
      - COMMIT
  - - - PRIMARY KEY
    - - FOREIGN KEY
    - - CHECK
      - UNQIUE
      - NOT NULL
      - DEFAULT
  - - - Creation
      - Updation
      - Deletion
      - Altering