What database skills does SQA Higher Administration and IT require?

Higher requires you to work with a relational database of more than one linked table. You must understand its structure (tables, fields, records, data types, primary and foreign keys), create relationships between tables, search using advanced functions (queries with multiple criteria, AND/OR logic, comparison and wildcard operators, single and multi-level sorting), use calculations (calculated fields and summary totals), create and use forms for data entry, create reports including grouped reports with totals, print results in a range of formats, and export data to spreadsheet, word-processing and presentation applications.

What is the difference between a primary key and a foreign key?

A primary key is a field that uniquely identifies each record in its own table, for example a customer ID; no two records can share it, which prevents duplicates and lets each record be found exactly. A foreign key is a field in one table that holds the primary key value of another table, for example a customer ID stored in an orders table. The foreign key creates the relationship between the two tables, so related data (a customer and their orders) can be joined.

What is the difference between AND and OR in a database search?

AND requires all conditions to be true, so it narrows the search and fewer records match, for example Region = North AND Sales > 10000. OR requires any one condition to be true, so it widens the search and more records match, for example Region = North OR Region = South. Choosing the wrong one is a common error: using AND when you mean OR can return no records at all.

What is the difference between a form and a report in a database?

A form is a user-friendly screen for entering, editing and viewing data, usually one record at a time, and can include drop-down lists, required fields, default values and validation to make entry easier and more accurate. A report presents data, or a query's results, in a formatted, printable layout; a grouped report arranges records into groups by a chosen field and shows subtotals per group and a grand total. In short, forms are for input and reports are for output.

Why use a relational database instead of a single flat-file table?

A relational database splits data into linked tables, so each fact is stored only once rather than repeated. This means less data duplication, fewer inconsistencies, and easier, more accurate updating, because a change is made in one place and is correct everywhere it is used. It is also better organised and easier to extend. A flat file repeats data (a customer's details on every order), which wastes space and risks contradictory copies.

ScotlandAdministration & IT

SQA Higher Administration and IT Databases: a complete overview of relational structure and relationships, advanced searching and calculations, and forms, reports and output

A deep-dive SQA Higher Administration and IT guide to relational databases. Covers the relational structure (tables, fields, records, primary and foreign keys, relationships), advanced searching (queries, AND/OR, operators, wildcards, sorting) and calculations, and forms, reports and exporting, with worked examples.

Generated by Claude Opus 4.814 min readHigherUpdated 2026-06-16

Reviewed by: AI editorial process; not yet individually human-reviewed

Jump to a section

What databases actually demand at Higher
Relational structure and relationships
Advanced searching and calculations
Forms, reports and output
How databases are examined
Check your knowledge

What databases actually demand at Higher

Databases are one of the IT applications you must use confidently in Higher Administration and IT, and at Higher the database is relational, more than one linked table. The SQA expects you to understand the structure and relationships, search with advanced functions, calculate within queries and reports, and use forms, reports and exporting to enter and present data. As with spreadsheets, you meet this both in the assignment (building a working database) and the question paper (explaining keys, AND vs OR, or what a calculated field or grouped report is).

This guide walks through the whole area, then sets out how it is examined. Each topic has a matching dot-point page with practice questions; this overview ties them together.

Relational structure and relationships

A relational database stores data in tables (one per entity), made of fields (columns) and records (rows), each field with a data type. A primary key uniquely identifies each record; a foreign key stores another table's primary key to create a relationship, usually one-to-many (one customer, many orders). Linking tables this way removes the duplication of a flat file, so each fact is stored once, data stays consistent, and updates are made in one place. This structure is the foundation for everything else.

Advanced searching and calculations

Data is found with queries. Advanced searching combines criteria with AND (narrows) and OR (widens), uses comparison operators and Between for ranges, wildcards for partial text, and sorting (including multi-level). Queries and reports can also calculate: a calculated field derives a value from other fields (a line total) and recalculates automatically, while summary totals group records and aggregate them (total sales per region). Because the tables are related, a single query can search and calculate across several at once.

Forms, reports and output

Finally, the database must let users enter and present data. A form gives a clear, controlled screen for data entry (drop-downs, required fields, validation), reducing errors. A report presents data for printing; a grouped report organises records by category with subtotals and a total. Results can be printed in a range of formats and exported to a spreadsheet (for charts and calculation), a word processor (for a mail merge or report) and a presentation, reusing data without re-keying.

How databases are examined

A typical SQA profile:

Define and explain. Field vs record; primary vs foreign key; what a relationship is.
Explain logic. AND vs OR; comparison operators and wildcards; sorting.
Describe a feature. A calculated field, a summary total, a form's advantages, a grouped report.
Apply it. The assignment requires building the tables, relationships, queries, forms and reports.

SQA Higher Administration and IT databases requires working with a relational database of linked tables. Structure: tables (entities), fields (columns), records (rows) and data types; a primary key uniquely identifies each record; a foreign key holds another table's primary key to create a relationship (usually one-to-many). A relational database beats a flat file by reducing duplication, avoiding inconsistency and making updates easier. Searching: queries with multiple criteria combined by AND (narrows) and OR (widens), comparison operators, Between, wildcards for partial text, and single or multi-level sorting. Calculations: calculated fields (a value worked out from other fields, recalculating automatically) and summary totals (grouped aggregates such as total per region). Output: forms for easier, controlled data entry; reports, including grouped reports with subtotals and totals; printing in a range of formats; and exporting to spreadsheet, word-processing and presentation applications. It is examined by defining terms, explaining query logic and building the database in the assignment.

Check your knowledge

A mix of recall and explanation questions covering databases. Attempt them, then check against the solutions.

Define "field" and "record". (2 marks)
What is the purpose of a primary key? (2 marks)
What does a foreign key do? (2 marks)
Explain the difference between AND and OR in a search. (2 marks)
What is a calculated field? (2 marks)
State one advantage of using a form to enter data. (1 mark)

Solutions

Q1: A field is a single column, one piece of data (for example Surname); a record is one row, all the fields for one item (for example one customer).
Q2: A primary key uniquely identifies each record in a table (for example a customer ID); no two records can share it, so it prevents duplicates and lets a record be found exactly.
Q3: A foreign key is a field in one table that holds the primary key value of another table (for example CustomerID in an Orders table), creating the relationship between the two so related data can be joined.
Q4: AND requires all conditions to be true, so it narrows results (fewer match); OR requires any condition, so it widens results (more match).
Q5: A field in a query or report whose value is worked out from other fields by a formula (for example Total: [Quantity]*[Price]), recalculating automatically rather than being stored.
Q6: Any one: easier and more accurate entry (one record at a time, clear layout); controlled input (drop-downs, required fields, validation); shows only needed fields; protects the data.

Sources & how we know this

Higher Administration and IT Course Specification — SQA (2024)