The content is just an excerpt from the complete note for SS3 First Term Computer Studies Lesson Note – Database. Check below to download the complete DOCUMENT
WEEK 8.
TOPIC: DATABASE
CONTENT:
- Definition (i)Database (ii)Database package (DBMS)
- Example of DBMS: Dbase III, Dbase IV, Fox base, Rbase, etc.
- Basic terminologies: (i) File (ii) Record (iii) Field (iv) Key
- Forms of database organization (i) network (ii) hierarchical (iii) relational.
Sub-topic 1: Definition
A database is a collection of information. It is defined as a single organized collection of data stored with a minimal duplication of data items so as to provide a consistent and control pool of data common to all users.
Database Management System (DBMS): it is complex software that can be used to create, store, update, manage, and maintain database. It consists of a collection of interrelated data and a set of programs to access these data. Its primary goal is to provide a convenient and effective environment in retrieving and storing database information. Examples of DBMS includes: Microsoft Access, Oracle, Foxbase. dBase III+, dBaseIV, Rbase, MySQL and so on.
Basic terminologies
A field is a column (a space used to store data in a table) of data in a table. Each column or field in a table contains similar types of data (e.g. data on the ages of students) for all members/entities whose data is stored in the table.
Records refer to a row of data in a table. Each row or record in a table contains similar types of data (e.g., data on the ages of students) for all members/entities whose data is stored in the table. It is the collection of related fields in a database.
File is a collection or a group of related records. E.g., students’ file, employers’ file etc.
Primary Key is the identifier for a record in a table.
To gain full access to the note: DOWNLOAD FILE