Relational databases and structured query language (SQL)

A relational database has been developed for a youth club to store information about their members and the awards they are given. The database contains two tables: **Member** and **Award**. **Figure 4** shows some data from the tables. Define the term **relational database**.

State **one** benefit of using relational databases.

State the name of the field from the **Member** table that is the most suitable to use as the primary key.

State the name of the field from the **Award** table that is a foreign key.

The youth club needs to produce a report listing the members who have been given the Leader award. The report must include both names of each member and the date the award was presented. The results must be in order of the date the awards were presented, starting with the earliest. Write an SQL query that could be used to find this information.

A new member joins the youth club. The following SQL is run to add their details to the database: `INSERT INTO A (B) VALUES (5, 'Alina', 'Ahmed', '2020-11-30')` Some of the SQL has been replaced by labels. State the SQL that should have been written in place of the labels **A** and **B**.