Cambridge IGCSE Computer Science
9Databases
Databases in Cambridge IGCSE Computer Science: what the syllabus expects you to know, the learning objectives and how to practise.
Topic38 practice questions2 lessons
Learning objectives
What the syllabus expects you to be able to do.
- 9.1Define a single-table database (fields, records, validation) from given requirements.
- 9.2Suggest suitable basic data types for fields.
- 9.3Explain the purpose of a primary key and choose a suitable one.
- 9.4Read, complete and write SQL scripts that query a single table (SELECT, FROM, WHERE, ORDER BY, SUM, COUNT, AND, OR) and state their output.
Lessons
- Full access
Designing a database table: fields, records, data types and keys
45 min
- Full access
Querying a table with SQL
50 min
Join to read every lesson, or see what Full access includes.
Sample question
A sample question on this topic. Answer it, check it, then read the worked answer.
Turn Databases into a strength.
Practise with instant marking, see your mastery grow and get a study plan built around your exam date.