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