Figure 1 shows two tables from a database used by a school library to track authors and their publications.
| AuthorID | FirstName | LastName | Nationality |
|---|---|---|---|
| 101 | Arthur | Conan | British |
| 102 | Agatha | Christie | British |
| 103 | Stephen | King | American |
| BookID | AuthorID | Title | ReleaseYear |
|---|---|---|---|
| 501 | 101 | A Study in Scarlet | 1887 |
| 502 | 101 | The Sign of Four | 1890 |
| 503 | 102 | The Murder of Roger | 1926 |
| 504 | 103 | The Shining | 1977 |
Define the term relational database.
38 exam-style questions on AQA GCSE Computer Science Relational databases. Each one has a worked solution and a mark scheme showing where the marks go.