Cambridge AS & A Level Computer Science
8.1Database concepts
Database concepts in Cambridge AS & A Level Computer Science: what the syllabus expects you to know, the learning objectives and how to practise.
Subtopic67 practice questions3 lessons
Learning objectives
What the syllabus expects you to be able to do.
- 8.1.1Explain the limitations of a file-based approach and the features of a relational database that address them.
- 8.1.2Use relational database terminology (entity, table, record, field, keys, relationships, referential integrity, indexing).
- 8.1.3Document a database design with an entity-relationship diagram.
- 8.1.4Explain and apply normalisation to third normal form.
Lessons
- Full access
Entity-relationship diagrams and database design
45 min
- Full access
File-based and relational databases
45 min
- Full access
Normalisation to third normal form
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 Database concepts into a strength.
Practise with instant marking, see your mastery grow and get a study plan built around your exam date.