These adaptable PowerPoint Presentations (23 Slides) cover all aspects of the specification in relation to AQA GCSE Computer Science 8525 (from 2020) component 3.7.
It includes:
Teaching PowerPoint Presentations (includes checkpoint questions and answers) - 23 slides
Student PowerPoint Presentations (Includes checkpoint questions, but omits the answers)
Content Covered:
Explain the concept of a database.
Explain the concept of a relational database.
Understand the following database concepts:
• table
• record
• field
• primary key
• foreign key.
Understand that the use of a relational database facilitates the elimination of data inconsistency and data redundancy.
Be able to use SQL to retrieve data from a relational database, using the commands:
• SELECT
• FROM
• WHERE
• ORDER BY…ASC | DESC
Be able to use SQL to insert data into a relational database using the commands.
INSERT INTO table_name (column1, column 2 …)
VALUES (value1, value2 …)
Be able to use SQL to edit and delete data in a database using the commands.
UPDATE table name
SET column1 = value1, column2 = value2 …
WHERE condition
DELETE FROM table_name WHERE condition
Get this resource as part of a bundle and save up to 30%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£1.00