Dbase 3+ Quick Reference Guide (Under Construction)

Introduction

What is a database?

A database is a file arranged in the form of records and fields. Each record has several fields. There are two types of databases:

  • Manual Databases
  • Computer Databases

Examples of databases:

Below is a list of databases. The fields are within brackets

  • A Telephone Directory (Surname, Other names, Address, Town, Phone Number)

  • An Encyclopedia (Word, Definition, See Also)

  • A Dictionary (Word, Gender, Origin, Definition)

  • A School Register (Surname, Other names, Address, Town, Phone Number)

  • A Stock List (Item Number, Cost price, Selling Price, Quantity in Stock)

  • A Report Book (Mathematics, English, French, Science, Total, Average, Rank)

Figure 1 show an example of a telephone directory represented in form of a table. The records form the rows, the fields form the column.

 

Fields

Records

Surname Other Address Phone
Smith John Brisbane 202-4534
Anand Raj New Delhi 805-4329
Thompson Al New York 654-8392
Martin Ronald Paris 543-3402
1
2
3
4

Fig 1.

Database Management Systems (DBMS)

A Database Management systems (DBMS) is a package that allow to create, manage, organise and provide access to computer databases.

Examples of DBMS:

  • Microsoft Access
  • Dbase 3+
  • Visual Dbase for Windows
  • Microsoft FoxPro

DBMS allow you to:

  • Create the database
  • Append new records to the database
  • Edit records
  • Delete records
  • Sort, index the database in a specified order
  • List, browse the records
  • Generate a report to print your data
  • Export your data or import external databases

Dbase 3+

Dbase 3+ is one of the first DBMS that was developed for microcomputers. It was developed in the mid 1980's. It was very popular in these days. Though there are today more popular and advance DBMS packages available such as Microsoft FoxPro, Visual Dbase and Microsoft Access.

It has remained, however, popular in schools where it is one of the main programs students use to make their final exam project.

[ Previous Index Next ]


pages viewed since January 19 2002