Table of Contents

  1. Introduction
    1. Brief History
    2. Database Defined
    3. Advantages and Limitations
    4. Stages in Creating a Database
    5. Entity
    6. Attribute
  2. Relationship
    1. Degrees of Relationship (Cardinality)
    2. One-to-One (1:1)
    3. One-to-many (1:M)
    4. Many-to-Many (M:N)
  3. Key Field
    1. Primary Key
    2. Secondary Key
    3. Foreign Key
    4. Simple Key
    5. Compound Key
    6. Composite Key
  4. The Process of Normalisation
    1. Anomalies
    2. Update Anomalies
    3. Delete Anomalies
    4. Insert Anomalies
    5. Normalisation Stages
  5. Normalisation Example
    1. Step 1
    2. Step 2
    3. 1NF Tables: Repeating Attributes Removed
    4. Step 3
    5. 2NF Tables: Partial Key Dependencies Removed
    6. Step 4
    7. 3NF Tables: Non-Key Dependencies Removed
    8. Summary of Normalisation Rules
    9. SAQ 1
    10. SAQ 2
  6. Data Integrity
    1. Domain Constraints
    2. Entity Integrity
    3. Column Constraints
    4. User-Defined Integrity Constraints
    5. Referential Integrity