Database Introduction - SSS 1 note
DATABASE INTRODUCTION
Subject: Digital Technologies
Class: SSS 1
Term: Third Term
Week: 6
Topic: Database Introduction
Duration: 80 Minutes (Double Period)
Learning Objectives
By the end of the lesson, students should be able to:
- Define a database.
- Explain the meaning and purpose of a Database Management System (DBMS).
- Identify tables, records and fields in a database.
1. Meaning of a Database
A database is an organised collection of related data stored so that it can be easily accessed, managed, updated and retrieved.
Data can include names, addresses, dates, identification numbers, examination scores, product details and other information.
For example, a school may keep a database containing information about its students, including their names, admission numbers, classes and examination results.
Examples of Databases in Everyday Life
- Schools: Store students' names, admission numbers, classes and results.
- Banks: Keep customer details and transaction records.
- Hospitals: Store patient information and medical appointments.
- Libraries: Keep records of books, authors and borrowed materials.
- Shops: Store product details, prices and stock quantities.
2. Importance of Databases
Databases help individuals and organisations manage large amounts of information efficiently. Their importance includes:- Easy storage: Information can be stored in an organised manner.
- Quick retrieval: Required information can be found more easily.
- Easy updating: Existing information can be corrected or changed.
- Organisation: Related information can be grouped systematically.
- Reduced duplication: Proper database design can reduce unnecessary repetition of data.
- Reporting: Information can be arranged into useful reports.
- Data sharing: Authorised users can access shared information where the system permits.
Example: Instead of searching through hundreds of paper files to find a student's admission number, a school can use its database to locate the student's record quickly.
3. Meaning of Database Management System (DBMS)
A Database Management System (DBMS) is software used to create, store, organise, retrieve, update and manage data in a database.
A DBMS provides tools for working with the information stored in a database. It helps users perform database operations without having to manage every detail of data storage manually.
Examples of Database Management Systems
- Microsoft Access: A database application commonly used for desktop databases.
- MySQL: A relational database management system used in many applications and websites.
- PostgreSQL: A relational database management system for storing and managing structured data.
- Oracle Database: A database management system used by many organisations.
- SQLite: A lightweight database engine used in many applications.
Functions of a DBMS
- Creating and organising databases.
- Adding new records.
- Retrieving information from stored data.
- Updating or deleting records when authorised.
- Searching and sorting information.
- Controlling access to information.
- Supporting backup and recovery, depending on the system.
Database and DBMS: The Difference
| Database | Database Management System |
|---|---|
| The organised collection of related data. | The software used to create and manage the data. |
| Contains information such as student names and scores. | Provides tools for entering, retrieving and updating that information. |
| Example: a school's student database. | Example: Microsoft Access or MySQL. |
4. Tables, Records and Fields
Most relational databases organise information into tables. A table contains rows and columns.
Table: A collection of related data arranged in rows and columns.
Record: A complete set of related information about one item or person, usually represented by one row in a table.
Field: A particular category of information represented by a column in a table.
Example of a Student Database Table
| Admission No. | Student Name | Class | Age |
|---|---|---|---|
| ST001 | Ada Okafor | SSS 1 | 15 |
| ST002 | Emeka Bello | SSS 1 | 16 |
| ST003 | Fatima Musa | SSS 1 | 15 |
From the table above:
- Table: The entire Student table.
- Fields: Admission No., Student Name, Class and Age.
- Records: Each student's complete row of information.
- Example record: ST001, Ada Okafor, SSS 1, 15.
- Example field value: Ada Okafor is a value in the Student Name field.
Important distinction: A field describes the type of information stored in a column, while a field value is the actual information entered into a particular cell.
5. How Tables, Records and Fields Work Together
A database table uses fields to define the information to be stored. Each record then contains the values for one entry. For example, in a student database:- The Student Name field stores names.
- The Class field stores class information.
- The ST001 record contains the information for one student.
Primary Key: An Additional Database Concept
A primary key is a field, or combination of fields, used to identify each record uniquely in a database table. For example, the Admission No. field can serve as a primary key in the student table because each student should have a different admission number. A primary key helps distinguish one record from another, even when two students have the same name.6. Basic Database Operations
A database system commonly supports the following operations:| Operation | Meaning | School Example |
|---|---|---|
| Create | Set up a new database or table. | Create a student database. |
| Insert | Add new data. | Enter a new student's details. |
| Retrieve | Find and display stored information. | Find a student's admission number. |
| Update | Change existing information. | Correct a student's class. |
| Delete | Remove a record or data item. | Remove a duplicate record after verification. |
Data safety: Records should not be changed or deleted without proper authorisation. Important databases should be backed up to reduce the risk of data loss.
7. Practical Classroom Activity
Activity: Identify the Parts of a Database Table
Study the student table in Section 4 and answer these questions:
- What is the name of the table?
- How many fields are shown?
- How many student records are shown?
- Which field could be used as the primary key?
- What is the value in the Class field for ST002?
Practical extension: If computers are available, open a database application such as Microsoft Access. Observe how a table is created and how fields and records are displayed.
Summary
- A database is an organised collection of related data.
- A DBMS is software used to create and manage databases.
- A table organises related data into rows and columns.
- A record contains related information about one item or person.
- A field represents a category of information in a table.
- A primary key uniquely identifies a record in a table.
- Databases support operations such as inserting, retrieving, updating and deleting information.
Evaluation Questions
- Define a database.
- State four uses or benefits of databases.
- What is a Database Management System (DBMS)?
- Mention four examples of database management systems.
- State four functions of a DBMS.
- Explain the difference between a database and a DBMS.
- Define a table, a record and a field.
- Using the student table in this lesson, identify one record and name all the fields.
- What is a primary key?
- State three basic operations that can be performed on database records.
Assignment
- Explain the meaning of a database and list five places where databases are used.
- Define DBMS and give four examples.
- Draw a table containing four fields and three student records. Label the fields and identify one complete record.
- Explain the difference between a field and a record using your table.
- Explain why a primary key is useful in a student database.
Test Your Knowledge
Select one answer for each question, then click Check Answers.
Comments
Post a Comment