Computer Science

Structured Query Language: declarative language designed for managing data held in a relational database management system

an SQL INSERT statement allows you to add data into pre-existing tables

an SQL UPDATE statement allows you to modify records

SQL fundamentals

This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.

Databases and SQL

Which SQL statement is used to add new data to a table?

What is the main purpose of the SQL UPDATE statement?

Why should you be careful when deleting data using SQL?

Match the example to the SQL statement used:

You might break relationships with other tables

What might happen if you delete a record without checking for links?

Which of the following best describes an entity in a database context?

Which role is responsible for maintaining databases using a DBMS?

Drawing entity-relationship diagrams automatically

Which of these is NOT a function of a DBMS?

Arrange these from most general to most specific:

A collection of related data stored together, made up of tables

A set of data arranged in rows and columns within a database

A request to search for or retrieve specific information from data

A single category of data within a table, such as “Name”

Match each database term to its correct description:

Starter Quiz