B6 Computing · Term 2 Week 3: INTRODUCTION TO DATABASES, ALGORITHM AND PROGRAMMING. LANGUAGES (e.g. MS- EXCEL, SCRATCH, VB DOT NET ETC.)

Lesson notes

Indicator: B6.5.1.1.5 - Describe the basics of Relational Data model.

By the end of the lesson, learners can:

Explain what a relational data model is and why it is one of the most common ways to store data.
Identify rows and columns in a table and describe what each represents.
Define the terms “field”, “record” and “table” using examples from everyday life.
Create a simple relational data table from a given set of data.
Distinguish between a row (record) and a column (field) when looking at any data table.

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.5 - Describe the basics of Relational Data model.
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.
Source document note: The official curriculum document has a fault in this entry, so the curriculum text above is transcribed exactly as printed:

indicator text - p.39: the document numbers this sub-strand .1, .2, .3, .5, .6, .7 and prints no B6.5.1.1.4 anywhere. Transcribed as printed; the gap is the document's
Curriculum reference: Computing Curriculum (Basic 4-6), 2019, p. 39
Transcribed from the official NaCCA publication. Check this page against the source.

Lead learners to describe the basics of Relational Data model. ie. rows and columns