Tables, records and fields, primary and foreign keys, relational databases and validation.
A database stores organised data for efficient searching and updating.
Structure
- A table stores data about one entity; a record is a row, a field a column.
- A primary key uniquely identifies each record; a foreign key links to 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.