Exam 2: Accounting Databases

To answer the following questions, refer to the database below. -Separating the database into related tables instead of using just one large table helps to eliminate

To answer the following questions, refer to the database below. -When a database has been normalized, which of the following is true?

Use the database table below to answer the following questions. -What are the three types of database anomalies? Define each type.

In a database accounting system, the following is true EXCEPT

Use the database table below to answer the following questions. -An audit of customer records in the accounting database reveals data in the state field was entered inconsistently. Some customers' states were entered using the two letter abbreviation (MO, CA, or IA)and others were spelled out (Missouri, California, or Iowa). Which database integrity rule is NOT being followed? What type of controls can be implemented to prevent this in the future?

Use the database table below to answer the following questions. -You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database.

To maintain primary key integrity, a relational database designer will not allow a primary key to have a null (empty)value.

Use the database table below to answer the following questions. -What suggestions would you give the database designer? How should the database be created to eliminate the database anomalies? (Be specific.)

To answer the following questions, refer to the database below. -The Vendor Orders table contains the following database anomalies EXCEPT

Use the database table below to answer the following questions. -What is primary key integrity? What happens when a database does NOT have or enforce primary key integrity?

Referential integrity ensures data is consistent throughout the database.

To answer the following questions, refer to the database below. -Normalization is an optimization process that minimizes which of the following?

To answer the following questions, refer to the database below. -The following statements regarding the Vendor Orders table above are true EXCEPT

Intersection tables do not remove duplicate records from tables that have a many-to-many relationships.

The bookkeeper at the retail store Cycle Bikes enters adjusting entries using an onscreen journal. This indicates that Cycle Bikes has a manual accounting system.

Database anomalies can be removed by the process of ________.

To answer the following questions, refer to the database below. -When requiring a user to select from a list to enter data, such as the state in an address, the database is conforming to which database integrity rule?

To answer the following questions, refer to the database below. -Which database integrity rule ensures each record may be retrieved from the database using a unique identifier?

To answer the following questions, refer to the database below. -To add a vendor to the Vendor Orders table, the following information is required EXCEPT

Use the database table below to answer the following questions. -What is referential integrity? What happens when a database does NOT have or enforce referential integrity?