AQA GCSE Databases and SQL

What is a Primary Key?

• A unique field within a table that ensures all records are unique

• A field that appears in multiple tables in order to join them together

• A unique field that is used to link together all the records in a table

• A common field that all tables include

​ (a)   firstName, lastName, age ​ (b)   Students

​ (c)   yearGroup = "11"

• SELECT
• FIND
• RETURN
• LOCATE
• FROM
• WHERE
• WHILE
• WHICH

Select the correct command to join two tables togehter

• WHERE Student.ID = Exam.ID

• WHERE Student.ID != Exam.ID

• WHERE Student = Exam

• WHERE Student.ID IS Exam.ID

SQL Stands for

• Structured Query Language

• Static Query Language

• Structured Question Language

• Sample Query Language

• Structure Question Language

Label The Primary and Foreign Keys

a

b

Foreign Key

Primary Key

What does the Orange represent on the following image?

• A Field

• A Record

What does the Blue represent on the following image?

• A Field

• A Record

Click on all the fields that would be returned by the following statement:

SELECT FirstName, LastName, DatePresented FROM Member, Award

The field that joins two tables together is the (a)   key

State two benefits of using relational databases

• Reduces data redundancy

• Less information to read

• Reduces data inconsistency

• Faster at retrieving information

• Can store more information