INTRODUCTION TO DATABASES… · B6 Computing

Lesson notes

Indicator: B6.5.1.1.7 - Illustrate basics of relational algebra.

By the end of the lesson, learners can:

Define relational algebra as a set of operations used to pull and combine information from database tables.
Identify and name the four basic relational algebra operations: select, project, union and join.
Perform a select operation to pick specific rows (records) that meet a given condition.
Perform a project operation to pick specific columns (fields) from a table.
Combine select and project operations to answer simple questions about data in a sample database.

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

Strand: Programming and Databases (Strand 5)
Sub-strand: INTRODUCTION TO DATABASES, ALGORITHM AND PROGRAMMING. LANGUAGES (e.g. MS- EXCEL, SCRATCH, VB DOT NET ETC.) (5.1)
Content standard: B6.5.1.1 - Demonstrate how to manipulate data in Databases
Indicator: B6.5.1.1.7 - Illustrate basics of relational algebra.
Suggested placement: Term 2, Week 3 (Week 15 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. 39
Transcribed from the official NaCCA publication. Check this page against the source.

Guide learners apply the basics of relational algebra in a sample database.