INTRODUCTION TO DATABASES… · B6 Computing

Lesson notes

Indicator: B6.5.1.1.6 - Identify the basics of logical Database Design.

By the end of the lesson, learners can:

Define logical database design in their own words as the planning stage that shows what data to store and how the data connects before building a database.
List at least four basics of logical database design, such as identifying entities, defining attributes, choosing primary keys, and setting relationships.
Identify entities and their attributes from a given real-life scenario, such as a school library or a market seller’s records.
Develop a simple sample database design diagram or chart for a given scenario, showing tables, key fields, and how they link.
Explain why logical database design matters before typing data into a program like MS Excel, using examples from familiar Ghanaian settings.

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.6 - Identify the basics of logical Database Design.
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 to list the basics of logical database design and develop sample database design.