(a)

Databases:

  • relational databases
  • flat file databases
  • primary keys
  • foreign keys
  • secondary keys
  • entity-relationship modelling
  • normalisation
  • indexing

(b)

Methods of capturing, selecting, managing, and exchanging data

(c)

Normalisation to third normal form (3NF)

(d)

SQL: interpreting and modifying See Required SQL commands