Databases

A DATABASE is a collection of related information stored in files.

Database software allows you to create a database and retrieve, manipulate, and update the data you store in it.

A FILE is collection of related data organized in records.

Each RECORD contains related facts on a particular subject.

These categories of information about the subject are called FIELDS.

Fields are divided into columns, while records are organized in rows.

Records may be added, changed or deleted.

The type of information in a field could be any of the following:

·        Alphanumeric

·        Numeric

·        Currency

·        Date

·        Memo

Three ways files can be organized:

            1.) Sequentially

            2.) Indexed

            3.) Direct

Advantages to using a database:

·        Reduce record redundancy

·        Improved data integrity

·        Easier reporting

·        Improved data security

·        Reduced development time