IGCSE Computer Science -Year 10/11- Chapter 9-Databases- 2023/2024

Chapter 9- Databases

Candidates should be able to:

1 Define a single-table database from given data storage requirements
2 Suggest suitable basic data types
3 Understand the purpose of a primary key and identify a suitable primary key for a given database table
4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table

Notes and guidance
• Including:
– fields
– records
– validation
• Including:
– text/alphanumeric
– character
– Boolean
– integer
– real
– date/time
• Limited to:
– SELECT
– FROM
– WHERE
– ORDER BY
– SUM
– COUNT
• Identifying the output given by an SQL statement that will query the given contents of a database table