Question 1

In an E-R model of a database, this indicates the primary record key:

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 2

This item creates relationships by linking the date in one file (e.g., customer)to an item in a second file (e.g., a sales order:

Accepted Answer

A) Foreign key 
B) Data dictionary 
C) Relationships link bit 
D) Index file 
A) Foreign key 
B) Data dictionary 
C) Relationships link bit 
D) Index file

Question 3

Databases cannot store more than one value in the same data field of the same record.

Accepted Answer

A) True 
 B)False

Question 4

A major advantage of relational databases is:

Accepted Answer

A) All records are stored together 
B) No pointers are used 
C) The ability to add tables and relationships after the database becomes operational 
D) It closely resembles a flat file 
A) All records are stored together 
B) No pointers are used 
C) The ability to add tables and relationships after the database becomes operational 
D) It closely resembles a flat file

Question 5

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 6

A database is in third normal form if it is second normal form and:

Accepted Answer

A) It contains no data redundancies 
B) It contains no foreign keys 
C) It contains no transitive dependencies 
D) all of these 
A) It contains no data redundancies 
B) It contains no foreign keys 
C) It contains no transitive dependencies 
D) all of these

Question 7

The REA accounting framework is most closely associated with which of the following?

Accepted Answer

A) SQL 
B) An enterprise-wide view of accounting processes 
C) Normalization of accounting data for recording and query purposes 
D) An example of a data manipulation language 
A) SQL 
B) An enterprise-wide view of accounting processes 
C) Normalization of accounting data for recording and query purposes 
D) An example of a data manipulation language

Question 8

A flat file is a database with no records.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Assuming that a general a general ledger could have several subsidiary ledgers, the relationship between "general ledger" and "subsidiary ledger" 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 11

All of these are symbols in tE-R model except:

Accepted Answer

A) A Star 
B) Connecting lines 
C) Cardinality symbols 
D) Rectangle 
A) A Star 
B) Connecting lines 
C) Cardinality symbols 
D) Rectangle

Question 12

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) all of these are normal forms 
A) First normal form 
B) Second normal form 
C) Third normal form 
D) all of these are normal forms

Question 13

The basic unit of information in an accounting information system database is the debit.

Accepted Answer

A) True 
 B)False

Question 14

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

Accepted Answer

A) True 
 B)False

Question 15

The letters "E-R" in the term E-R diagram refer to:

Accepted Answer

A) Entity relationship 
B) Economic relationship 
C) Enterprise resource 
D) none of these 
A) Entity relationship 
B) Economic relationship 
C) Enterprise resource 
D) none of these

Question 16

The smallest unit of information in the data hierarchy is a data field.

Accepted Answer

A) True 
 B)False

Question 17

In the REA framework, an account receivable would be classified as a(n):

Accepted Answer

A) Asset 
B) Event 
C) Resource 
D) none of these 
A) Asset 
B) Event 
C) Resource 
D) none of these

Question 18

In the E-R model, an oval denotes a(n):

Accepted Answer

A) A data attribute such as a social security number 
B) One-to-many relationship 
C) "is a" characteristic 
D) Transitive relationship 
A) A data attribute such as a social security number 
B) One-to-many relationship 
C) "is a" characteristic 
D) Transitive relationship

Question 19

The largest unit of information in the data hierarchy is a record.

Accepted Answer

A) True 
 B)False

Question 20

"Reducing data redundancy" is an important goal in data modeling.

Accepted Answer

A) True 
 B)False

In an E-R model of a database, this indicates the primary record key:

This item creates relationships by linking the date in one file (e.g., customer)to an item in a second file (e.g., a sales order:

Databases cannot store more than one value in the same data field of the same record.

A major advantage of relational databases is:

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.

A database is in third normal form if it is second normal form and:

The REA accounting framework is most closely associated with which of the following?

A flat file is a database with no records.

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:

Assuming that a general a general ledger could have several subsidiary ledgers, the relationship between "general ledger" and "subsidiary ledger" would most likely be:

All of these are symbols in tE-R model except:

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

The basic unit of information in an accounting information system database is the debit.

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

The letters "E-R" in the term E-R diagram refer to:

The smallest unit of information in the data hierarchy is a data field.

In the REA framework, an account receivable would be classified as a(n):

In the E-R model, an oval denotes a(n):

The largest unit of information in the data hierarchy is a record.

"Reducing data redundancy" is an important goal in data modeling.

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

In an E-R model of a database, this indicates the primary record key:

This item creates relationships by linking the date in one file (e.g., customer)to an item in a second file (e.g., a sales order:

Databases cannot store more than one value in the same data field of the same record.

A major advantage of relational databases is:

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.

A database is in third normal form if it is second normal form and:

The REA accounting framework is most closely associated with which of the following?

A flat file is a database with no records.

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:

Assuming that a general a general ledger could have several subsidiary ledgers, the relationship between "general ledger" and "subsidiary ledger" would most likely be:

All of these are symbols in tE-R model except:

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

The basic unit of information in an accounting information system database is the debit.

Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating "normal data."

The letters "E-R" in the term E-R diagram refer to:

The smallest unit of information in the data hierarchy is a data field.

In the REA framework, an account receivable would be classified as a(n):

In the E-R model, an oval denotes a(n):

The largest unit of information in the data hierarchy is a record.

"Reducing data redundancy" is an important goal in data modeling.

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