Question 1

Data dictionary can be used as part of the audit trail.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A) Quantity would be generated from the Sales table. 
B) 34567 would be a primary key in the Sales table. 
C) Unit Price would be generated from the Inventory table. 
D) Hardware City is an example of a non-key data value in the Customer table. 
A) Quantity would be generated from the Sales table. 
B) 34567 would be a primary key in the Sales table. 
C) Unit Price would be generated from the Inventory table. 
D) Hardware City is an example of a non-key data value in the Customer table.

Question 3

Identify one potential drawback in the design and implementation of database systems for accounting.

Accepted Answer

A) Double-entry accounting relies on redundancy as part of the accounting process, but well-designed database systems reduce and attempt to eliminate redundancy. 
B) Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. 
C) Relational DBMS provide the capability of integrating financial and operational data. 
D) Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs. 
A) Double-entry accounting relies on redundancy as part of the accounting process, but well-designed database systems reduce and attempt to eliminate redundancy. 
B) Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. 
C) Relational DBMS provide the capability of integrating financial and operational data. 
D) Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs.

Question 4

Which one of the following results corresponds to the query below?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 5

Which statement is true regarding file systems?

Accepted Answer

A) Transaction files are similar to ledgers in a manual AIS. 
B) Multiple master files create problems with data consistency. 
C) Transaction files are permanent. 
D) Individual records are never deleted in a master file. 
A) Transaction files are similar to ledgers in a manual AIS. 
B) Multiple master files create problems with data consistency. 
C) Transaction files are permanent. 
D) Individual records are never deleted in a master file.

Question 6

Discuss redundancy as it applies to database design.

Accepted Answer

Redundancy has been called an enemy of r

Question 7

The data dictionary usually is maintained

Accepted Answer

A) automatically by the DBMS. 
B) by the database administrator. 
C) by the database programmers. 
D) by top management. 
A) automatically by the DBMS. 
B) by the database administrator. 
C) by the database programmers. 
D) by top management.

Question 8

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema. 
A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema.

Question 9

Using the database depicted above,"Unit Price" is best described as

Accepted Answer

A) an attribute. 
B) a primary key. 
C) a foreign key. 
D) A, B, and C 
A) an attribute. 
B) a primary key. 
C) a foreign key. 
D) A, B, and C

Question 10

Which statement below concerning the database management system (DBMS)is false?

Accepted Answer

A) The DBMS automatically creates application software for users, based on data dictionary parameters. 
B) The DBMS automatically maintains the data dictionary. 
C) Users' requests for information are transmitted to the DBMS through application software. 
D) The DBMS uses special languages to perform specific functions. 
A) The DBMS automatically creates application software for users, based on data dictionary parameters. 
B) The DBMS automatically maintains the data dictionary. 
C) Users' requests for information are transmitted to the DBMS through application software. 
D) The DBMS uses special languages to perform specific functions.

Question 11

Mara Kay is a system analyst for a national department store.She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions.What technique would Mara most likely use?

Accepted Answer

A) Customer auditing 
B) Customer resource management 
C) Data exploring 
D) Data mining 
A) Customer auditing 
B) Customer resource management 
C) Data exploring 
D) Data mining

Question 12

Which is probably the most immediate and significant effect of database technology on accounting?

Accepted Answer

A) Replacement of the double entry-system. 
B) Change in the nature of financial reporting. 
C) Elimination of traditional records such as journals and ledgers. 
D) Quicker access to and greater use of accounting information in decision-making. 
A) Replacement of the double entry-system. 
B) Change in the nature of financial reporting. 
C) Elimination of traditional records such as journals and ledgers. 
D) Quicker access to and greater use of accounting information in decision-making.

Question 13

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Accepted Answer

A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language 
A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language

Question 14

The ________ contains information about the structure of the database.

Accepted Answer

A) data definition language 
B) data dictionary 
C) data warehouse 
D) database management system 
A) data definition language 
B) data dictionary 
C) data warehouse 
D) database management system

Question 15

Kitchen World is changing its inventory system from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for Kitchen World's inventory.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

Accepted Answer

Inventory table; item ID (primary key),d

Question 16

Using the database depicted above,how many foreign keys are in the database?

Accepted Answer

A) 0 
B) 3 
C) 4 
D) 5 
A) 0 
B) 3 
C) 4 
D) 5

Question 17

Identify the aspect of a well-structured database that is incorrect.

Accepted Answer

A) Data is consistent. 
B) Redundancy is minimized and controlled. 
C) All data is stored in one table or relation. 
D) The primary key of any row in a relation cannot be null. 
A) Data is consistent. 
B) Redundancy is minimized and controlled. 
C) All data is stored in one table or relation. 
D) The primary key of any row in a relation cannot be null.

Question 18

When the human resources manager wants to add a new employee to the sales department,the manager would use which language?

Accepted Answer

A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language 
A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language

Question 19

-Using the database depicted above,"Date" is best described as

Accepted Answer

A) a primary key. 
B) a foreign key. 
C) a non-key attribute. 
D) an attribute. 
A) a primary key. 
B) a foreign key. 
C) a non-key attribute. 
D) an attribute.

Question 20

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Accepted Answer

Update anomaly is an improper database o

Exam 4: Relational Databases

Data dictionary can be used as part of the audit trail.

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

Identify one potential drawback in the design and implementation of database systems for accounting.

Which one of the following results corresponds to the query below?

Which statement is true regarding file systems?

Discuss redundancy as it applies to database design.

The data dictionary usually is maintained

A low-level view of the database that describes how the data are actually stored and accessed is the

Using the database depicted above,"Unit Price" is best described as

Which statement below concerning the database management system (DBMS)is false?

Mara Kay is a system analyst for a national department store.She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions.What technique would Mara most likely use?

Which is probably the most immediate and significant effect of database technology on accounting?

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

The ________ contains information about the structure of the database.

Using the database depicted above,how many foreign keys are in the database?

Identify the aspect of a well-structured database that is incorrect.

When the human resources manager wants to add a new employee to the sales department,the manager would use which language?

-Using the database depicted above,"Date" is best described as

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters