OCR H446 · Component 01

1.3.2 Databases

SQL, databases, data capture, APIs and exchange formats, relational databases, keys, referential integrity, indexing, ERDs, record locking, ACID, and normalisation.

Topic overview

Build accurate recall, then apply it.

RecallStride combines active flashcards, quick checks, exam practice and scheduled review. Progress is based on learning evidence rather than passive completion.

Write SQL to add ItemID 27, ItemName 'Compass' and Price 8.50 to Item(ItemID, ItemName, Price).Write
Write SQL to select ItemName from Item where Price exceeds the mean Price of all items.Write
Loan(MemberID,ItemID,MemberName,ItemName) has composite key (MemberID,ItemID). Names depend only on their respective IDs. Explain the 2NF defect and give a decomposition.Apply
A transfer subtracts money from one balance and adds it to another. Explain atomicity and durability.Apply
What is a database?Basics
What are tables, records, and fields?Basics

Published with owner authorisation; awaiting independent academic review. RecallStride is independently produced and is not endorsed by OCR. OCR is a registered trademark of OCR.