Topic 7 of 19
Databases and distributed systems
What the specification covers
Unit 1 (AS)Fundamentals of Computer Science
- Relational databases: benefits and drawbacks
- Primary keys, foreign keys and indexes
- Entity relationship modelling
- User views of data
Unit 4 (A2)Computer Architecture, Data, Communication and Applications
- Consistency, redundancy and data independence
- Normalisation to third normal form
- Writing SQL queries
- DBMS and data dictionaries
- Big data, warehousing and data mining
- Distributed data and processing
Study this topic
NotesClear notes for each point in the specification, with worked examples. Study subscription11 sections →FlashcardsKey terms to learn. Sort them into ones you know and ones to practise. Study subscription40 cards →QuizAuto-marked questions with an explanation after each answer. Full subscription33 questions →PracticeEndless fresh questions with the full working shown. Build a streak. Full subscription5 skills →