Lochside Academy Computing

Database Design Practical Tasks

Topic 1 - Database Creation

From Design to Database

Validation Rules

Populating a Database

Topic 2 - SQL Queries

You will need to download the fully populated database below before attempting these tasks:

SELECT and FROM

Exact Match Queries

Partial Match Queries

Other Comparison Operators

Complex Queries

Queries Using Two Tables

Adding Records to a Database

Deleting Records from a Database

Editing Records in a Database

S1 Computing Science | S2 Computing Science | S3 Computing Science | N5 Computing Science | Higher Computing Science | NPA Digital Media & Animation | Further Reading | Parents

Report abuse