Categories: Lesson Notes

JSS3 First Term Internet and Communication Technology (ICT) Lesson Note – Database

The content is just an excerpt from the complete note for JSS3 First Term Internet and Communication Technology (ICT) Lesson Note – Database. Check below to download the complete DOCUMENT

WEEK 8                                                                                

TOPIC:          DATABASE

CONTENT

  • Definition of Database
  • Database Terminologies

Sub-Topic 1: Definition of Database

A database is a collection of related data about a particular subject that is organized in a way that it can be easily stored, accessed, managed, and updated to meet a particular goal.

It is always set up for a special purpose like students’ records, inventory, address book etc. This database has a particular software that could be used to perform the above functions e.g. Paradox, MS Access, Dbase etc.

A database is composed of several tables.

You need to create separate tables to store different types of data. For example, if you have a School Management Software, you may need to create the following tables:

  • Students – to store list of all students
  • Educators – to create list of all educators.
  • Address – to store the addresses of students and educators.
  • Grades – to store the mark scores of all students.

A Table is a single store of related information. A table consists of records, and each record is made up of a number of fields.

You can think of the phone book as a table: It contains a record for each telephone subscriber, and each subscriber’s details are contained in three fields – name, address and telephone.

A database package is a piece of software that enables you to organise and store related data together, so that specific pieces of information can be retrieved easily and quickly.

Access is a database program, created by Microsoft Office 2007

To gain full access to the note: DOWNLOAD FILE

Sunday

Share
Published by
Sunday

Recent Posts

List of Universities Offering Veterinary Medicine in Nigeria

Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…

2 months ago

List of Universities Offering Anthropology in Nigeria

Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…

2 months ago

List of Universities Offering Sociology in Nigeria

Sociology is the scientific study of human society, culture, and behavior. It examines the social…

2 months ago

List of Universities Offering Social Work in Nigeria

Social Work is a profession dedicated to helping individuals, families, and communities to cope with…

2 months ago

List of Universities Offering Religious Studies in Nigeria

Religious studies is an academic discipline that explores the beliefs, practices, and history of various…

2 months ago

List of Universities Offering Public Administration in Nigeria

Public administration is the field of study and practice that focuses on the organization and…

2 months ago