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).

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

Practise this lesson

What database software does

Database software (a database management system) holds data in tables and lets you manipulate it. Its key features:

Database, spreadsheet or flat file?

NeedSpreadsheet or flat fileRelational database
Large volumes of recordsSlows down and becomes hard to manageDesigned for it
Avoiding repeated dataSame details typed on many rowsEach fact stored once, linked by keys
Keeping data accurateLimited validation, easy to overwrite cellsData types, validation rules and referential integrity
Complex questionsFilters on one sheetQueries that join several tables
Several users at onceRisk of conflicting copiesShared, controlled access
Quick what-if modelling and charts of numbersIdealPossible 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:

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:

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.

  1. 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.
  2. 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.
  3. 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.

Key idea: Database software stores structured data in related tables with data types, validation, queries, forms, reports, automation, import/export and multi-user security. Choose and justify features by linking each to a need stated in the context, weighing benefit against drawback.

Check yourself

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Practise with instant feedback

Sources

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