JSS3 COMPUTER STUDIES LESSON NOTE
TOPIC: DATABASE MANAGEMENT SYSTEM (DBMS)
1. DEFINITION OF DATABASE
A Database is an organized collection of related data or information stored in a way that it
can be easily accessed, managed, and updated.
• Manual Database: Records kept on paper (e.g., a school register or a library card catalog).
• Electronic Database: Records stored on a computer (e.g., a digital school portal or a
banking app).
2. DEFINITION OF DBMS
DBMS stands for Database Management System. It is a specialized application software that
allows users to create, store, retrieve, and manage data in a database. It acts as an
interface between the user and the database.
Common Examples of DBMS Software:
• Microsoft Access
• MySQL
• Oracle
• SQLite
• Microsoft SQL Server
3. KEY DATABASE TERMINOLOGIES
-------------------------------------------------------------------------
Term | Definition | Example
----------------|-------------------------------------------|------------
Character | Smallest unit of data (letter/number). | "A", "5"
Field | A single piece of info (Column). | Student Name
Record | Collection of related fields (Row). | One student's info
Table | Collection of related records. | JSS3 Class List
Primary Key | Unique field to identify a record. | Admission No.
Query | Request for specific information. | Find JSS3 Gold
Form | Window for data entry. | Registration form
Report | Formatted output for printing. | Result Sheet
-------------------------------------------------------------------------
4. FUNCTIONS OF A DBMS
• Data Security: Protects information using passwords.
• Data Integrity: Ensures that the data is accurate.
• Multi-user Access: Allows many people to use it at once.
• Backup and Recovery: Prevents loss of data.
To help them visualize how the software actually fits into the "real world," you can explain
that the Database is like a digital filing cabinet, and the DBMS (like Microsoft Access) is the
librarian that helps you find or add files quickly.
5. SUMMARY EVALUATION
1. What is the full meaning of DBMS?
2. Differentiate between a Field and a Record.
3. Why is a Primary Key important in a database?
4. List three examples of DBMS packages.
1. The Structure of a Data Table
This diagram shows the fundamental building blocks of how data is stored.
How to use it: When explaining the definitions of "Field," "Record," and "Table," use this
picture. Point out that Fields (Columns) go down, representing categories of information (like
Surname). Then, show how Records (Rows) go across, representing all the collected
information for one single person.
2. Manual vs. Electronic Databases (Analogy)
This illustration creates a strong visual memory by comparing something familiar (a messy desk)
to what they are learning (a neat database).
How to use it: Use this when introducing the concept of a database. Ask the students: "If I asked
you to find one student's phone number, which side would be faster?" This highlights the
efficiency, speed, and organization advantages of an Electronic Database managed by a DBMS.
3. Basic DBMS Architecture
This diagram simplifies the relationship between the user, the software, and the physical storage.
How to use it: Use this when explaining the "Functions of a DBMS." Explain that the student
(User) doesn't interact with the raw data directly. Instead, they use a friendly interface (the
DBMS software, like MS Access). The DBMS is the "brain" that handles the security, finds the
specific data in the storage "cylinder," and presents it back to the user neatly. This diagram is key
to explaining that a DBMS is an interface.
It sounds like you're diving deeper into the specific ways data can be structured! In a DBMS,
Database Models (or forms) define the logical structure of a database and determine how data
can be stored, organized, and manipulated.
Here is a breakdown of the forms you mentioned:
Forms of Database Models
1. Flat File Database
This is the simplest form of a database. All data is stored in a single table (like an Excel
spreadsheet). There are no complex relationships between different files.
Best for: Simple lists, like a contact list or a daily expense tracker.
Limitation: If you have a lot of data, you end up repeating information many times (Data
Redundancy).
2. Hierarchical Database Model
Data is organized into a tree-like structure. It uses a "parent-child" relationship. Each "child"
can have only one "parent," but a "parent" can have multiple "children."
Structure: Looks like an inverted tree or an organizational chart.
Example: Windows File Explorer (Folders inside Folders).
3. Network Database Model
This is similar to the hierarchical model, but more flexible. In this model, a child record can
have multiple parents. This creates a "web" or "network" of connections.
Advantage: It reduces data redundancy better than the hierarchical model.
Example: A student who belongs to multiple school clubs.
4. Relational Database Model (RDBMS)
This is the most common form used today (like Microsoft Access or MySQL). Data is
organized into multiple tables that are linked to each other using keys (like a Student ID).
Structure: Tables consisting of Rows (Records) and Columns (Fields).
Key Feature: Tables are "related" to each other through common fields.
Example: A school database where a "Student Table" is linked to a "Library Table" by
the Admission Number.
Summary Table: Comparing Database Forms
Model Structure Key Characteristic
Flat File Single Table Simple, but leads to repeated data.
Hierarchical Tree Structure One parent per child; rigid.
Network Web Structure Multiple parents per child; flexible but complex.
Relational Linked Tables Uses keys to connect data; most popular.
Examples of DBMS by Model
Relational: Microsoft Access, MySQL, Oracle, PostgreSQL.
Hierarchical: IBM’s Information Management System (IMS).
Flat File: CSV files, basic Excel sheets.