AQA•A-Level•Computer Science
🗄️
Fundamentals of Databases
Relational databases, normalisation, SQL, and transactions
Practice 58 subtopics in Fundamentals of Databases. All questions match the AQA A-Level specification.
About Fundamentals of Databases
Fundamentals of Databases is a key topic in the AQA A-Level Computer Sciencespecification. This topic covers relational databases, normalisation, sql, and transactions.
Master all 58 subtopics below with unlimited AI-generated questions. Each subtopic page includes sample questions and the ability to generate unlimited practice questions with detailed solutions.
All Subtopics (58)
🎲
Random Practice
Practice any subtopic from Fundamentals of Databases
Entity-relationship modellingEntitiesAttributesRelationshipsEntity-relationship diagramsCardinalityOne-to-oneOne-to-manyMany-to-manyRelational database conceptsTablesRecordsFieldsPrimary keyForeign keyComposite keySecondary keyReferential integrityPurpose of normalisationFirst normal form (1NF)Second normal form (2NF)Third normal form (3NF)Eliminating redundancyData integrityData definition language (DDL)CREATE TABLEALTER TABLEDROP TABLEData manipulation language (DML)SELECTINSERTUPDATEDELETEWHERE clauseORDER BYGROUP BYHAVINGJOIN operationsINNER JOINLEFT JOINRIGHT JOINAggregate functionsCOUNTSUMAVGMINMAXClient-server architectureConcurrent accessRecord lockingSerialisationTimestamp orderingCommitment orderingACID propertiesAtomicityConsistencyIsolationDurability
Start Practicing Fundamentals of Databases
Choose any subtopic above to begin practicing with unlimited AI-generated questions.
Start with Entity-relationship modelling