B5 Computing · Term 2 Week 4: Introduction to Databases, Algorithm and Programming.

Lesson notes

Learning Objectives

Indicator: B5.5.1.3.5 - Explain fundamental database concepts.

By the end of the lesson, learners can:

Define the key database terms: table, field, record, data type, and primary key, in their own words.
Identify the different data types (text, number, date, yes/no) and match them to appropriate fields in a table.
Explain what data selection and manipulation mean in a database and give one example of each.
Describe why databases need security measures like passwords and user permissions, and give at least one example of a security risk.
Explain why backing up a database is important and describe when and how a backup should be restored.

Sign in with your phone number to read the full note and download the GES plan - free.

Sign in with phone number

Curriculum details

Strand: Programming and Databases (Strand 5)
Sub-strand: Introduction to Databases, Algorithm and Programming. (5.1)
Content standard: B5.5.1.3 - Demonstrate how to use Databases
Indicator: B5.5.1.3.5 - Explain fundamental database concepts.
Suggested placement: Term 2, Week 4 (Week 16 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Curriculum reference: Computing Curriculum (Basic 4-6), 2019, p. 19
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

Guide learners to explore the fundamental database concepts e.g. tables and data types, data selection and manipulation, security, and backup and restore.