Table of Contents

  1. What is Data?
    1. Database - an Explanation
    2. Keys
    3. Summary
  2. The Relational Database Model
    1. Database Example
    2. Database Queries
  3. Normalisation
    1. Complex Entities
    2. Un-Normalised Form (UNF)
    3. First Normal Form (1NF)
    4. Second Normal Form (2NF)
    5. Third Normal Form (3NF)
    6. Normalisation Activity
  4. Entity Model Diagrams
    1. Drawing the Entity Model
  5. The Data Dictionary
    1. Designing Your Database
    2. Purpose of Your Database
    3. Decide Which Tables You Need
    4. Decide What Fields You Require
    5. Data Types
    6. Primary Key
  6. Creating the Database Tables