Question 1

Within a database context, the relationship between "assigned parking space" and "car" 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 A

Question 2

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

Accepted Answer

A) True 
 B)False  False

Question 3

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

Accepted Answer

A) Database systems can be used in microcomputers as well as on large computers 
B) Database systems are simple to install and maintain 
C) Database systems are generally less expensive than separate file systems 
D) More duplication of data occurs with a database system 
E) Fewer skilled people are required to run a database system than another system 
A) Database systems can be used in microcomputers as well as on large computers 
B) Database systems are simple to install and maintain 
C) Database systems are generally less expensive than separate file systems 
D) More duplication of data occurs with a database system 
E) Fewer skilled people are required to run a database system than another system A

Question 4

All of these are symbols in the E-R model except:

Accepted Answer

A) Star 
B) Diamond 
C) Oval 
D) Rectangle 
A) Star 
B) Diamond 
C) Oval 
D) Rectangle

Question 5

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 6

This type of database structure enables users to create relationships after the database has been created and implemented:

Accepted Answer

A) Hierarchical 
B) Network 
C) Star 
D) Relational 
A) Hierarchical 
B) Network 
C) Star 
D) Relational

Question 7

Which of the following is not an objective of a computerized database?

Accepted Answer

A) Minimize data redundancy 
B) Make efficient use of storage media 
C) Distribute information to end users 
D) Eliminate the data?gathering responsibilities of some subsystems within the organization 
E) Reduce the decision?making functions of subsystem managers 
A) Minimize data redundancy 
B) Make efficient use of storage media 
C) Distribute information to end users 
D) Eliminate the data?gathering responsibilities of some subsystems within the organization 
E) Reduce the decision?making functions of subsystem managers

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

A data dictionary can help an accountant:

Accepted Answer

A) Prepare tax forms for the CRA 
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 CRA 
B) Establish an audit trail 
C) Correct clerical mistakes in transaction data 
D) Perform an audit of the petty cash fund

Question 10

Within a database context, the relationship between "premier" and "deputy premier" 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

The idea behind view controls is to allow users access to only that information that they need to see.

Accepted Answer

A) True 
 B)False

Question 12

The basic unit of information on a computer file of accounting data is an):

Accepted Answer

A) Inventory part number 
B) Data field 
C) Computer record 
D) Bit 
A) Inventory part number 
B) Data field 
C) Computer record 
D) Bit

Question 13

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 14

Within a database context, 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 15

The data field that distinguishes one record from another in a database table is called the primary key.

Accepted Answer

A) True 
 B)False

Question 16

A foreign key is a data field in the records of one file that references a primary key in the records of another file.

Accepted Answer

A) True 
 B)False

Question 17

In the context of databases, the term data redundancy refers to:

Accepted Answer

A) Storing the same information in several records 
B) Repeating data on multiple reports 
C) Using foreign keys which duplicate the values of primary keys 
D) all of these are possible examples of data redundancy 
A) Storing the same information in several records 
B) Repeating data on multiple reports 
C) Using foreign keys which duplicate the values of primary keys 
D) all of these are possible examples of data redundancy

Question 18

Which of the following creates relationships by linking the data 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 19

The basic unit of information in an accounting information database is a table.

Accepted Answer

A) True 
 B)False

Question 20

An REA accounting system takes an "enterprise-wide view" of accounting data.

Accepted Answer

A) True 
 B)False

Within a database context, the relationship between "assigned parking space" and "car" would most likely be:

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

All of these are symbols in the E-R model except:

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

This type of database structure enables users to create relationships after the database has been created and implemented:

Which of the following is not an objective of a computerized database?

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

A data dictionary can help an accountant:

Within a database context, the relationship between "premier" and "deputy premier" would most likely be:

The idea behind view controls is to allow users access to only that information that they need to see.

The basic unit of information on a computer file of accounting data is an):

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

Within a database context, the relationship between "general ledger" and "subsidiary ledger" would most likely be:

The data field that distinguishes one record from another in a database table is called the primary key.

A foreign key is a data field in the records of one file that references a primary key in the records of another file.

In the context of databases, the term data redundancy refers to:

Which of the following creates relationships by linking the data in one file e.g., customer)to an item in a second file e.g., a sales order)?

The basic unit of information in an accounting information database is a table.

An REA accounting system takes an "enterprise-wide view" of accounting data.

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

Within a database context, the relationship between "assigned parking space" and "car" would most likely be:

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

In recent years many businesses have formed a common information source within their business organization called a database.One of the advantages of building databases is the simultaneous updating of files with common data elements.Another major advantage of the database concept is that:

All of these are symbols in the E-R model except:

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

This type of database structure enables users to create relationships after the database has been created and implemented:

Which of the following is not an objective of a computerized database?

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

A data dictionary can help an accountant:

Within a database context, the relationship between "premier" and "deputy premier" would most likely be:

The idea behind view controls is to allow users access to only that information that they need to see.

The basic unit of information on a computer file of accounting data is an):

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

Within a database context, the relationship between "general ledger" and "subsidiary ledger" would most likely be:

The data field that distinguishes one record from another in a database table is called the primary key.

A foreign key is a data field in the records of one file that references a primary key in the records of another file.

In the context of databases, the term data redundancy refers to:

Which of the following creates relationships by linking the data in one file e.g., customer)to an item in a second file e.g., a sales order)?

The basic unit of information in an accounting information database is a table.

An REA accounting system takes an "enterprise-wide view" of accounting data.

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