Lesson Notes By Weeks and Term v3 - Junior Secondary 3
Database
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Database
Download the Lessonotes Mobile Nigeria 2025 app for faster lesson access on Android and iPhone.
Subject: Information Technology (IT)
Class: Junior Secondary 3
Term: 2nd Term
Week: 8
Theme: Computer Application Packages
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.
explain the following database terminologies (fields, record, file, and key); identify various for ms of database; start and open an existing database; in put, store and retrieve in for mation from a database application.
Information: Explanation: Once data is entered, it needs to be saved permanently within the database file. Most database applications automatically save changes as you input them or when you move to a new record. Explicit save commands (like `Ctrl+S`) might be used for entire database objects (tables, forms, queries) after design changes.
Procedure: For data entered directly into a table or via a form, the database system typically handles the storage automatically upon completion of a record or moving to the next. For design changes to a table or form, typically a "Save" icon or `File > Save` option is used. Nigerian
Example: Once a student's JAMB registration details are entered, they are permanently stored in the JAMB database. When a customer makes a deposit at a bank, the transaction details are instantly stored.
3. Retrieving Information: Explanation: This is the process of extracting specific data from the database based on certain criteria. Retrieval can involve simple viewing, sorting, filtering, or complex queries to find specific information.
Procedure (Example in Access): Viewing a Table: Simply open the table (e.g., "Students") to view all records and fields.
Sorting: Click on a field header (e.g., "Last_Name") and select "Sort A to Z" or "Sort Z to A" to reorder the records.
Filtering: Click on the filter arrow next to a field header (e.g., "State_of_Origin"). Select specific values (e.g., "Lagos") to display only records matching that criteria.
Using Queries: This is a more powerful way to retrieve data.
Step 1: Go to the "Create" tab and select "Query Design." Step 2: Add the table(s) you want to query (e.g., "Students").
Step 3: Drag the desired fields (e.g., "First_Name," "Last_Name," "State_of_Origin") to the design grid.
Step 4: In the "Criteria" row for a specific field, enter the condition (e.g., for "State_of_Origin," type "Lagos").
Step 5: Click "Run" (the exclamation mark icon) to see the results. Nigerian
Example:** Finding all students in the school who are from "Rivers State." Retrieving a list of all products in stock that have a "Quantity_in_Stock" less than
1
0. Searching for a customer's account details using their "Account_Number" in a banking system. --- Definition of a Database: A database is an organized collection of related information (data) stored and managed in a structured way, making it easy to access, manage, and update. Its primary purpose is to provide a systematic way to store and retrieve information efficiently.
Database Terminologies:
1. Field: Explanation: A field is the smallest unit of information in a database. It represents a single piece of data for a specific category. Think of it as a column in a table. Each field has a unique name that describes the type of data it holds. Nigerian
Example: In a school's student database, "First_Name," "Last_Name," "Admission_Number," "State_of_Origin," "Date_of_Birth," and "Class" are all fields. In a market inventory database, "Product_Name," "Unit_Price," "Quantity_in_Stock," and "Supplier" would be fields.
2. Record: Explanation: A record is a collection of related fields that describes a single entity or item. It is a complete set of information about one person, one item, or one event. Think of it as a row in a table. Nigerian
Example: For a school student database, one record would contain all the information about a single student, such as: {First_Name: "Aisha", Last_Name: "Mohammed", Admission_Number: "JS3/001", State_of_Origin: "Kano", Date_of_Birth: "12/03/2009", Class: "JS3A"}. This entire set of values for Aisha Mohammed forms one record. In a bank's customer database, one record would contain all the details of a single customer, including their name, account number, BVN, address, etc.
3. File (or Table): Explanation: In database terminology, a file (often interchangeably called a table) is a collection of related records. It is the primary structure where data is stored. All records within a file have the same set of fields. A database typically consists of one or more files/tables. Nigerian
Example: The "Students" file (or table) would contain all the records for every student in the school. The "Products" file (or table) would contain all the records for every product sold in a supermarket. The "Employees" file (or table) would hold records for all employees in an organization.
4. Key: Explanation: A key is a field or a set of fields that uniquely identifies a record in a table. It is crucial for maintaining data integrity and for linking related tables in a relational database. The most common type is the Primary Key.
Primary Key: This is a field (or combination of fields) that uniquely identifies each record in a table. No two records can have the same primary key value, and it cannot be empty (null). Nigerian
Example: In a school student file, "Admission_Number" is typically the Primary Key because no two students can have the same admission number. In a bank's customer file, "Account_Number" or "BVN (Bank Verification Number)" serves as a Primary Key. In the NIMC database, "NIN (National Identity Number)" is the Primary Key for each citizen's record.
Various Forms of Databases:
1. Manual Database: Explanation: This is a traditional system where information is stored and managed manually using physical items like paper, cards, ledgers, or registers. Data entry, retrieval, and updates are done by hand. Nigerian
Example: A school's attendance register where teachers manually mark presence/absence. A market trader's notebook where they record sales, inventory, and customer debts. A local clinic's patient file cabinet, where folders contain physical health records.
Pros: Simple to set up, no technology required.
Cons: Prone to errors, slow retrieval, difficult to update, easily damaged or lost, limited storage, difficult to share.
2. Computerized Database: Explanation: This system uses computer software and hardware to store, manage, and retrieve data electronically. Data is organized and stored in digital files, making it highly efficient, accurate, and scalable. Nigerian
Example: JAMB's online portal for student registration and result checking. Commercial banks' systems for managing customer accounts and transactions. Supermarket Point-of-Sale (POS) systems that track sales and inventory electronically. NIMC's system for managing citizens' NIN records. Types of Computerized Databases (relevant for JSS3): * Flat-File Database: A simple database system where all data is stored in a single table. There are no links between different tables. It's retrieve data electronically. Data is organized and stored in digital files, making it highly efficient, accurate, and scalable. Nigerian
Example: JAMB's online portal for student registration and result checking. Commercial banks' systems for managing customer accounts and transactions. Supermarket Point-of-Sale (POS) systems that track sales and inventory electronically. NIMC's system for managing citizens' NIN records. Types of Computerized Databases (relevant for JSS3): Flat-File Database: A simple database system where all data is stored in a single table. There are no links between different tables. It's suitable for small, uncomplicated datasets. Nigerian
Example: A simple spreadsheet (like Microsoft Excel) used by a small business to keep a single list of customers with their names, phone numbers, and addresses.
Relational Database (RDB): The most common and powerful type. Data is organized into multiple tables, and these tables are linked together using common fields (keys). This allows for efficient storage, reduces data redundancy, and enables complex queries across different datasets. Nigerian
Example: A university database with separate tables for "Students," "Courses," and "Lecturers," all linked by common IDs (e.g., Student_ID, Course_ID). This allows the system to show which students are taking which courses taught by which lecturers.
Software examples: Microsoft Access, MySQL, Oracle, SQL Server. Starting and Opening an Existing Database (using Microsoft Access as a common example):
1. To Start a New Database: Step 1: Click on the "Start" button (or "Search" bar) on your computer.
Step 2: Search for "Microsoft Access" (or "LibreOffice Base" if using open-source software) and click to open the application.
Step 3: Once Access opens, select "Blank desktop database" (or "New database" in other applications).
Step 4: You will be prompted to give the new database a "File Name" and choose a "Location" to save it. Enter a name (e.g., "SchoolRecords") and click "Create." Step 5: Access will create a new empty database file, usually with a default table ready for data entry.
2. To Open an Existing Database: Step 1: Click on the "Start" button and open "Microsoft Access." Step 2: On the Access start screen, look for the "Open Other Files" option or a list of "Recent" databases.
Step 3: If the file is not in the "Recent" list, click "Browse" or "Open Other Files" and then "Browse" again.
Step 4: Navigate to the folder where the database file is saved (e.g., "Documents" or a specific "IT Projects" folder).
Step 5: Select the database file (it usually has a `.accdb` or `.mdb` extension for Access) and click "Open." Step 6: The database will open, displaying its tables, queries, forms, and reports. Inputting, Storing, and Retrieving Information from a Database Application:
1. Inputting Information (Data Entry): Explanation: This involves adding new records or updating existing ones in the database. Data is entered into the specified fields.
Procedure (Example in Access): Using a Table: Open the desired table (e.g., "Students") in "Datasheet View." Scroll to the last empty row (marked with an asterisk ``) and type in the data for each field in the new record.
Using a Form: If a data entry form exists (e.g., "Student Registration Form"), open it. The form provides a user-friendly interface with text boxes and labels for each field. Enter the data into the relevant fields and click a "Save" or "New Record" button, if available. Nigerian
Example: Entering new student details (name, class, admission number) into the school's student database. Entering details of new stock items into a supermarket's inventory system.
2. Storing Information: Explanation: Once data is entered, it needs to be saved permanently within the database file. Most database applications automatically save changes as you input them or when you move to a new record. Explicit save commands (like `Ctrl+S`) might be used for entire database objects (tables, forms, queries) after design changes.
Procedure: For data entered directly into a table or via a form, the database system typically handles the storage automatically upon completion of a record or moving to the next. For design changes to a table Introduction (10 minutes)
Teacher Activity: Begin by asking students how information is stored in their school (e.g., student register, attendance sheets). Ask how a large organization like a bank or JAMB manages millions of records. Introduce the concept of a "database" as a systematic way to organize and retrieve such information. State the lesson objectives clearly.
Student Activity: Participate in brainstorming and discussion. Listen attentively and ask clarifying questions.
Activity 1: Explaining Database Terminologies (25 minutes)
Teacher Activity: Write "Field," "Record," "File," and "Key" on the board. Using the analogy of a traditional school register or student profile form (e.g., JAMB form), explain each term with clear, step-by-step reasoning. Draw a simple table structure on the board, illustrating columns as fields and rows as records. Emphasize the role of a "Primary Key" for unique identification using Nigerian examples (Admission Number, BVN, NIN). Engage students with questions to check understanding.
Student Activity: Listen and take notes. Identify fields and records in provided scenarios (e.g., a sample student ID card, a product label). Propose examples of primary keys for different scenarios (e.g., patient ID in a hospital, vehicle registration number).
Activity 2: Identifying Forms of Database (20 minutes)
Teacher Activity: Explain and differentiate between "Manual Database" and "Computerized Database" using local examples (school register vs. student information system, market trader's book vs. supermarket POS). Further explain "Flat-File" and "Relational" databases within computerized systems, focusing on the concept of single table vs. linked tables, respectively, with simple analogies. Show pictures/diagrams of typical manual registers or simple computer interfaces for data entry (if a projector is available).
Student Activity: Classify given scenarios as manual or computerized databases. Provide their own examples of each database form in their community. Discuss the advantages and disadvantages of each form.
Activity 3: Starting, Opening, Inputting, Storing, and Retrieving (35 minutes)
Teacher Activity: If computers are available:* Demonstrate step-by-step how to open Microsoft Access (or LibreOffice Base). Show how to create a new blank database and name it. Show how to open an existing database file. Demonstrate creating a simple table, defining fields, and entering sample records. Show how to save the table. Demonstrate simple data retrieval by sorting and filtering records in the table. Walk through a basic query design to retrieve specific data (e.g., "students from Kaduna").
If no computers are available (simulated):* Draw mock-up screens on the board or use printed handouts illustrating the menu options and steps for starting and opening Access. Create a large table on the board. Guide students to verbally "input" data, "store" it by writing it down, and then "retrieve" specific records by identifying them based on criteria provided by the teacher (e.g., "Find the record for the student whose 'Class' is 'JS3B' and 'First_Name' is 'Emeka'"). Emphasize the logical steps involved regardless of the physical tool.
Student Activity: If computers are available:* Follow the teacher's demonstration, practicing the steps on their own computers or in groups.
If no computers are available:* Actively participate in the simulated exercise, providing verbal input, identifying records, and taking detailed notes on the procedural steps. Ask questions about specific menu items or actions.
Conclusion (5 minutes)
Teacher Activity: Summarize the key concepts covered: database terms, forms of databases, and basic operations (start, open, input, store, retrieve). Reiterate the importance of databases in daily life. Assign homework.
Student Activity: Participate in a brief recap. Note down homework assignment. ---
National Identity Management: Databases are fundamental to the operation of the National Identity Management Commission (NIMC) which manages the National Identity Number (NIN) for all Nigerians. Each citizen's personal details, biometrics, and other relevant information are stored as records within a vast database, with the NIN serving as a primary key. This enables efficient identity verification for various services like passport applications, voter registration, and opening bank accounts.
Education Sector (JAMB/WAEC/NECO): Examination bodies like JAMB, WAEC, and NECO heavily rely on databases to manage millions of student registrations, examination results, and admissions data. Student details, subjects offered, scores, and admission status are stored as records. This allows for quick processing, retrieval of results (e.g., checking results online using a registration number), and efficient data analysis for educational planning.
Banking and Financial Services: Every commercial bank in Nigeria uses sophisticated database systems to manage customer accounts, transactions (deposits, withdrawals, transfers), loan applications, and ATM activities. Each customer has a unique account record, and every transaction is recorded. This ensures security, accuracy, and quick access to financial information, facilitating services like online banking and mobile transfers. The BVN (Bank Verification Number) acts as a crucial primary key linking all accounts of an individual. ---