All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
Why use database software? Features and context
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
Unit 4 opens with the big question: why hold data in database software at all, and which of its features does a given organisation actually need? Every practical task in the exam is set in a context, so you must be able to match features to that context and justify the choice (specification 17.1).
What database software does
Database software (a database management system) holds data in tables and lets you manipulate it. Its key features:
- Structure: data split into related tables, so each fact is stored once.
- Data types and validation: each field holds one kind of data, and rules reject impossible values.
- Queries: find, filter, sort, calculate and summarise data in seconds, even across many tables.
- Forms: friendly screens for entering and editing data.
- Reports and charts: formatted output for printing or sharing.
- Automation: macros and buttons that run routine tasks.
- Import and export: move data in and out as spreadsheets, CSV or text files, PDF and HTML.
- Multi-user access and security: several people can use the data at once, with permissions and backups.
Database, spreadsheet or flat file?
| Need | Spreadsheet or flat file | Relational database |
|---|---|---|
| Large volumes of records | Slows down and becomes hard to manage | Designed for it |
| Avoiding repeated data | Same details typed on many rows | Each fact stored once, linked by keys |
| Keeping data accurate | Limited validation, easy to overwrite cells | Data types, validation rules and referential integrity |
| Complex questions | Filters on one sheet | Queries that join several tables |
| Several users at once | Risk of conflicting copies | Shared, controlled access |
| Quick what-if modelling and charts of numbers | Ideal | Possible but less natural |
A spreadsheet is good for modelling numbers; a database is better for storing and retrieving structured records.
Context decides the features
The context (who the organisation is, what it does and what it needs) decides which features matter:
- A bike hire shop with one counter assistant needs a quick data entry form, validation on prices and dates, and a daily report of bikes out.
- A school office with many staff needs multi-user access, permissions (only some staff see medical notes) and reports for parents.
- A charity sending newsletters needs queries to select supporters and export to a mail merge or a CSV file for an email service.
In the exam, always tie a feature to a stated need in the scenario: not 'it has forms', but 'a form with a drop-down list lets the assistant pick the bike type without typing errors'.
Evaluating whether a feature is appropriate
To evaluate a feature for a scenario, ask:
- Does it meet a requirement that the scenario actually states?
- Who uses it and do they have the skills? A novice needs a form and buttons, not the raw tables.
- How often is it used? Automate frequent tasks with macros; rare tasks may not be worth automating.
- Does it improve accuracy, speed or security? Say which, and how.
- What are the drawbacks? Set-up time, training, cost, or a feature that adds complexity nobody needs.
A good evaluation weighs benefits against drawbacks and reaches a judgement.
Worked example
A café owner keeps a spreadsheet of loyalty-card customers and the dates they visit. Each visit is a new row with the customer's name, phone number and email typed again. Recommend three database features and justify each.
- Related tables: a Customer table and a Visit table linked by CustomerID, so contact details are stored once and an update happens in one place.
- A data entry form with a drop-down to pick the customer and a default of today's date, so staff record a visit in seconds without retyping details.
- A query that counts visits per customer this month, feeding a report of customers who have earned a free drink.
Answer: Three features, each linked to a problem in the scenario: duplication, slow entry, and finding rewards.
Check yourself
- A business types each customer's address on every order row of a spreadsheet. Which database feature most directly solves the resulting problems?
- Adding a chart of orders per month
- Storing customers in a separate table linked to orders by a key
- Exporting the spreadsheet as a PDF
- Making the column headings bold
Show answer
Storing customers in a separate table linked to orders by a key. Related tables store each customer's details once, so there is no repetition and no inconsistent copies.
- A shop's part-time staff have little IT experience. Which feature best suits them for adding sales?
- Typing directly into the table in datasheet view
- Writing SQL INSERT statements
- Editing the table design
- A data entry form with clear labels, drop-down lists and a save button
Show answer
A data entry form with clear labels, drop-down lists and a save button. A form hides the table structure and guides novice users, reducing errors.
- For which task is a spreadsheet more suitable than a relational database?
- Storing ten years of customer orders linked to products
- Modelling how profit changes if prices rise by different percentages
- Letting twenty staff update stock records at the same time
- Enforcing that every order belongs to an existing customer
Show answer
Modelling how profit changes if prices rise by different percentages. What-if modelling of numbers is a spreadsheet strength; the others need a relational database.
- A charity wants to email supporters who donated over 50 pounds last year using an online mailing service. Which pair of features is most relevant?
- A form with radio buttons, then a pie chart
- A macro that closes the database, then a report header
- A query with criteria on donation and date, then export of the results to CSV
- An input mask on postcodes, then a dashboard
Show answer
A query with criteria on donation and date, then export of the results to CSV. The query selects the right supporters; CSV export moves them into the mailing service.
- A gym asks why it should replace its paper membership records with database software. Give one benefit and explain it.
Show answer
Searching is much faster, because a query can find all members whose membership expires this month in seconds.. Name a benefit (speed of searching, accuracy through validation, less duplication, security, reports, sharing) and then explain how it helps the gym.
- Which statement is the strongest evaluation of adding macros to a small database used once a month by one expert user?
- Macros are always essential in every database
- Macros make every database faster
- Macros would add set-up time and offer little benefit, because the task is rare and the user is skilled enough to run it manually
- Macros should be added because they look professional
Show answer
Macros would add set-up time and offer little benefit, because the task is rare and the user is skilled enough to run it manually. Evaluation weighs benefit against cost in the given context, and reaches a judgement.
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.