Question 1

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.E) A) and B)
F) A) and D)

Question 2

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 LanguageE) A) and B)
F) B) and C)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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.E) B) and D)
F) B) and C)

Question 5

Discuss redundancy as it applies to database design.

Accepted Answer

Redundancy has been called an enemy of r...

Question 6

-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.E) C) and D)
F) None of the above

Question 7

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.E) B) and D)
F) A) and D)

Question 8

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.E) B) and C)
F) A) and D)

Question 9

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

Accepted Answer

A)  
B)  
C)  
D)  E) All of the above
F) C) and D)

Question 10

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 miningE) A) and C)
F) A) and D)

Question 11

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

Accepted Answer

A)  0
B)  3
C)  4
D)  5E) A) and C)
F) B) and C)

Question 12

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 LanguageE) B) and C)
F) None of the above

Question 13

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 CE) B) and C)
F) B) and D)

Question 14

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 15

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.E) C) and D)
F) B) and C)

Question 16

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...

Question 17

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.E) All of the above
F) A) and D)

Question 18

The ________ contains information about the structure of the database.

Accepted Answer

A)  data definition language
B)  data dictionary
C)  data warehouse
D)  database management systemE) B) and C)
F) None of the above

Question 19

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.E) B) and C)
F) None of the above

Question 20

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.E) A) and D)
F) B) and C)

Exam 4: Relational Databases

Discuss redundancy as it applies to database design.

Correct Answer
verified
Redundancy has been called an enemy of r...
View Answer

The ________ contains information about the structure of the database.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Which statement is true regarding file systems?

Correct Answer
verified

The data dictionary usually is maintained

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
Inventory table; item ID (primary key),d...
View Answer

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Update anomaly is an improper database o...
View Answer

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?

Correct Answer
verified

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

Correct Answer
verified

Exam 4: Relational Databases

Discuss redundancy as it applies to database design.

Correct AnswerverifiedRedundancy has been called an enemy of r...View AnswerShow Answer

The ________ contains information about the structure of the database.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which statement is true regarding file systems?

Correct AnswerverifiedShow Answer

The data dictionary usually is maintained

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedInventory table; item ID (primary key),d...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedUpdate anomaly is an improper database o...View AnswerShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
Redundancy has been called an enemy of r...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Inventory table; item ID (primary key),d...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Update anomaly is an improper database o...
View Answer

Correct Answer
verified

Correct Answer
verified