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. The Need for Normalisation
    1. Complex Entities
    2. Un-Normalised Form (UNF)
    3. Converting to First Normal Form (1NF)
    4. Converting to Second Normal Form (2NF)
    5. Convert to Third Normal Form (3NF)
    6. Normalisation Activity
  4. Entity Model Diagrams
    1. Drawing the Entity Model
  5. The Data Dictionary
  6. Creating the Database Tables