1) Block 2 Part 1 – Requirements Engineering
Offline interactive quiz (50+ questions). Auto-marking, feedback, score.
2) Block 2 Part 3 – The database context
Offline interactive quiz (60 questions). Topics + shuffle + auto-marking.
3) Block 2 Part 4 – Conceptual models
Offline interactive quiz (60 questions). ER modelling, constraints, optionality/degree, data dictionary.
4) Block 2 Part 5 – The relational model
Offline interactive quiz (60 questions). PK/FK, integrity rules, posted-key vs relation-for-relationship.
6) Block 2 Part 6 – Realising the data model
Offline interactive quiz (60 questions). Normalisation (1NF–3NF), SQL DDL, constraints, dialect limits, flexing, external schema.
7) Block 2 Part 7 – Data manipulation using SQL
Offline interactive quiz (60 questions). INSERT/SELECT/WHERE, set operators, NULL logic, logical processing model, optimiser, UPDATE/DELETE, CHECK constraints, transactions.
8) Block 2 Part 8 – Further data manipulation using SQL
Offline interactive quiz (60 questions). Aggregation, GROUP BY/HAVING, JOIN types, ORDER BY/LIMIT/OFFSET, VIEWs, COALESCE and common gotchas.
9) Block 2 Part 9 – Managing data access
Offline interactive quiz (60 questions). Data sharing & external schema, roles/GRANT/REVOKE, views for controlled access, concurrency/locking/deadlock, data quality, backups & logs, ACID/CAP/BASE and alternatives.
10) Block 2 Part 10 – Standards and legal and ethical conduct
Offline interactive quiz (60 questions). Standards vs frameworks, ISO/IEC 20000 & ITIL, PRINCE2 basics, regulatory frameworks (e.g., PCI DSS), privacy/surveillance ethics, consent/rights, digital divide, open data.
11) Block 2 – Conclusion
Offline recap quiz (60 questions). Waterfall stages (requirements→analysis→design→implementation), modelling + SQL essentials, shared-data challenges (meaning/access/concurrency), trade-offs, and lead-in to Block 3 project management.
11) Block 2 – Master Quiz
Master Quiz.
Specimen Quiz
Master Quiz.
File naming
Rename your quiz files to exactly: 1.html, 2.html, 3.html, 4.html, 6.html.