Creating Databases and Basic Database Operations for SS 3

Class: SS 3
Term: First Term
Week: 5
Age: 16 years
Duration: 45 minutes
Subject: Computer Science
Previous Lesson: Database Management Systems, Examples, Technologies and Organisation
Topic: DATABASE
Subject Matter: Creating database: Basic operations

Specific Objectives

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

Cognitive Domain

• Explain the steps involved in creating a database.
• Identify different field types used in a database.
• State the purpose of basic database operations like searching, sorting, and modifying.

Affective Domain

• Appreciate the importance of well-structured databases.
• Demonstrate patience and attention to detail when entering data.

Psychomotor Domain

• Create a simple database in a computer system.
• Define the structure of a database by creating tables and fields.
• Indicate appropriate field types for different data.
• Enter and save data into a database table.
• Perform basic database operations such as searching, sorting, and modifying data.
• Generate a simple report from a database.

Reference Materials

The following resources were used in planning this lesson:

• 2025 Revised 9 Years Basic Education Curriculum
• Relevant State Unified Scheme of Work
• Computer Science for Senior Secondary Schools, Book 3
• The HeadTeacher Scheme of work

Instructional Materials

The teacher will teach this lesson with the aid of:

• Computer systems in a laboratory (H.O.E – Hands-On Experience)
• Projector and screen (optional, for demonstration)
• Database software (e.g., Microsoft Access, LibreOffice Base)
• Whiteboard and markers
• Charts illustrating database structure and field types

Rationale for the Lesson

This lesson is essential as it provides students with practical skills in database management, which is a fundamental aspect of modern information technology. Understanding how to create and manipulate databases prepares students for further studies in computer science and equips them with valuable skills applicable in various professional fields. It bridges theoretical knowledge with hands-on application.

Prerequisite/Previous Knowledge

Students should have a basic understanding of what a database is, its components (tables, records, fields), and the concept of data organization.

Lesson Content/Board Summary

DATABASE

Creating a Database

Creating a database involves setting up the structure where data will be stored. This typically includes defining tables, fields, and their respective data types.

1. Launching Database Software: Open a database management system like Microsoft Access or LibreOffice Base.
2. Starting a New Database: Select the option to create a new, blank database.
3. Naming and Saving the Database: Give the database a meaningful name and choose a location to save it.
4. Creating Tables: Databases are organized into tables. Each table holds related data. For example, a “Students” table or a “Products” table.
5. Defining Structure (Fields):
   1. Within each table, define fields (columns) that represent specific pieces of information. For example, in a “Students” table, fields might include “StudentID”, “FirstName”, “LastName”, “DateOfBirth”.
   2. Assign a unique primary key to each table, which uniquely identifies each record.
6. Indicating Field Type (Data Types): For each field, specify the type of data it will store. Common field types include:
   1. Text/Short Text: For names, addresses, descriptions (alphanumeric characters).
   2. Number/Long Integer: For numerical values that can be used in calculations (e.g., quantity, age).
   3. Date/Time: For dates and times.
   4. Currency: For monetary values.
   5. Yes/No (Boolean): For fields with only two possible values (true/false, on/off).
   6. Memo/Long Text: For longer blocks of text.
7. Entering and Saving Data: Once the table structure is defined, data can be entered into the fields for each record (row). After entering, the data is saved within the table and the database.

Basic Database Operations

Once data is in a database, various operations can be performed to manage and retrieve information effectively.

1. Searching (Querying): This operation involves finding specific data within the database that meets certain criteria. For example, searching for all students named “Ahmed” or all products with a price greater than N500.
2. Sorting: This operation arranges data in a specific order, either ascending (A-Z, 0-9) or descending (Z-A, 9-0), based on the values in one or more fields. For example, sorting students by “LastName” alphabetically or by “DateOfBirth” from oldest to newest.
3. Modifying (Updating): This operation involves changing existing data in the database. For example, updating a student’s address or changing the price of a product.
4. Generating Report: This operation involves presenting selected data from the database in an organized, readable, and printable format. Reports can summarize data, display specific records, or show trends, making it easier to analyze and share information.

Teaching Methods/Instructional Techniques

Discussion, Demonstration, Guided Practice, Question and Answer, Explanation, Observation, Practical Activity

Instructional Procedures

Step 1: Introduction

Time: 5 minutes

Teaching Skill: Recalling/Engaging

Teacher’s Activity: The teacher greets the students and briefly reviews the previous lesson on database concepts. The teacher then introduces the day’s topic: creating databases and performing basic operations, highlighting its practical relevance.

Pupils’ Activity: Students respond to greetings, recall previous knowledge, and listen attentively to the introduction of the new topic.

Learning Point: Database creation relevance

Step 2: Introduction to Database Creation

Time: 7 minutes

Teaching Skill: Explaining/Demonstrating

Teacher’s Activity: The teacher guides students to the computer laboratory (H.O.E) and demonstrates how to launch a database software (e.g., Microsoft Access) and create a new, blank database. The teacher explains the initial steps of naming and saving the database.

Pupils’ Activity: Students observe the teacher’s demonstration and follow along on their systems if available, naming and saving their own blank databases.

Learning Point: Database setup process

Step 3: Defining Database Structure and Field Types

Time: 8 minutes

Teaching Skill: Guiding/Illustrating

Teacher’s Activity: The teacher demonstrates how to create a table within the new database. The teacher explains and guides students to define fields (e.g., StudentID, Name, Age) and select appropriate data types for each field (e.g., Number, Text, Date/Time), emphasizing the importance of a primary key.

Pupils’ Activity: Students create a table, define fields, and select appropriate data types under the teacher’s guidance, asking questions for clarification.

Learning Point: Table and field definition

Step 4: Entering and Saving Data

Time: 6 minutes

Teaching Skill: Practising/Monitoring

Teacher’s Activity: The teacher demonstrates how to enter sample data into the newly created table. The teacher guides students to enter several records into their tables and ensures they understand how to save the data.

Pupils’ Activity: Students actively enter sample data into their tables and save their work, seeking assistance when needed.

Learning Point: Data entry and saving

Step 5: Performing Basic Operations (Searching, Sorting, Modifying)

Time: 7 minutes

Teaching Skill: Demonstrating/Facilitating

Teacher’s Activity: The teacher demonstrates how to perform searching (querying for specific data), sorting (arranging data in order), and modifying (updating existing records) using the database software. Students are guided through practical exercises for each operation.

Pupils’ Activity: Students follow the demonstration, then practice searching, sorting, and modifying data in their own databases.

Learning Point: Data manipulation skills

Step 6: Generating Reports

Time: 5 minutes

Teaching Skill: Explaining/Applying

Teacher’s Activity: The teacher demonstrates how to generate a simple report from the database, showing how to select fields and arrange the output. The teacher explains the usefulness of reports.

Pupils’ Activity: Students observe the report generation process and attempt to create a basic report from their data.

Learning Point: Database report generation

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. Mention two steps involved in creating a database.
2. List three common field types you can use in a database.
3. What is the purpose of sorting data in a database?
4. How would you modify an existing record in a database?

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Database operations 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 creating databases and basic operations into their notebooks.

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

Learning Point: Database concepts recording

Step 9: Conclusion

Time: 3 minutes

Teaching Skill: Summarizing/Reinforcing

Teacher’s Activity: The teacher briefly summarizes the key steps for creating a database and performing basic operations, emphasizing the practical skills acquired and their importance in managing information. The teacher encourages students to continue practicing.

Pupils’ Activity: Students listen to the summary and ask any final questions.

Learning Point: Lesson concepts reinforced

Continuous Assessment/Further Study

Type: Homework/Practical Exercise

Instruction: Using a database software, create a simple database for a small library or a school’s class list. Perform the following tasks:

1. Create a database named “MyLibrary” or “ClassList_SS3”.
2. Create a table with at least 5 relevant fields (e.g., BookTitle, Author, ISBN, PublicationYear, AvailableStatus for library; or StudentName, AdmissionNo, Gender, DateOfBirth, Class for class list).
3. Define appropriate data types for each field.
4. Enter at least 10 records into your table.
5. Search for specific records (e.g., books by a certain author, male students).
6. Sort the data by at least one field (e.g., by BookTitle alphabetically, by StudentName).
7. Modify at least two existing records.
8. Generate a simple report showing all records.

Lesson Keywords

• Database – An organized collection of structured information, or data, typically stored electronically in a computer system.
• Field Type – The characteristic of a field that determines what kind of data it can store (e.g., text, number, date).
• Searching – The process of locating specific data within a database based on defined criteria.
• Sorting – Arranging data in a particular order (ascending or descending) based on the values in one or more fields.
• Modifying – The act of changing or updating existing data in a database.
• Report – An organized presentation of data from a database, often used for analysis or printing.

Differentiation

For weaker learners, the teacher should provide more direct, step-by-step guidance during the practical session, possibly pairing them with stronger students. Provide pre-designed database templates or simpler data entry tasks. For faster learners, challenge them to explore more advanced features of the database software, such as creating relationships between tables or designing more complex queries and reports.

Suggested Lesson Videos

For further understanding and visual demonstration, students can search for “creating database and basic operations SS3” on YouTube.

Teacher Guide for Using This Lesson Plan

Before the lesson, ensure the computer laboratory is fully functional with all necessary database software installed on each system. Have a sample database structure and data prepared for demonstration. Begin by briefly reviewing database basics to activate prior knowledge. During the practical steps, move around the lab to observe students’ progress, provide immediate assistance, and correct common errors, especially with defining field types and entering data. Encourage students to experiment with the software’s interface. Emphasize the importance of saving work frequently. For Step 8, ensure students copy the Board Summary accurately into their notebooks. Conclude by reinforcing the practical skills learned and their real-world applications. Pay attention to students who may struggle with navigating the software or understanding logical operations like searching criteria.