Question 1

The data item which uniquely identifies a computer record in an AIS database table is called the:

Accepted Answer

A) Pointer address 
B) Primary record key 
C) Employee number 
D) Header label 
E) Sort field 
A) Pointer address 
B) Primary record key 
C) Employee number 
D) Header label 
E) Sort field

Question 2

A database is in first normal form if all of its record's data fields are well defined and the information can thus be stored as a flat file.

Accepted Answer

A) True 
 B)False

Question 3

Record keys on computer files are unique only to the extent that they classify computer records by some general category.

Accepted Answer

A) True 
 B)False

Question 4

A last name such as "Smith" is an example of a useful primary record key.

Accepted Answer

A) True 
 B)False

Question 5

Within a database context, the relationship between "students" and "classes" would most likely be:

Accepted Answer

A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many 
A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many

Question 6

Database security is no longer important because DBMSs are already so safe.

Accepted Answer

A) True 
 B)False

Question 7

Relational databases store small amounts of data in spreadsheets.

Accepted Answer

A) True 
 B)False

Question 8

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.Which of these items would probably be a foreign key in the customer orders table?

Accepted Answer

A) Order number 
B) Customer name 
C) Salesperson number 
D) all of these 
A) Order number 
B) Customer name 
C) Salesperson number 
D) all of these

Question 9

An example of a transitive dependency in a database is:

Accepted Answer

A) Student ?  grade 
B) Telephone area code ?  phone number 
C) Airline ?  flight number 
D) Parking Code ?  parking fine amount 
A) Student ?  grade 
B) Telephone area code ?  phone number 
C) Airline ?  flight number 
D) Parking Code ?  parking fine amount

Question 10

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

Accepted Answer

A) True 
 B)False

Question 11

In the REA accounting framework, the letter "R" stands for:

Accepted Answer

A) Resources 
B) Recording 
C) Remembering 
D) none of these 
A) Resources 
B) Recording 
C) Remembering 
D) none of these

Question 12

The E-R model refers to the "entity-relationship" model.

Accepted Answer

A) True 
 B)False

Question 13

The term "transaction control" refers to the requirement that a database system either process a transaction entirely, or not at all.

Accepted Answer

A) True 
 B)False

Question 14

The foreign key in one database table will always be a _______ key in a linked table.

Accepted Answer

A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true 
A) Secondary key 
B) Domestic key 
C) Primary key 
D) all of these are always true

Question 15

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their employee number.

Accepted Answer

A) True 
 B)False

Question 16

A data dictionary can help an accountant:

Accepted Answer

A) Prepare tax forms for the IRS 
B) Establish an audit trail 
C) Correct clerical mistakes in transaction data 
D) Perform an audit of the petty cash fund 
A) Prepare tax forms for the IRS 
B) Establish an audit trail 
C) Correct clerical mistakes in transaction data 
D) Perform an audit of the petty cash fund

Question 17

The "concurrency" concern in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

Accepted Answer

A) True 
 B)False

Question 18

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Accepted Answer

A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address
The following data apply to items 110-112.The Oxford Corporation has the following eleven master files:
* Accounts payable * Raw materials inventory
* Accounts receivable * Sales summary
* Bill of materials * Vendor history
* Finished goods inventory * Work in process inventory
* Open production orders * Operations list (labor operations and
* Open purchase orders machine requirements for production) 
A) Inventory number 
B) Assembly code 
C) Vendor code 
D) Assembly pointer address
The following data apply to items 110-112.The Oxford Corporation has the following eleven master files:
* Accounts payable * Raw materials inventory
* Accounts receivable * Sales summary
* Bill of materials * Vendor history
* Finished goods inventory * Work in process inventory
* Open production orders * Operations list (labor operations and
* Open purchase orders machine requirements for production)

Question 19

Within a database context, the relationship between "military officer" and "subordinates" would most likely be:

Accepted Answer

A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many 
A) One-to-one 
B) One-to-many 
C) Many-to-one 
D) Many-to-many

Question 20

In the REA framework, which of these would be recorded as an "event?"

Accepted Answer

A) Hiring a new president of the company 
B) Taking an initial sales order from a customer 
C) Buying a piece of equipment for cash 
D) all of these would be recorded as events 
A) Hiring a new president of the company 
B) Taking an initial sales order from a customer 
C) Buying a piece of equipment for cash 
D) all of these would be recorded as events

The data item which uniquely identifies a computer record in an AIS database table is called the:

A database is in first normal form if all of its record's data fields are well defined and the information can thus be stored as a flat file.

Record keys on computer files are unique only to the extent that they classify computer records by some general category.

A last name such as "Smith" is an example of a useful primary record key.

Within a database context, the relationship between "students" and "classes" would most likely be:

Database security is no longer important because DBMSs are already so safe.

Relational databases store small amounts of data in spreadsheets.

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.Which of these items would probably be a foreign key in the customer orders table?

An example of a transitive dependency in a database is:

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

In the REA accounting framework, the letter "R" stands for:

The E-R model refers to the "entity-relationship" model.

The term "transaction control" refers to the requirement that a database system either process a transaction entirely, or not at all.

The foreign key in one database table will always be a _______ key in a linked table.

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their employee number.

A data dictionary can help an accountant:

The "concurrency" concern in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Within a database context, the relationship between "military officer" and "subordinates" would most likely be:

In the REA framework, which of these would be recorded as an "event?"

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Filters

Exam 14: Database Design

The data item which uniquely identifies a computer record in an AIS database table is called the:

A database is in first normal form if all of its record's data fields are well defined and the information can thus be stored as a flat file.

Record keys on computer files are unique only to the extent that they classify computer records by some general category.

A last name such as "Smith" is an example of a useful primary record key.

Within a database context, the relationship between "students" and "classes" would most likely be:

Database security is no longer important because DBMSs are already so safe.

Relational databases store small amounts of data in spreadsheets.

Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons.Which of these items would probably be a foreign key in the customer orders table?

An example of a transitive dependency in a database is:

An example of a transitive relationship in a parking-tickets application is the one between "ticket code" and "fine amount."

In the REA accounting framework, the letter "R" stands for:

The E-R model refers to the "entity-relationship" model.

The term "transaction control" refers to the requirement that a database system either process a transaction entirely, or not at all.

The foreign key in one database table will always be a _______ key in a linked table.

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their employee number.

A data dictionary can help an accountant:

The "concurrency" concern in database operations refers to the need to convert foreign currency amounts into dollar terms before reporting them to subschema viewers.

An important data field found in a typical computer record of an inventory file that would be vital to purchasing agents would be the inventory item's:

Within a database context, the relationship between "military officer" and "subordinates" would most likely be:

In the REA framework, which of these would be recorded as an "event?"

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Filters