Main Index

Overview

• Introduction
• History
• Concepts

Database Design

• Terms of Reference

• • Database Terms
  • Database Keys

• Normalisation

• • Normalisation Overview
  • UNF - Create Model Data
  • 1NF - Repeating Attributes
  • 2NF - Partial Dependency
  • 3NF - Transitive Dependency

• Entity Relationship Modelling

• Reference

• • Terms Summary
  • Normalisation Summary

SQL

Introduction

Data Definition Language

Data Manipulation Language

Data Control Language

Reference