2.Integrity Concepts

  1. Data Integrity

    1. Declarative

      1. Entity integrity

        1. UNIQUE constraints

        2. PRIMARY KEY constraints.

      2. Domain integrity

        1. CHECK constraints

        2. Rules

        3. DEFAULT definitions

        4. NOT NULL definitions

      1. Referential integrity

        1. FOREIGN KEY constraints

      1. User-defined integrity

        1. User-defined integrity lets you define specific business rules that do not fall into one of the other integrity categories.

        2. All the integrity categories support user-defined integrity.

        3. This includes all column-level and table-level constraints in CREATE TABLE, stored procedures, and triggers.

    1. Procedural

      1. Implemented through stored procedures, and triggers