Tables, records and fields, primary and foreign keys, relational databases, validation and basic queries.
A database stores organised data so it can be searched, sorted and updated efficiently.
Structure
- A table holds data about one entity (e.g. Students).
- A record (row) is one item; a field (column) is one attribute.
- A primary key uniquely identifies each record (e.g. StudentID).
- A foreign key links to a primary key in another table.
Viewing only
This content is free to read on superexams.com and cannot be printed or downloaded.
Read the full note — free
Create a free account to read this note in full. Every free account gets 2 complete revision notes — no card needed.