Database Management Systems, Examples, Technologies and Organisation for SS 3

Class: SS 3
Term: First Term
Week: 4
Age: 14 years
Duration: 45 minutes
Subject: Computer Science
Previous Lesson: Uses and Benefits of the World Wide Web, Web Development and Network Cables
Topic: DATA BASE
Subject Matter: Definition: Examples of DBMS, Basic technologies, and Forms of data base organization

Specific Objectives

By the end of the lesson, pupils/students should be able to:

Cognitive Domain

• Define a database and a Database Management System (DBMS).
• List examples of Database Management System (DBMS) packages.
• Identify basic database technologies such as file, record, field, and keys.
• Describe different forms of database organization.

Affective Domain

• Appreciate the importance of organizing data effectively.
• Value the use of DBMS in managing large amounts of information.

Psychomotor Domain

• Identify features of an existing database, such as tables, rows, and columns.

Reference Materials

The following resources were used in planning this lesson:

• 2025 Revised 9 Years Basic Education Curriculum
• Relevant State Unified Scheme of Work
• A suitable Computer Science textbook for SS 3
• The HeadTeacher Scheme of work

Instructional Materials

The teacher will teach this lesson with the aid of:

• A computer system
• A projector (if available)
• Charts showing examples of database structures
• Whiteboard and markers
• Examples of database software interfaces (e.g., Microsoft Access screenshot)

Rationale for the Lesson

This lesson provides students with a fundamental understanding of how data is collected, stored, and managed efficiently. It explains the core concepts and tools used in organizing information, which is essential for understanding modern data-driven systems and for future careers in technology and data management.

Prerequisite/Previous Knowledge

Students should have a basic understanding of computer systems, data, information, and simple data storage concepts.

Lesson Content/Board Summary

DATA BASE

Definition of Database and DBMS

A database is an organized collection of related data, typically stored and accessed electronically from a computer system. It is designed to store, retrieve, and manage large amounts of information efficiently.

A Database Management System (DBMS) is a software application that allows users to define, create, maintain, and control access to the database. It acts as an interface between the user and the database, enabling data to be stored, modified, and extracted.

Examples of DBMS Packages

Some common examples of Database Management System (DBMS) packages include:

1. Dbase III
2. Dbase IV
3. FoxPro (formerly FoxBASE)
4. Microsoft Access
5. Oracle
6. MySQL
7. SQL Server

Basic Database Technologies/Components

Databases are structured using several fundamental components:

1. File: A collection of related records. In a database context, a file often refers to a table.
2. Record: A collection of related fields that represent a single entity or item. For example, all the information about one student (name, age, class) forms a record. Records are also known as rows or tuples.
3. Field: The smallest unit of data in a database, representing a single piece of information about an entity. For example, ‘Name’ or ‘Age’ would be fields. Fields are also known as columns or attributes.
4. Keys: Special fields used to uniquely identify records and establish relationships between different tables in a database.
   1. Primary Key: A field (or combination of fields) that uniquely identifies each record in a table. It cannot contain duplicate values or null values.
   2. Foreign Key: A field in one table that refers to the primary key in another table. It is used to link two tables together.

Forms of Database Organization

Databases can be organized in various ways, each with its own structure and method of storing and retrieving data:

1. Hierarchical Model: Data is organized in a tree-like structure, with a single root and branches. Each child record has only one parent. This model is simple but rigid.
2. Network Model: An extension of the hierarchical model, allowing a child record to have multiple parent records. This provides more flexibility in representing complex relationships.
3. Relational Model: Data is organized into one or more tables (relations), where each table consists of rows and columns. Relationships between tables are established using common fields (keys). This is the most widely used model today.
4. Object-Oriented Model: Data is stored as objects, similar to objects in object-oriented programming. This model can handle complex data types and relationships.

Teaching Methods/Instructional Techniques

Discussion, Explanation, Demonstration, Question and Answer, Guided Practice

Instructional Procedures

Step 1: Introduction

Time: 5 minutes

Teaching Skill: Engaging/Recalling

Teacher’s Activity: The teacher greets the students and asks them to recall what they know about data and information, and how they are stored on a computer.

Pupils’ Activity: Students respond to the teacher’s questions, sharing their prior knowledge.

Learning Point: Data and information storage

Step 2: Definition of Database and DBMS

Time: 8 minutes

Teaching Skill: Explanation/Definition

Teacher’s Activity: The teacher leads students to define what a database is and then introduces the concept of a Database Management System (DBMS) as the software that manages it. The teacher provides clear examples.

Pupils’ Activity: Students listen attentively, participate in the discussion, and attempt to define the terms.

Learning Point: Database and DBMS definition

Step 3: Examples of DBMS Packages

Time: 7 minutes

Teaching Skill: Listing/Identification

Teacher’s Activity: The teacher mentions and explains various examples of database packages, such as Dbase III, Dbase IV, FoxPro, and modern ones like Microsoft Access, Oracle, and MySQL.

Pupils’ Activity: Students listen and note down the examples of DBMS packages mentioned by the teacher.

Learning Point: Examples of DBMS packages

Step 4: Basic Database Technologies

Time: 8 minutes

Teaching Skill: Explanation/Illustration

Teacher’s Activity: The teacher explains basic database technologies like file, record, field, and keys (primary and foreign keys) using simple analogies or diagrams.

Pupils’ Activity: Students listen, ask questions for clarity, and try to differentiate between the terms.

Learning Point: Database basic components

Step 5: Forms of Database Organization

Time: 7 minutes

Teaching Skill: Classification/Description

Teacher’s Activity: The teacher lists and briefly describes the different forms of database organization: Hierarchical, Network, and Relational models, highlighting the relational model’s prevalence.

Pupils’ Activity: Students listen and identify the various forms of database organization.

Learning Point: Database organization forms

Step 6: Demonstration of Database Features

Time: 6 minutes

Teaching Skill: Demonstration/Observation

Teacher’s Activity: The teacher displays an existing database (e.g., a simple table in Microsoft Access or a spreadsheet) on a computer or using a chart, pointing out features like files (tables), rows (records), and columns (fields) that contain specific types of information.

Pupils’ Activity: Students observe the displayed database and identify the features demonstrated by the teacher.

Learning Point: Database feature identification

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

1. What is a database?
2. Mention two examples of DBMS packages.
3. Differentiate between a record and a field.
4. List two forms of database organization.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Database concepts understanding

Step 8: Note-Taking

Time: 4 minutes

Teaching Skill: Guided Writing

Teacher’s Activity: The teacher guides pupils/students to copy the essential Board Summary notes on database definition, examples, technologies, and organization into their notebooks.

Pupils’ Activity: Pupils/students copy the notes carefully into their notebooks.

Learning Point: Database notes recording

Step 9: Conclusion

Time: 2 minutes

Teaching Skill: Consolidation

Teacher’s Activity: The teacher briefly summarizes the key points of the lesson, reinforcing the importance of databases in managing information in today’s world.

Pupils’ Activity: Students listen and reflect on the lesson’s main points.

Learning Point: Lesson summary reinforcement

Continuous Assessment/Further Study

Type: Homework

Instruction: Answer the following questions in your notebook.

1. Explain in your own words why organizations use databases.
2. Research and write a short note on the advantages of using a relational database model over a hierarchical model.
3. Identify a real-world example of a database you interact with daily (e.g., school records, bank ATM, social media) and list at least three ‘fields’ that might be stored in it.

Lesson Keywords

• Database – An organized collection of related data.
• DBMS – Software for managing databases.
• File – A collection of related records, often a table.
• Record – A row in a table, representing a single entity.
• Field – A column in a table, representing a single piece of information.
• Key – A field used to uniquely identify records or link tables.
• Relational Model – Database organization using tables with rows and columns.

Differentiation

For weaker learners: Provide simplified definitions and more visual aids. Focus on identifying examples of databases and the basic components (file, record, field) through practical demonstration. Pair them with stronger learners for note-taking.

For stronger learners: Encourage them to research different types of keys (e.g., candidate key, composite key) and their uses. Ask them to compare and contrast two different DBMS packages.

Suggested Lesson Videos

For further understanding, students can search for “Introduction to Database Management Systems SS3” or “What is a Database and DBMS” on YouTube.

Teacher Guide for Using This Lesson Plan

Before the lesson, ensure you have a computer system ready with a simple database application (like Microsoft Access or even a well-structured spreadsheet) to demonstrate database features. Prepare charts or diagrams illustrating the concepts of files, records, fields, and different database organization models. Begin by linking the concept of a database to students’ everyday experiences with organized information. Guide students through the definitions and examples, making sure they grasp the distinctions between a database and a DBMS. During the demonstration, clearly point out how tables, rows, and columns correspond to files, records, and fields. Encourage questions throughout the lesson to check understanding. Students should copy the Board Summary notes after the main teaching and evaluation, allowing them to focus on understanding during the instruction phase. Provide individual support to weaker learners and challenge faster learners with extension questions or research tasks.