9.1

Database concepts

Cambridge IGCSE Computer Science (0478)  · Unit 9: Databases  · 9 flashcards

Database concepts is topic 9.1 in the Cambridge IGCSE Computer Science (0478) syllabus , positioned in Unit 9 — Databases , alongside SQL.  In one line: A database is an organized collection of structured data, typically stored electronically and accessed via a database management system (DBMS). Databases enable efficient storage, retrieval, modification, and deletion of data. Examples of popular DBMS include MySQL and MongoDB.

This topic is examined in Paper 1 (computer systems theory) and Paper 2 (algorithms, programming and logic).

The deck below contains 9 flashcards — 5 definitions and 4 key concepts — covering the precise wording mark schemes reward.  Use the 5 definition cards to lock down command-word answers (define, state), then move on to the concept and application cards to handle explain, describe and compare questions.

Key definition

The term 'database' in the context of data management

A database is an organized collection of structured data, typically stored electronically and accessed via a database management system (DBMS). Databases enable efficient storage, retrieval, modification, and deletion of data. Examples of popular DBMS include MySQL and MongoDB.

What the Cambridge 0478 syllabus says

Official 2026-2028 spec

These are the exact learning objectives Cambridge sets for this topic. Match the command word (Describe, Explain, State, etc.) in your answer to score full marks.

  1. Define Define a single-table database from given data storage requirements including fields, records, validation
  2. Suggest Suggest suitable basic data types including text/alphanumeric, character, Boolean, integer, real, date/time
  3. Understand Understand the purpose of a primary key and identify a suitable primary key for a given database table
  4. Read Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table including SELECT, FROM, WHERE, ORDER BY, SUM, COUNT
Definition Flip

Define the term 'database' in the context of data management.

Answer Flip

A database is an organized collection of structured data, typically stored electronically and accessed via a database management system (DBMS). Databases enable efficient storage, retrieval, modification, and deletion of data. Examples of popular DBMS include MySQL and MongoDB.

Key Concept Flip

Explain the difference between a 'table' and a 'record' within a database.

Answer Flip

A 'table' is a collection of related data organized in rows and columns, representing a specific entity (e.g., students, products). A 'record' (or row) represents a single instance of that entity.

Example: a table called 'Students' might contain records with fields like 'StudentID', 'Name', and 'Age'.
Definition Flip

What is a 'field' in a database table, and what characteristics define it?

Answer Flip

A 'field' is a single piece of data representing an attribute of an entity (e.g., student, product). Each field has a name and a specific data type, which defines the kind of values it can store.

Example: 'Student_ID' would be a field with a 'text' or 'number' data type, while 'Date_of_Birth' would be a field with a 'date' data type.
Definition Flip

Explain the purpose of a 'primary key' and provide an example.

Answer Flip

A 'primary key' is a unique identifier for each record in a table, ensuring no two records are identical.

Example: Student ID in a student table, or product code in a product table.
Definition Flip

Describe the function of a 'foreign key' and how it relates to tables in a relational database.

Answer Flip

A 'foreign key' is a field in one table that refers to the primary key of another table. It establishes a link between the two tables, enforcing referential integrity and enabling relationships.

Key Concept Flip

Explain the concept of a 'relationship' in a relational database.

Answer Flip

A 'relationship' defines how data is linked between two or more tables using primary and foreign keys. This ensures data consistency and allows for efficient data retrieval across multiple tables.

Key Concept Flip

Outline the differences between 'one-to-one', 'one-to-many', and 'many-to-many' relationships with suitable examples.

Answer Flip

One-to-one: One person has one passport. One-to-many: One author can write many books. Many-to-many: Many students can enroll in many courses (requires a junction table).

Definition Flip

What is a 'flat file' database and what are its limitations compared to a relational database?

Answer Flip

A 'flat file' database stores data in a single table, without relationships. Limitations include data redundancy, inconsistency, and difficulty in querying complex relationships compared to relational databases.

Key Concept Flip

Explain the key advantage of using a 'relational database' over a 'flat file' database for managing complex data.

Answer Flip

Relational databases minimize data redundancy and ensure data consistency by storing related data in separate tables linked through relationships, allowing for efficient querying and data manipulation of complex data sets.

Review the material

Read revision notes with definitions, equations, and exam tips.

Read Notes

Test yourself

Practice with MCQ questions to check your understanding.

Take Computer Science Quiz
8.3 Procedures and functions 9.2 SQL

Key Questions: Database concepts

Define the term 'database' in the context of data management.

A database is an organized collection of structured data, typically stored electronically and accessed via a database management system (DBMS). Databases enable efficient storage, retrieval, modification, and deletion of data. Examples of popular DBMS include MySQL and MongoDB.

What is a 'field' in a database table, and what characteristics define it?

A 'field' is a single piece of data representing an attribute of an entity (e.g., student, product). Each field has a name and a specific data type, which defines the kind of values it can store.

Example: 'Student_ID' would be a field with a 'text' or 'number' data type, while 'Date_of_Birth' would be a field with a 'date' data type.
Explain the purpose of a 'primary key' and provide an example.

A 'primary key' is a unique identifier for each record in a table, ensuring no two records are identical.

Example: Student ID in a student table, or product code in a product table.
Describe the function of a 'foreign key' and how it relates to tables in a relational database.

A 'foreign key' is a field in one table that refers to the primary key of another table. It establishes a link between the two tables, enforcing referential integrity and enabling relationships.

What is a 'flat file' database and what are its limitations compared to a relational database?

A 'flat file' database stores data in a single table, without relationships. Limitations include data redundancy, inconsistency, and difficulty in querying complex relationships compared to relational databases.

More topics in Unit 9 — Databases

Database concepts sits alongside these Computer Science decks in the same syllabus unit. Each uses the same spaced-repetition system, so progress in one informs the next.

9.2 SQL

10 flashcards

Cambridge syllabus keywords to use in your answers

These are the official Cambridge 0478 terms tagged to this section. Mark schemes credit responses that use the exact term — weave them into your answers verbatim rather than paraphrasing.

database table record field primary key foreign key relationship one-to-one one-to-many many-to-many flat file relational database

Key terms covered in this Database concepts deck

Every term below is defined in the flashcards above. Use the list as a quick recall test before your exam — if you can't define one of these in your own words, flip back to that card.

The term 'database' in the context of data management
'field' in a database table, and what characteristics define it
Explain the purpose of a 'primary key' and provide an example
Describe the function of a 'foreign key' and how it relates to tables in a relational database
'flat file' database and what are its limitations compared to a relational database

How to study this Database concepts deck

Start in Study Mode, attempt each card before flipping, then rate Hard, Okay or Easy. Cards you rate Hard come back within a day; cards you rate Easy push out to weeks. Your progress is saved in your browser, so come back daily for 5–10 minute reviews until every card reads Mastered.