Relational Databases.

IMPORTANT: These notes are placed on these web pages solely for the benefit of the students at the State University of New York at Albany, and therefore, are to be used in the context of the course (Acc681 Accounting Information Systems) for which they are intended.

[6.1.Database Management Systems (Basics)] [6.2. Data Normalisation] [6.3. References]

Simplicity does not precede complexity, but follows it.

Alan Perlis

A picture is worth 10K words - but only those to describe the picture. Hardly any sets of 10K words can be adequately described with pictures.

Alan Perlis

Fools ignore complexity. Pragmatists suffer it. Some can avoid it. Geniuses remove it.

Alan Perlis

It goes against the grain of modern education to teach children to program. What fun is there in making plans, acquiring discipline in organizing thoughts, devoting attention to detail and learning to be self-critical?

Alan Perlis


6.1. Data Base Management Systems

In the traditional file based accounting information systems, the various accounting applications (such as billing, accounts payable, accounts receivable, payroll, general ledger, etc,) own their own data. This data ownership has many drawbacks:

The figure below illustrates a typical traditional file based system.

In database oriented systems, on the other hand, the ownership relationship between applications and data is absent, and therefore data can be shared by various applications/users. Data Base Management System (DBMS) is the software for implementation of databases.

The figure below illustrates the architecture of a database system.

Return to Contents

6.2. Data Normalization

NOTE: Read the section below in conjunction with Ch.4 of the Roman text.


Return to Contents

6.3. References

Return to Contents

Updated on October 6, 1997 by