GCSE
Lesson 1 Database essentials
Database essentials gives your learners the key terminology required to be able to use SQL to search and update a relational database. It steps learners through the key concepts using a music database as an example. First as a flat file database and then as a relational database. Learners are then given their first experience with a Database Management System (DBMS) where they learn to navigate and investigate some of the tools that they offer.
Learning objectives
- Describe a database
- Define database key terms (table, record, field, primary key, foreign key)
- Describe a flat file database
- Describe a relational database
Package contents
- Lesson plans
- Learning graphs
- Unit overviews
- Activities
Not registered yet?
Create an account and get access to over 500 hours of free teaching resources.
GCSE revision
A comprehensive range of content and helpful practice questions are also available for this topic.