Question 1

In the E-R model, this symbol represents a database entity such as a customer:

Accepted Answer

A) Diamond 
B) Rectangle 
C) Arrow 
D) Parallelogram 
A) Diamond 
B) Rectangle 
C) Arrow 
D) Parallelogram

Question 2

A database is in second normal form if all of its records are in first normal form, and a second, duplicate record exists for each of them.

Accepted Answer

A) True 
 B)False

Question 3

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

Accepted Answer

A) True 
 B)False

Question 4

Edit tests that catch data entry errors are examples of:

Accepted Answer

A) Data integrity controls 
B) Transaction controls 
C) Concurrency controls 
D) Privacy controls 
A) Data integrity controls 
B) Transaction controls 
C) Concurrency controls 
D) Privacy controls

Question 5

The letter "M" in the acronym DBMS stands for "maintenance."

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) Resources 
B) Recording 
C) Remembering 
D) Reporting 
A) Resources 
B) Recording 
C) Remembering 
D) Reporting

Question 8

An example of a "one-to-one" relationship is "employee to assigned parking stall."

Accepted Answer

A) True 
 B)False

Question 9

As described in the chapter, all of these are normalization "forms" except:

Accepted Answer

A) First normal form 
B) Second normal form 
C) Third normal form 
D) Transaction form 
A) First normal form 
B) Second normal form 
C) Third normal form 
D) Transaction form

Question 10

Which of these comes closest in structure to that of a hierarchical database?

Accepted Answer

A) Organization chart 
B) List of students and their classes 
C) List of specialty doctors and their patients 
D) A map of a city 
A) Organization chart 
B) List of students and their classes 
C) List of specialty doctors and their patients 
D) A map of a city

Question 11

Controls that require a database to either execute a transaction completely, or not at all, are examples of:

Accepted Answer

A) Data integrity controls 
B) Transaction controls 
C) Concurrency controls 
D) Privacy controls 
A) Data integrity controls 
B) Transaction controls 
C) Concurrency controls 
D) Privacy controls

Question 12

A computer record is used to store all the information about one transaction, but several such records must be used to store the information about one employee, one inventory part, and so forth, on a master file.

Accepted Answer

A) True 
 B)False

Question 13

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

Accepted Answer

A) True 
 B)False

Question 14

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

Accepted Answer

A) True 
 B)False

Question 15

In the REA framework, a database designer should create a ____ for each entity.

Accepted Answer

A) Record 
B) Table 
C) Secondary key 
D) all of these 
A) Record 
B) Table 
C) Secondary key 
D) all of these

Question 16

In the E-R model, the primary record key of a file is indicated by:

Accepted Answer

A) An asterisk 
B) Underlining 
C) Using a square 
D) Printing the term e.g., part number)in italics 
A) An asterisk 
B) Underlining 
C) Using a square 
D) Printing the term e.g., part number)in italics

Question 17

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system, transactions are entered into the system only once.In order to accomplish this Ander's files:

Accepted Answer

A) Must utilize magnetic tape 
B) Must be separated by function e.g., marketing has a set of files, production has a set, etc.) 
C) Must be located in an integrated file located in online storage 
D) Must be updated in a real?time environment 
E) Must be handled in some other manner than described above 
A) Must utilize magnetic tape 
B) Must be separated by function e.g., marketing has a set of files, production has a set, etc.) 
C) Must be located in an integrated file located in online storage 
D) Must be updated in a real?time environment 
E) Must be handled in some other manner than described above

Question 18

The reason why database designers normalize data is:

Accepted Answer

A) To eliminate data errors 
B) To scale data properly 
C) To create backup copies of data 
D) To create efficient database tables 
A) To eliminate data errors 
B) To scale data properly 
C) To create backup copies of data 
D) To create efficient database tables

Question 19

The largest unit of information in an accounting information database is a data field.

Accepted Answer

A) True 
 B)False

Question 20

"Avoiding data redundancy" is one of the important goals in data modelling.

Accepted Answer

A) True 
 B)False

In the E-R model, this symbol represents a database entity such as a customer:

A database is in second normal form if all of its records are in first normal form, and a second, duplicate record exists for each of them.

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

Edit tests that catch data entry errors are examples of:

The letter "M" in the acronym DBMS stands for "maintenance."

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

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

An example of a "one-to-one" relationship is "employee to assigned parking stall."

As described in the chapter, all of these are normalization "forms" except:

Which of these comes closest in structure to that of a hierarchical database?

Controls that require a database to either execute a transaction completely, or not at all, are examples of:

A computer record is used to store all the information about one transaction, but several such records must be used to store the information about one employee, one inventory part, and so forth, on a master file.

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

In the REA framework, a database designer should create a ____ for each entity.

In the E-R model, the primary record key of a file is indicated by:

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system, transactions are entered into the system only once.In order to accomplish this Ander's files:

The reason why database designers normalize data is:

The largest unit of information in an accounting information database is a data field.

"Avoiding data redundancy" is one of the important goals in data modelling.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters

Exam 3: Data Modeling

In the E-R model, this symbol represents a database entity such as a customer:

A database is in second normal form if all of its records are in first normal form, and a second, duplicate record exists for each of them.

An example of a transitive relationship in a medical application is the one between "medical procedure code" and "cost of treatment."

Edit tests that catch data entry errors are examples of:

The letter "M" in the acronym DBMS stands for "maintenance."

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

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

An example of a "one-to-one" relationship is "employee to assigned parking stall."

As described in the chapter, all of these are normalization "forms" except:

Which of these comes closest in structure to that of a hierarchical database?

Controls that require a database to either execute a transaction completely, or not at all, are examples of:

A computer record is used to store all the information about one transaction, but several such records must be used to store the information about one employee, one inventory part, and so forth, on a master file.

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

The initials R-E-A in the REA accounting framework refer to "resources, events, and accounting."

In the REA framework, a database designer should create a ____ for each entity.

In the E-R model, the primary record key of a file is indicated by:

Ander and Company has designed an electronic data processing system utilizing the database systems concept.In this system, transactions are entered into the system only once.In order to accomplish this Ander's files:

The reason why database designers normalize data is:

The largest unit of information in an accounting information database is a data field.

"Avoiding data redundancy" is one of the important goals in data modelling.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Organizing and Manipulating the Data in Databases

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters