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
