All subjects · Information Technology · WIT14 3 hour practical exam on database solutions

Answering the 9-mark analysis questions

Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions

Two questions on recent papers (June 2024 Q2c and Q5) were 9-mark written analyses typed into the template: what information is needed, what the database already holds, what is missing, and how to change it. They are levels marked, so structure and development matter.

Practise this in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise this lesson

The levels

LevelMarksPearson descriptor (summary)
00No awardable content
11 to 3Analysis is flawed or superficial; the solution is generally ineffective
24 to 6Analysis is sound, with minor inaccuracies or omissions; the solution is workable but may have minor issues
37 to 9Analysis is sound and developed, ideas linked in a fluent and logical way; the solution is appropriate and workable

From the June 2024 WIT14 mark scheme.

A structure that reaches Level 3

1. Requirement: restate what the new output or task needs (fields, calculations, filters).

2. What exists: name the tables and fields already in the database that can be used.

3. What is missing: entities with no table, fields not stored, values not captured.

4. Recommendation: new tables with primary keys, new fields with data types, foreign keys and the relationships (1:M), link tables for M:M, and referential integrity.

5. How the output is produced: the query (joins, criteria such as dates in 2024, grouping and counts) and the report or form; calculated values worked out in queries, not stored.

Link each step to the next ('because ... so ...'). Pearson's indicative content for 2024 Q2c included needing contact details (missing email), a query grouped by customer with a 2024 date criterion and a count above five, and a report or list for sending.

Common ways to lose marks

Worked example

Harbour Bike Hire wants to send a thank-you voucher to customers who made three or more hires in 2026. Analyse what is needed. (Outline answer.)

  1. Requirement: customer names and a way to contact them, with a count of hires in 2026.
  2. Exists: tblCustomer (names, Email for most customers), tblHire (CustomerID, HireDate), linked 1:M.
  3. Missing: email is empty for some customers (2 here) and there is no postal address, so add Address fields (Text) to tblCustomer, not a new table.
  4. Query: join tblCustomer to tblHire, criterion HireDate in 2026, group by CustomerID, HAVING COUNT(HireID) >= 3. In this data it returns 1 customer.
  5. Output: a report or mail merge of names and contact details; no voucher table is needed unless voucher use must be tracked.

Answer: Requirement, exists, missing, recommendation, output: linked logically.

Key idea: Levels: 1 to 3 superficial, 4 to 6 sound, 7 to 9 sound, developed and logically linked with a workable solution. Structure: requirement, what exists, what is missing, recommended tables, keys and relationships, then the query and output. Analyse the structure, avoid duplication, calculate rather than store.

Check yourself

  1. A 9-mark answer is judged sound with minor omissions and a workable solution. What is the highest mark in that level?
    Show answer

    6. Level 2 covers 4 to 6 marks.

  2. What most distinguishes a Level 3 answer from Level 2?
    • Analysis is developed and ideas are linked logically, with an appropriate workable solution
    • It is longer
    • It uses bullet points
    • It mentions more software
    Show answer

    Analysis is developed and ideas are linked logically, with an appropriate workable solution. Development and logical linking move an answer to Level 3.

  3. A question asks how the database structure must change to produce a new form. Which answer focuses correctly?
    • Criticises the handwriting on the form
    • Describes the colours of the current menu
    • Explains the missing tables and fields, with keys and relationships needed to store and generate the data
    • Lists the advantages of databases in general
    Show answer

    Explains the missing tables and fields, with keys and relationships needed to store and generate the data. The 2024 examiner report notes candidates evaluating the form instead of the structure.

  4. Customers' emails are already stored in tblCustomer. Which recommendation would weaken an answer?
    • Use a query to select customers and their emails
    • Create tblInvite holding each customer's name and email again
    • Add a postal address field to tblCustomer for customers without email
    • Count each customer's purchases with a grouped query
    Show answer

    Create tblInvite holding each customer's name and email again. Duplicating stored data is a flaw that examiners noted.

  5. A new attendance table must record which member attended which class. Which design is correct?
    • Add AttendanceID to tblMember only
    • Add MemberID to tblClass
    • Store attendance as a list in tblClass
    • tblAttendance with MemberID and ClassID as foreign keys (plus the date), linked 1:M to tblMember and to tblClass
    Show answer

    tblAttendance with MemberID and ClassID as foreign keys (plus the date), linked 1:M to tblMember and to tblClass. The 2025 examiner report notes mid-level answers that did not link the new attendance table to the class table, or linked it wrongly; higher-level answers used the class key and MemberID in the attendance table.

  6. Using the Harbour Bike Hire data, how many customers made three or more hires in 2026?
    Show answer

    1. Only Amira (3 hires) qualifies.

  7. List, in order, the stages of a well structured answer to a 9-mark question on extending a database.
    Show answer

    State the requirement, identify what already exists, identify what is missing, recommend the new tables, fields, keys and relationships, then explain the query and output.. Requirement, exists, missing, recommendation (tables, keys, relationships), output.

Practise with instant feedback

Sources

Last updated 8 November 2026. Spotted a mistake? Tell us.