Skip to content

Relational databases: a key and a relationship

Introduced
Watch lesson
Vocabulary
English Meaning
relational database/rɪˈleɪʃənl ˈdeɪtəbeɪs/A database that organises data into tables connected through matching key values.
primary key/ˈpraɪməri kiː/A field or combination of fields that uniquely identifies each record in a database table.
foreign key/ˈfɒrən kiː/A field or group of fields that refers to a candidate key in another or the same database table.
record/ˈrekɔːd/A stored collection of information about an item, person or event.
field/fiːld/A named item of data within a database record.
normalisation/ˌnɔːməlaɪˈzeɪʃn/Organising relational database tables to reduce unnecessary duplication and avoid update, insertion and deletion anomalies.
Next →

Handout

Log in or create account

IGCSE, A-Level & AP