Skip to content

Database is an application that is used to store information in a structured way. It is a collection of records or data in an organized form. A database is an organized collection of related information that allows the storage of different types of record with appropriate interconnections. Databases are designed to offer an organized mechanism for storing, managing and retrieving information. Database operates through the use of tables.



The idea of database came as a result of how people keep files in an office cabinet. In the ancient time, there were no computers and most fillings and storing were done manually. This allows redundancy of data and time wastage.


Advantages of Database

  1. It enables file or document sharing
  2. It allows consistency of data.
  3. It saves time.
  4. No data redundancy.
  5. It allows full file access.


Disadvantages of Database

  1. It is expensive to maintain.
  2. It requires experienced database administrator.
  3. It requires sophisticated software.



  • Table: a table is the basic unit of a database. It is a collection of related data about a specific subject. The table is divided into rows and columns.
  • Field: this is an area reserved for each piece of individual data, such as student ID, No etc.
  • Record: A record is a group of related fields pertaining to one person, place or thing. Databases consist of records and each record represents one item in a database.
  • Key field: A key field or primary key is a field that uniquely identifies each record in a file. The data in a key field is unique to a specific record.
  • File: is a collection of related records. If you work with a computer, you are already working with files.



  • Database is a collection of inter related files or tables.
  • File: is a collection of related records.
  • Record: is a collection of related fields.
  • Field: is the smallest unit of data about a person, thing, place, etc.



  1. List and explain TWO database terminologies.
  2. Explain database concept.
  3. What is file?
  4. List and explain two database terminologies.
  5. What is database?
  6. Mention TWO advantages and TWO disadvantages of database.



  1. …………… a group of related fields pertaining to one person or thing. A. Record B. Database B. File C. Key D. Table
  2. The basic unit of database is ……………………. A. record B. database B. file C. key D. table
  3. An application that is used to store information in a structured way is called…………. A. record B. database B. file C. key D. table
  4. Database allows……………….A. storage of large information B. allows redundant data C. none D. all
  5. Which of the term does not relate to database? A. key B. record C. file D. none



  1. What is a table in database?
  2. Differentiate between row and column


See also:







We built School Portal NG to specially serve as an alternative means to provide free education for the less-privileged children or children born to low-income earners, adults who otherwise cannot afford to finance their way through school.

  Building & maintaining an elearning portal is very expensive, but this portal is free. Help to keep this learning portal free by donating or supporting us. We accept donations, grants, sponsorships & support to help reach out to more children. Thank you so much. Click here to donate

Leave a Reply

Your email address will not be published. Required fields are marked *

School Portal NG