9- DATABASES

CHAPTER TWO

DATABASES

2.3. EXAMPLES (TYPES) OF DATABASE

There are various types of databases. The common ones are:

1.            Microsoft Access
2.            Qbase
3.            Mysql

2.4. DATABASE TERMINOLOGIES

Some of the terminologies of databases are:

2.4.1. Fields
2.4.2. Records
2.4.3. File
2.4.4. Primary key
2.4.5. Querying
2.4.6. Report

2.4.1. FIELDS

Fields are parts of the database where a particular information or data is stored. A School register, for example, contains a number of fields: one for your name, one for Sex, one for Age, and Class. In spreadsheets, fields are called cells. Below is a table of a data base showing fields- Name, Sex, Age, Class etc

2.4.2. RECORDS

Records are set of data/information of a person, house, school, sells etc. Records composed of fields, each of which contains one item of/data/information. A set of records constitutes a file. For example, a student record might contain records that have three fields: number field, a name field, sex field, age field and class field.

2.4.3. FILE

A file is part of the database which contained different tables.

2.4.4. PRIMARY KEY

Primary key is like the serial number of the items in a table. Each item most one and only one primary key.

Click to page 8 Page 9 Click to page 10