SS3 First Term Computer Studies Lesson Note – Database

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