CCEA A-Level · Analysis & Prediction

2025 CCEA A-Level Software Systems Development CL4 Past Paper: Analysis & Answers

The 2025 CCEA A2 1 Systems Approaches and Database Concepts paper offers a comprehensive, balanced assessment anchored in 'The Stables' pre-release case study. It divides cleanly into two halves: theoretical and methodology-driven questions (Q1–Q6 covering methodologies, project management, V-Model testing, and conceptual modelling) and rigorous technical data management (Q7–Q9 spanning 3NF normalisation, detailed ER diagram completion, and complex multi-table SQL querying).

Updated: 31 Aug 2026

Analysis Sample paper

Difficulty 3.4/5

Total marks

100

Duration

120 mins

Most tested

Systems Methodologies & Database Engineering (SQL / ER Models)

Paper breakdown

Unit A2 1: Systems Approaches and Database Concepts: 100 marks · 120 mins

Top chapters

Systems Methodologies · 25 marksStructured Query Language (SQL) · 18 marksEntity Relationship (ER) Models · 17 marksNormalisation · 10 marksTesting · 10 marks

Overall Verdict & Exam Architecture

The 2025 Unit A2 1 examination is a well-structured paper set out over 9 compulsory questions totalling 100 marks across 2 hours. Candidates who thoroughly digested the pre-release case study ('The Stables') are heavily rewarded, as all essay scenarios, data tables, and SQL scripts directly mirror the business requirements of Mark and Diane's equestrian business.

Where the Marks Lie: Theory vs. Technical Implementation

The paper splits evenly into conceptual software engineering (55 marks across Questions 1 to 6) and relational database design and implementation (45 marks across Questions 7 to 9):

Systems Methodologies & Management (Q1–Q4, 35 marks): Tests fact-finding techniques, user story syntax ('As a… I want… So that…'), agile and traditional development methodologies (Waterfall, DSDM, Scrum, RAD, XP), evolutionary prototyping, and project risk communication.
Testing & Systems Modelling (Q5–Q6, 20 marks): Examines design-phase testing (dry running, inspection), the V-Model testing hierarchy, use case visualisations, and the distinct characteristics of analysis-phase class diagrams.
Database Concepts, Normalisation & SQL (Q7–Q9, 45 marks): Features progressive normalisation up to 3NF (10 marks), a comprehensive 11-point ER diagram labelling task (17 marks), and rigorous SQL including single/multi-row INSERTs, date manipulation functions (DATEADD/DATEDIFF), multi-table inner joins, and aggregate grouping (18 marks).

Examiner Pitfalls & Common Traps

Generic QWC Essay Responses: Questions 3(b), 4(a), 5(a), and 6(a) assess Quality of Written Communication (6 marks each). Candidates frequently lose marks by giving textbook definitions without anchoring explanations directly to The Stables (e.g. failing to mention specific entities like horse care, booking sheets, or staff schedules).
Normalisation Notation Errors: In Question 7, losing primary key / foreign key asterisks (*) or failing to retain link tables during 2NF/3NF transitions forfeits structural marks.
SQL Date Manipulation and Aggregation: In Question 9(b), complex SQL scripts require joining five tables simultaneously and correctly computing hours (SUM(Duration)/60.0) alongside date offsets using DATEADD or DATEDIFF. Omitting non-aggregated attributes from the GROUP BY clause is a standard pitfall.

Revision Strategy & Exam Predictions

Ensure disciplined practice on 3NF tabular decomposition and 4- to 5-table SQL query writing under strict timed conditions. For future series, expect heavier scrutiny on data dictionary definitions, security/transaction processing (ACID properties), and comparative evaluation of alternative SDLC lifecycles (e.g. Spiral model vs. Agile variants).

Ready to test yourself?

Turn these notes into exam-style practice. Get unlimited AI questions on this topic with instant marking and explanations.

Practise This Topic

Charts

Marks by chapter

See where the marks were concentrated so revision time goes to the highest-value topics.

Question type mix

Compare the mark share of each paper section and question type.

Extended Response / QWC Essay24 marks · 4 questions
Short Answer & Definition18 marks · 6 questions
Diagram & Model Completion20 marks · 3 questions
Data Normalisation10 marks · 2 questions
SQL Coding & Completion18 marks · 3 questions
Matching & Objective (True/False)9 marks · 2 questions
Structured Template Completion1 marks · 1 questions

Mark accessibility

Estimate which marks were basic, mid-level, or high-difficulty.

76%within easy or medium reach

easy: 32 marksmedium: 44 markshard: 24 marks

Difficulty trend

Compare difficulty across recent years.

Command word frequency

Spot common command words so answers match the expected response style.

Skill weighting

Shows the skill mix this paper tested most heavily.

Study ROI

Bigger bubbles recur more often; higher bubbles carry more marks, helping you rank revision priorities.

Structured Query Language (SQL Scripting & Aggregates)

18 marks · Difficulty 3.8 · recurrence 100%

Entity Relationship (ER) Modelling & Cardinality

17 marks · Difficulty 2.8 · recurrence 100%

Normalisation (1NF to 3NF Transitions)

10 marks · Difficulty 3.5 · recurrence 100%

Systems Methodologies & Prototyping

25 marks · Difficulty 3 · recurrence 95%

Project Management & Risk Logs

10 marks · Difficulty 3 · recurrence 90%

V-Model & Design Stage Testing

10 marks · Difficulty 2.9 · recurrence 85%

Time vs marks

Compare marks with suggested time allocation to plan exam pacing.

marksmins

Next-year prediction

Topics worth watching next year, with the reason shown directly below each bar.

Agile vs Linear Comparative Evaluation90%

CCEA routinely rotates between in-depth prototyping essays and direct comparative evaluations of Spiral vs Agile frameworks.

Database Security, Roles & Integrity Constraints85%

The 2025 series focused purely on schema design and querying; explicit security permissions (GRANT/REVOKE), views, and referential integrity mechanisms are prime candidates for the next paper.

Data Dictionaries & Meta-Data Specification80%

Often paired with systems analysis questions, creating or validating a full data dictionary specification was absent this session.

Database Transaction Processing (ACID Properties)75%

Concurrency, commit/rollback, and atomicity are core A2 database theory topics that have not featured in recent long-response questions.

Cumulative marks ladder

The line is your running mark total question by question; dashed lines are the estimated grade cut-offs. See which question the line crosses your target grade at, so you know how far you must answer cleanly and which questions decide a band.

Topic-year heatmap

Compare topic weight by year to spot recurring and returning areas.

Jun 2023

Jun 2024

Jun 2025

Structured Query Language (SQL)

Systems Methodologies

Database Concepts

Managing Projects

Testing

Normalisation

Reasons for Systems Development

Entity Relationship (ER) Models

Examiner insights

AI-inferred

Common pitfalls

Writing purely generic theoretical answers for QWC 6-mark questions without explicitly linking points to the scenario and named characters (e.g. Mark, Diane, receptionist).
Failing to retain original composite primary keys and foreign key asterisks (*) when decomposing unnormalised and 1NF relations into 2NF and 3NF tables.
Omitting the necessary non-aggregate grouping attributes in the SQL GROUP BY clause when aggregating bookings and duration sums.
Incorrect date calculation syntax in SQL WHERE clauses (confusing DATEADD and DATEDIFF parameters).

Misconceptions

Believing that an analysis-phase class diagram requires full implementation specifics such as data types, method signatures, and access visibility modifiers.
Confusing user story formatting by combining multiple features into a single story instead of keeping it strictly focused on an individual requirement.
Assuming agile project management prioritises rigid linear tools like standard Gantt charts over dynamic backlog tracking.

Where marks are lost

Loss of Level 3 bands on 6-mark QWC questions due to limited specialist terminology and weak scenario integration.
SQL syntax mark deductions for incorrect JOIN structures across the 5 required relational entities.
Missing intermediate link/junction tables when establishing many-to-many relationships in the ER model completion task.

Estimated grade boundary

Updated: 31 Aug 2026

Source: CCEA

Grade	Mark	Percentage
A*	—	90%
A	—	80%
B	—	70%
C	—	60%
D	—	50%
E	—	40%

Official grade boundaries published by CCEA.

Know what the examiners want. Now go get those marks

thinka is an AI practice app used by 100,000+ students to drill questions and get instant feedback on every answer. You already know the high-frequency topics and where marks are lost. Now practise those specifically on thinka and turn this analysis into actual marks.

Start Practising Free See pricing

Know what's tested? Drill those topics on thinka. AI questions, instant marking.

Start Practising Free