SLR10 Databases

1.3.2a Relational database, flat file, primary key, foreign key, secondary key, entity relationship modelling, normalisation and indexing

1.3.2b Methods of capturing, selecting, managing and exchanging data

1.3.2c Normalisation to 3NF

1.3.2d SQL - Interpret and modify

1.3.2e Referential Integrity

1.3.2f Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), record locking and redundancy