Share
Explore BrainMass

Database system and effective internal control system

Discuss how database systems along with their characteristics (such as referential integrity -- but there are others) can help companies have an effective internal control system. Gives the three database characteristics and explains them. Describes what a database should be.

Solution Preview

Database system and effective internal control system

Discuss how database systems along with their characteristics (such as referential integrity but there are others) can help companies have an effective internal control system.

There are three database characteristics - entity integrity, domain integrity, and referential integrity - that help companies have effective internal control systems. To explain how this is done, let's take a look at each one.

1) Entity Integrity is a rule that every table must have a primary key (like a customer number, social security number, etc...) and that key is unique but never equal to zero. With this rule - duplicate rows are prevented in the table. This is similar to saying that the primary column starts with the number 1 into infinity and each line will be unique. Within the database, the system does not allow inserts or updates so that no invalid primary ...

Solution Summary

Discuss how database systems along with their characteristics (such as referential integrity -- but there are others) can help companies have an effective internal control system. Gives the three database characteristics and explains them. Describes what a database should be.

$2.19