Exam 2: Accounting Databases

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

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 tables below to answer the following questions. -Which table's primary key has a composite primary key?

To record information about people in a database, you need to following types of tables except?

What is a composite primary key and what is its purpose?

Match the database table to the appropriate transaction cycle. A)Banking Cycle B)Payroll Cycle C)Financial Cycle D)Sales Cycle E)Purchasing Cycle -General Ledger

Use the database tables below to answer the following questions. -Which field in the TimeSheet table is a foreign key?

To answer the following questions, refer to the database below. -The following statements are part of the process of normalizing this database except

________ databases are databases containing data collected by other organizations.

In which phase of the SDLC is the database documented using entity relationship diagrams?

In a relational database, the database tables should not have any connections to other tables in the database.

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?

In a network database, a parent record can have many child records and each child record can have only one parent record.

The ________ inserts, updates, and deletes data in the database.

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?

Match the database type to the corresponding structure. A)Multiple Tables B)Multiple Parents and Multiple Children C)One Parent and Multiple Children -Network Database

Match the database type to the corresponding structure. A)Multiple Tables B)Multiple Parents and Multiple Children C)One Parent and Multiple Children -Hierarchical Database

The DBMS software drives the database ________.

By using an intersection table, which field can be removed from the TimeSheet table?

A composite primary key consists of two or more foreign keys.