A database is an organised, persistent collection of data. The data is stored so that it can be searched, sorted and updated easily.

What is a relational database?

A relational database stores data in several separate tables that are linked together. The links are made through fields the tables share.

What is a table in a database?

A table holds the data about one kind of thing, such as students or books. A table is made up of rows and columns.

What is a record in a database table?

A record is one row of a table. A record holds all the data about a single item, such as one student.

What is a field in a database table?

A field is one column of a table. A field holds one piece of data about every record, such as each student's surname.

What is a data type in a database?

A data type sets what kind of value a field can hold. Common data types are integer, real, text, Boolean and date/time.

AQA GCSE Computer Science 8525

Algorithms

Topic overview Algorithms, decomposition and abstraction Pseudo-code, flowcharts and trace tables Efficiency of algorithms Linear search and binary search Bubble sort and merge sort

Programming

Topic overview Data types Variables, constants and assignment Sequence, selection and iteration Arithmetic, relational and Boolean operators Arrays and records Input, output, string handling and random numbers Subroutines and structured programming Validation, authentication and testing

Data Representation

Topic overview Number bases and why hexadecimal is used Converting between binary, decimal and hexadecimal Units of information: bits, bytes and prefixes Binary addition and binary shifts Character encoding: ASCII and Unicode Pixels, bitmaps and colour depth Bitmap image file size calculations Digital sound: sampling rate and sample resolution Data compression: Huffman coding and run-length encoding

Computer Systems

Topic overview Hardware, software and the operating system Logic gates, truth tables and Boolean expressions Programming languages and translators The CPU and the fetch-execute cycle Types of memory and embedded systems Secondary storage and cloud storage

Computer Networks

Topic overview Network types and topologies Wired and wireless networks Network protocols The TCP/IP model and its layers Network security methods

Cyber Security

Topic overview Cyber security, common threats and penetration testing Social engineering: blagging, phishing and shouldering Malware: viruses, trojans and spyware Methods to detect and prevent cyber security threats

Relational Databases and SQL

Topic overview Relational databases and keys SQL SELECT queries SQL INSERT, UPDATE and DELETE

Ethical, Legal and Environmental Impacts of Digital Technology

Topic overview Ethical issues in digital technology Legal issues, privacy and surveillance Environmental impacts of digital technology

Relational Databases and SQL

Relational databases and keys

3 things to know
Paper 2

Overview

Databases, tables, records, fields and data types, primary and foreign keys, linked tables, and how a relational design removes data redundancy and inconsistency.

What you need to know

Answer each one before you reveal it.

Your recallNot started

Key term

What is a database, and what makes one relational?

Key term

How is a database table organised into rows?

Key term

What is a database?

Questions from this subtopic

Each one with the model answer underneath.

1
What is a database?
Model answer
A database is an organised, persistent collection of data. The data is stored so that it can be searched, sorted and updated easily.
2
What is a relational database?
Model answer
A relational database stores data in several separate tables that are linked together. The links are made through fields the tables share.
3
What is a table in a database?
Model answer
A table holds the data about one kind of thing, such as students or books. A table is made up of rows and columns.
4
What is a record in a database table?
Model answer
A record is one row of a table. A record holds all the data about a single item, such as one student.
5
What is a field in a database table?
Model answer
A field is one column of a table. A field holds one piece of data about every record, such as each student's surname.
6
What is a data type in a database?
Model answer
A data type sets what kind of value a field can hold. Common data types are integer, real, text, Boolean and date/time.

See the rest and revise

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book

2Open book

3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

Algorithms

Programming

Data Representation

Computer Systems

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

The table one extra row.

gainslosescopies

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

AThe algorithm outputs 1.

BThe variable x falls from 5 to 3 to 1.

CThe loop stops because 1 is not greater than 1.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

ASC means sorting from smallest to largest, or A to Z.

TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in Relational Databases and SQL, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a month See how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.