Lesson Notes By Weeks and Term v4 - SHS 2
WEB TECHNOLOGIES AND DATABASES
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
WEB TECHNOLOGIES AND DATABASES
Download the Lessonotes Mobile Ghana app for faster lesson access on Android and iPhone.
Subject: Computing
Class: SHS 2
Term: 2nd Term
Week: 20
Grade code: 2.2.3.LI.3
Strand code: 2
Sub-strand code: 3
Content standard code: 2.2.3.CS.1
Indicator code: 2.2.3.LI.3
Theme: COMPUTATIONAL THINKING (PROGRAMMING LOGIC)
Subtheme: WEB TECHNOLOGIES AND DATABASES
This page supports the lesson note with a companion video and a short classroom-ready summary.
For class groups and homework, share this lesson page so learners also get the summary, objectives, and full lesson context.
Welcome, learners! Every day, you interact with systems that store and manage huge amounts of information. When you check your SHS placement on the CSSPS portal, buy airtime, or send money with Mobile Money (Momo), you are using a database. A database is not just a random collection of data; it is a highly organised system. For it to work efficiently, it must be planned carefully. Today, we are going to learn how to be the architects of these systems. We will learn how to design the blueprint for a database, called a relational database model.
Phase 1: What is a Database? (5 minutes)
Think of your school's attendance register. It’s a collection of organised information about students. A database is simply a digital version of this – an organised collection of data stored electronically.
But just throwing data into a computer is not enough. We need structure. The most common way to structure data is by using tables. Table (or Entity): A table stores data about a specific thing, like `Students`, `Teachers`, or `Subjects`. Think of it as a single sheet in your attendance register. Record (or Row): A single entry in a table. It represents one item. For example, one row in the `Students` table represents *one specific student*. Field (or Attribute/Column): A single piece of information about a record. In a `Students` table, the fields would be `StudentID`, `FirstName`, `LastName`, `DateOfBirth`, etc.
Example: A Simple `Students` Table