Database concepts: meaning, components, and uses. Database is a key topic in Basic 9 computing because it teaches students how information is stored, organized, and retrieved efficiently. Many real-life systems such as school records, hospital systems, banks, and online stores depend on databases.
Meaning of a database
A database is an organized collection of related data stored in a computer system so it can be easily accessed, managed, and updated.
For example, a school may store students’ names, classes, ages, and examination scores in a database. Instead of writing everything in a notebook, the information is stored electronically and can be searched quickly.
Key terms in database
Data: Data refers to raw facts such as names, numbers, dates, or marks.
Field: A field is a single piece of information about a record. Example: Student Name, Age, or Class.
Record: A record is a complete set of related fields about one person or item. For example, all the information about one student forms a record.
Table: A table is a collection of related records arranged in rows and columns. Most databases are made up of tables.
Primary key: A primary key is a field that uniquely identifies each record in a table. For example, Student ID can serve as a primary key because no two students should have the same ID.
Components of a database system
Hardware: Computers and storage devices used to store and manage data.
Software: Database software used to create and manage databases. An example is Microsoft Access.
Data: The actual information stored in the system.
Users: People who enter, manage, and retrieve data from the database.
Uses of database
School management: Stores students’ records, attendance, and results.
Hospital records: Stores patients’ medical history and treatment information.
Banking: Keeps records of customers’ accounts and transactions.
Business: Stores product details, sales records, and customer information.
Advantages of database
- Fast access to information
- Reduced data duplication
- Improved data accuracy
- Better data security
- Easy updating and editing
Disadvantages of database
- High cost of setup
- Requires trained personnel
- Risk of data loss if not backed up
- Security threats such as hacking
Difference between manual filing system and database
- Manual filing uses paper files and cabinets. Searching for information takes more time and physical effort.
- Database systems store information electronically. Searching, sorting, and updating records are faster and more accurate.
- Students should also revise related topics such as the information processing cycle and data representation, since databases depend on proper data input and processing.
Basic 8 / JHS 2 Computing (ICT) – Term One objective test
Database concepts: meaning, components, and uses.
