DATABASE DEFINITION AND TERMINOLOGIES
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.
- NEW: Download the entire term's content in MS Word document format (1-year plan only)
- The complete lesson note and evaluation questions for this topic
- The complete lessons for the subject and class (First Term, Second Term & Third Term)
- Media-rich, interactive and gamified content
- End-of-lesson objective questions with detailed explanations to force mastery of content
- Simulated termly preparatory examination questions
- Discussion boards on all lessons and subjects
- Guaranteed learning