s5.07 - databases and big data
Master database design, normalisation, and SQL. Essential skills for your project and future career.
Comparing flat-file limitations like data redundancy with the structured integrity of relational database systems.
Master relational database entities, attributes, primary, foreign, and composite keys for robust relational schema design.
Master database normalisation to 3NF, understanding 1NF, 2NF, and 3NF to design efficient, reliable relational schemas.
Master Data Definition Language (DDL) for A-Level Computer Science. Learn to define, create, and manage relational database schemas using SQL.
Master SQL Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE for A-Level relational databases.
Master advanced SQL JOINs and subqueries. Retrieve complex data from normalised relational databases with precision.
Master client-server database architecture, concurrent access challenges, and multi-user data integrity.
A-Level lesson on ACID properties (Atomicity, Consistency, Isolation, Durability) and record locking for database integrity.
Explore Big Data's Volume, Velocity, Variety. Understand why relational databases fail, and analyse its real-world implications.
Last modified: October 19th, 2026
