Database structure, primary keys, validation and queries.
A database stores organised data so it can be searched and sorted easily.
Structure
- A table stores data about one thing; a record is a row; a field is a column.
- A primary key uniquely identifies each record (e.g. StudentID).
- Field data types: text, number, date/time, Boolean (yes/no).
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.