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

Evaluating a solution and suggesting enhancements

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

Specification 19.4 asks you to evaluate a completed database solution's fitness for purpose and suggest suitable enhancements. The skill is judgement: weigh strengths and weaknesses against the requirements and recommend specific, justified improvements.

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

Practise this lesson

Evaluating fitness for purpose

Go back to the requirements and the users:

Suggesting enhancements

A good enhancement is specific, feasible and justified by a need or a weakness:

Avoid vague ideas ('make it better', 'add more features') and enhancements that the scenario gives no reason for.

Structuring the answer

A clear pattern for each point: criterion, evidence, effect, improvement. Then a final judgement. For example: 'Validation on DailyRate (criterion) rejected 75 and 60.01 in testing (evidence), so impossible prices cannot be stored (effect). However, Model has no presence check, so a bike could be saved without a name; adding Is Not Null with a clear message would fix this (improvement).'

Worked example

Evaluate the Harbour Bike Hire solution briefly and suggest two enhancements.

  1. Strengths: normalised tables with referential integrity, so no orphan hires; validation on rate, type and ID; a menu with clear labels.
  2. Weakness: there is no record of when bikes are returned, so overdue bikes cannot be found.
  3. Enhancement 1: add ReturnDate to tblHire and a query of hires where ReturnDate is empty and HireDate + Days is before today.
  4. Enhancement 2: add a dashboard figure showing bikes currently out, so staff see availability at a glance.
  5. Judgement: fit for recording bookings, but needs return tracking to manage the fleet.

Answer: Evidence-based strengths and weaknesses, two justified enhancements, a judgement.

Key idea: Evaluate each requirement and user need with evidence, then judge overall fitness for purpose. Enhancements must be specific, feasible and justified. Pattern: criterion, evidence, effect, improvement, then a judgement.

Check yourself

  1. Which is the best suggested enhancement?
    • Make the database better
    • Add a parameter to the sales report so the manager can choose the month without editing the query
    • Add more features
    • Use nicer colours everywhere
    Show answer

    Add a parameter to the sales report so the manager can choose the month without editing the query. It is specific, feasible and justified by a need.

  2. What should an evaluation end with?
    • A list of the tables
    • A copy of the test plan
    • The SQL code
    • An overall judgement of fitness for purpose
    Show answer

    An overall judgement of fitness for purpose. Evaluation means reaching a reasoned judgement.

  3. Which is the strongest evidence that validation is effective?
    • The rules look sensible
    • Test results showing invalid values were rejected and valid values accepted
    • The developer says it works
    • The form has a title
    Show answer

    Test results showing invalid values were rejected and valid values accepted. Test results are objective evidence.

  4. A scenario says nothing about the business selling online. Which enhancement is least appropriate?
    • Adding a parameter query for monthly hires
    • Adding a presence check on Model
    • Building a full online shop into the database
    • Adding a chart of hires per month to the dashboard
    Show answer

    Building a full online shop into the database. Enhancements should be justified by the scenario's needs.

  5. A requirement asks for a printable list of overdue hires, but the database stores no return dates. How should the evaluation describe this?
    • The requirement is not met, because the data needed is not stored; add a ReturnDate field and a query
    • The requirement is met because there is a report
    • It does not matter
    • The data types are wrong
    Show answer

    The requirement is not met, because the data needed is not stored; add a ReturnDate field and a query. Missing data means the requirement cannot be met; the improvement follows.

  6. Suggest one enhancement to a school's student database and justify it.
    Show answer

    Add a parent email field and a query of absent students, so the office can contact parents quickly on the same day.. Name a specific change and justify it with a benefit to a user.

Practise with instant feedback

Sources

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