Book 1 · Chapter 8
Databases
B1·8This chapter is free to read here.
Read it in full on cswithzak.com — every question with its mark scheme, every program ready to run. The free practice for each section is below, with the short code the book prints beside it.
For the whole chapter
- Topic pageDatabases
B1·8·T - QuizDatabases & Normalisation
B1·8·Q1 - LabNormalisation checker (3NF)
B1·8·X1 - LabER diagram builder
B1·8·X2 - LabSQL Lab
B1·8·X3
§8.1 Database concepts
Short code B1·8·1
- FlashcardsFlashcards §8.1: Relational concepts, keys & normalisation
B1·8·F1 - Past-paper questionsPast-paper questions §8.1 (database-concepts)
B1·8·1
§8.2 Database management systems
Short code B1·8·2
- FlashcardsFlashcards §8.2: DBMS features
B1·8·F2 - Past-paper questionsPast-paper questions §8.2 (database-management-systems)
B1·8·2
§8.3 DDL and DML
Short code B1·8·3
- FlashcardsFlashcards §8.3: SQL — DDL & DML
B1·8·F3 - Past-paper questionsPast-paper questions §8.3 (ddl-and-dml)
B1·8·3
From files to a database
Short code B1·8·10
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Tables and keys
Short code B1·8·11
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Relationships, E-R diagrams and integrity
Short code B1·8·12
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Normalisation: UNF to 3NF
Short code B1·8·13
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Is it in 3NF? Explaining and designing
Short code B1·8·14
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
The DBMS: features and tools
Short code B1·8·15
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
SQL and the DDL: creating and changing tables
Short code B1·8·16
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Querying: SELECT, WHERE, ORDER BY and aggregates
Short code B1·8·17
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Two tables at once: INNER JOIN
Short code B1·8·18
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Changing the data: INSERT, UPDATE, DELETE
Short code B1·8·19
Practice for this page of the book: the quiz, flashcards and past-paper questions for its section are listed above.
Workbook 1: Databases
Short code W1·8 · Theory Fundamentals Workbook
The write-in workbook for this chapter — drills, exam-style practice, trace tables, fix-the-mistake and mark-it-yourself pages. Its full mark schemes and an interactive version arrive here with the chapter.
