Database I

Computer Science J.S.S 3 Second Term

Sub-theme: Basic knowledge of Information Technology

Week 4

Database I

Performance Objective

Student should be able to:

1. Explain the following database terminologies :

(I) Field

(Ii) Record

(Iii) File

(Iv) Key

Content

Computer science, data that has several parts, known as a record, can be divided into fields. Relational databases arrange data as sets of database records, so-called rows. Each record consists of several fields; the fields of all records form the columns. Examples of fields: name, gender, hair colour

A software system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems have an option of using the SQL (Structured Query Language) for querying and maintaining the…