Purchase Solution

Database system and effective internal control system

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Motivation

This tests some key elements of major motivation theories.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.