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