Explore BrainMass

Explore BrainMass

    Database system and effective internal control system

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 1:10 am ad1c9bdddf
    https://brainmass.com/business/internal-controls/database-system-and-effective-internal-control-system-383189

    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

    ADVERTISEMENT