Back to Course

JSS3: COMPUTER STUDIES - 1ST TERM

0% Complete
0/0 Steps
  1. Computer Career Oppurtunities | Week 1
    5Topics
    |
    1 Quiz
  2. Computer Viruses I | Week 2
    7Topics
    |
    1 Quiz
  3. Computer Viruses II | Week 3
    7Topics
    |
    1 Quiz
  4. Introduction To The Internet | Week 4
    4Topics
    |
    1 Quiz
  5. Internet Terminologies | Week 5
    4Topics
    |
    1 Quiz
  6. The Concept of Digital Divide | Week 6
    5Topics
    |
    1 Quiz
  7. Database Concept, Definition And Terminologies | Week 7
    4Topics
    |
    1 Quiz
  8. Database II | Week 8
    4Topics
    |
    1 Quiz
  9. Database III | Week 9
    13Topics
    |
    1 Quiz
Lesson Progress
0% Complete

Below are some basic database terminologies;

1. File: This is a collection of related records, for example, students’ files, employee’s files, customer’s files.

2. Table: This is a grouping of related data organized in fields (columns) and records (rows) on a datasheet. Many tables can be stored in a single database.

3. Field: This is a portion of a record, for example, Name, Age, Class, Registration number, etc. It is actually a column on a datasheet, and it defines a data type for a set of values in a table.

4. Record: This is a collection of fields in a database. A record is made up of one or more keys. It actually a row on a datasheet and it is a set of values defined by fields.

5. Primary key: This is a unique identifier for a record.

6. DBMS(Database Management System) This is the software used to maintain a database. Examples are Dbase III, IV, Access, Oracle, etc.

7. DBA (Data Base Administrator) This is a person responsible for the management of a database. He keeps the database up to date.

back-to-top
error: