Skip to content
MathsGenie logo
Open app

Course home

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 covering AQA AS Level Computer Science Database design and normalisation techniques for AS Level Computer Science. Each lesson works through exam-style questions.

Lessons