For National 5 Computing Science, revise the use of primary and foreign keys and the difference between flat file and relational databases.

Flat file and relational databases The simplest databases store data in a single file, where each record is identified as a new line and each row can be separated by a comma.