Unit 6 Databases

Lesson 1 Tables, records and fields

Learning Objectives:

• To discuss some of the many computer systems which may hold data about you or your family on a database
• To learn how this data is held so that information can be quickly retrieved
• To learn some database terms: record, field, table, primary key, index
• To set up a simple table in Access and enter some records

Databases L1 Tables, records and fields

Databases Worksheet 1

Databases Homework 1

Database solutions (Wildern log in required)



Lesson 2 Entities and relationships

Learning Objectives:

• Understand the relationship between entities and tables
• Understand the basic concepts of a relational database
• Learn the three possible relationships that can exist between entities
• Understand the use of key fields to connect tables and avoid data redundancy

Databases L2 Entities and relationships

Databases Worksheet 2

Databases Homework 2




Lesson 3 Queries

Learning Objectives:

• Learn how to query a database
• Understand the use of logical operators in framing database queries
• Learn how to combine data from two linked tables by means of a quer

Databases Lesson 3 Queries

Databases Worksheet 3

Databases Homework 3




Lesson 4 Introduction to SQL

Learning Objectives:

• Create simple SQL statements to extract, add and edit data stored in a database

Databases L4 Using SQL

Databases Worksheet 4 Introduction to SQL

Databases Homework 4 Introduction to SQL




Lesson 5 Forms and reports

Learning Objectives:

• Understand the advantages of a database as a data store
• Understand why an input form is useful for entering data
• Create an input form to enter details about pupils
• Create a report based on a query

Databases Lesson 5

Databases Worksheet 5


Lesson 6 Assessment

Learning Objectives:

• Sit the end-of-unit test

Databases Assessment Test