Relational Databases

GCSE Computer Science: Relational Databases

This module contains:

  • An editable PowerPoint lesson presentation
  • Editable revision handouts
  • A glossary which covers the key terminologies of the module
  • Topic mindmaps for visualising the key concepts
  • Printable flashcards to help students engage active recall
  • A quiz with answer key to test knowledge and understanding of the module
Compatible with the following examination boards
Relational Databases Image 19
Relational Databases Image 20
Relational Databases Image 21
Relational Databases Image 22
Relational Databases Image 23

Download →

Relational Databases

A relational database is a type of database that is structured and allows users to identify and access data which is in relation to other data. A relational database is efficient over flat-file databases as it is more efficient and takes up less space in memory. Data redundancy, which is repetition of data in a database, is overcome in relational databases. Hence, a large set of data is distributed over various tables and connected using a relationship in the relational database. For example, a library may store information such as a book list, member list, department, book location, research paper list, staff details and many more. Storing these details in a single flat-file system would lead to more memory space requirement and data redundancy.

This GCSE Computer Science module introduces relational databases to your students, explaining:

  • Characteristics of relational database
  • What is normalisation
  • Relationship between entities
  • How to work with the database

More Databases Modules

Relational Databases is one lesson in our Databases module. The other databases lessons can be found below:

Relational Databases Image 24
Introduction to Databases
Relational Databases Image 25
Structured Query Language (SQL)
Relational Databases Image 26
Data Organisation
Relational Databases Image 27
Database Management Systems