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.
Evaluating fitness for purpose
Go back to the requirements and the users:
- For each requirement: is it fully met, partly met or not met? What is the evidence (a test result, a screen, a report)?
- For each user group: does the solution suit their skills and tasks (ease of use, efficiency, help, stability, accuracy)?
- Structure: is data stored once, with the right types, keys and integrity?
- Reach an overall judgement: is it fit for purpose, and with what limitations?
Suggesting enhancements
A good enhancement is specific, feasible and justified by a need or a weakness:
- 'Add an Email field to tblCustomer and a query listing customers with hires in the last year, so the owner can send offers': specific and linked to a need.
- 'Add a parameter to the income report so the owner chooses the month, instead of editing the query each time.'
- 'Add a bike status (Available, Hired, Repair) with a list check, so staff can see which bikes are free.'
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.
- Strengths: normalised tables with referential integrity, so no orphan hires; validation on rate, type and ID; a menu with clear labels.
- Weakness: there is no record of when bikes are returned, so overdue bikes cannot be found.
- Enhancement 1: add ReturnDate to tblHire and a query of hires where ReturnDate is empty and HireDate + Days is before today.
- Enhancement 2: add a dashboard figure showing bikes currently out, so staff see availability at a glance.
- Judgement: fit for recording bookings, but needs return tracking to manage the fleet.
Answer: Evidence-based strengths and weaknesses, two justified enhancements, a judgement.
Check yourself
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (Issue 2, February 2021): Unit 4, Topics 17 to 19
- Pearson: IAL Information Technology scheme of work for Unit 4
Last updated 8 November 2026. Spotted a mistake? Tell us.