SQL

Primary Key

Unique identifier for each record in a table.

Foreign Key

A field that references the primary key of another table.

Flat-File

All data in single table.

Relational Database

Data stored in multiple tables and linked using primary and foreign key.

Pros of relational databases

Inputting, Updating, Deleting only has to be done in one place, preventing inconsistencies.

Storage space saved, as data only saved once

Can be made more secure

Field

A column to store a specific piece of information

Record

A row that uses fields to store details about a specific item

Data Redundancy

Lots of repeated data

Data Inconsistency

Same data stored in multiple locations contains conflicting values