Theory - Databases And SQL

Question 1

Benefits of relational databases

Answer 1

Reduces data redundancy
Reduces data inconsistency

Question 2

Flat-file databases

Answer 2

Store all the data in one table, which makes them simple to set up and understand

Question 3

Relational databases

Answer 3

More complicated - they are made up of multiple tables that are often linked together using primary keys (see above) and foreign keys (see below)

Question 4

Foreign key

Answer 4

Field that references the primary key of another table
This creates a link between two tables, as shown below