Skip to content

Course home

x
Database design and normalisation techniques
x

Tables, keys and the aim of normalisation

Tables, keys and the aim of normalisation

Normalisation diagram showing one wide order relation split into Customer, Order, Product and OrderLine tables with keys and dependency callouts

A relational database stores data in tables called relations. Each row is a tuple, each column is an attribute, and good design tries to store each fact once in a sensible place.

Database design and normalisation techniques Lesson

  1. AS Level
  2. /Computer Science
  3. /Database design and normalisation techniques

Step-by-step lessons on AQA AS Level Computer Science Database design and normalisation techniques. Each one builds up to exam-style questions.

Lessons