Databases II – GCSE Computing

Lesson Aim

  • Know the role of the DBMS
  • Understand the need for relational databases
  • Know what a primary key and foreign key are

Starter

DBMS Presentation

Relational Databases

Main

Take 15 minutes to read the notes below:

DBMS Notes

Relational Databases

Now complete the questions sheet below:

 Databases Task 

Plenary

Click on the link below and add three things you learnt this lesson

Exit Ticket

GCSE Computing – Databases Practice

Lesson Aim

  • Create filters in a MS Access Database
  • Create Queries in a MS Access Database

Starter

Introduce the task and demonstrate how to create filters and queries in MS Access

Main Task

Download the task sheet and database below and create filters and queries to carry out the tasks on the worksheet

Top track times

Top track times worksheet

Plenary

Click link below and create a tweet of what you have learnt in todays lesson

Lesson review link