Executive Examination Overview

The 2023 CCEA A2 Unit 1 paper assesses core concepts across systems development lifecycles, diagrammatic modelling, project scheduling, relational normalisation, and database implementation via SQL. Set against the business context of Thompson’s Nursery, the exam demands both sharp analytical knowledge and technical fluency under timed conditions.

Where the Marks Lie

High-yield areas in this paper are heavily concentrated in three domains:

  • Structured Query Language (22 marks): Demands high syntactic precision across table definitions (DDL with identity, check, and default constraints) and complex queries (DQL featuring left outer joins, date arithmetic functions, calculations, and aggregation with GROUP BY).
  • Project Management & PERT Networks (15 marks): Testing forward/backward pass calculations, critical path identification, milestone recognition, and Gantt evaluation.
  • UML Modelling & Systems Approaches (23 marks): Spanning Agile vs Traditional paradigm cloze questions, class diagrams, multiplicity, and extended 8-mark comparative discussions on Use Case and Sequence diagrams.
  • Normalisation (11 marks): Standard conversion from unnormalised form through 1NF, 2NF, and 3NF with nested repeating groups.

Key Pitfalls and Marking Vulnerabilities

Candidates lose significant marks on:

  • SQL Outer Joins & Date Manipulation: Failing to identify when an outer join is necessary to capture non-matching records, or miscalculating date boundaries using DATEDIFF() or DATEADD().
  • Pert Chart Arithmetic: Transposition errors during backwards passes, particularly where multiple dependencies converge on a single node.
  • Generic Extended Responses: Providing textbook definitions for prototyping or UML without contextualising them to the scenario-specific business problems faced by Thompson’s Nursery.
  • Normalisation Dependency Identification: Missing foreign key notation across intermediate junction tables in 2NF and 3NF.

Strategic Revision Takeaways

To maximise marks in future series, students should prioritise mastering SQL scripting syntax under examination conditions and drill multi-pass PERT calculation diagrams. In written extended responses (assessed for Quality of Written Communication), ensure every theoretical principle is explicitly anchored to the pre-release case study.