Question 1

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

Accepted Answer

A) foreign key. 
B) primary key. 
C) relational key. 
D) linkage key. 
A) foreign key. 
B) primary key. 
C) relational key. 
D) linkage key.

Question 2

What are the two ways to query a database using Microsoft Access?

Accepted Answer

The two ways to query a databa

Question 3

A data warehouse

Accepted Answer

A) is primarily used for analysis rather than transaction processing. 
B) stores transaction processing records in hard copy. 
C) replaces traditional transaction processing databases. 
D) increases the speed of transaction processing. 
A) is primarily used for analysis rather than transaction processing. 
B) stores transaction processing records in hard copy. 
C) replaces traditional transaction processing databases. 
D) increases the speed of transaction processing.

Question 4

The logical structure of a database is described by the

Accepted Answer

A) data dictionary. 
B) schema. 
C) database management system. 
D) context diagram. 
A) data dictionary. 
B) schema. 
C) database management system. 
D) context diagram.

Question 5

Which of the statements below is incorrect?

Accepted Answer

A) Semantic data modeling facilitates the efficient design of databases. 
B) Semantic data modeling facilitates communicating with the intended users of the system. 
C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D) Semantic data modeling follows the rules of normalization in the design of a database. 
A) Semantic data modeling facilitates the efficient design of databases. 
B) Semantic data modeling facilitates communicating with the intended users of the system. 
C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. 
D) Semantic data modeling follows the rules of normalization in the design of a database.

Question 6

Seacrest Bedding is changing 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 a sales transaction.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

Customer table; ID (primary key),name,st

Question 7

The use of a data warehouse in strategic decision making is often referred to as

Accepted Answer

A) business intelligence. 
B) managerial accounting. 
C) data analysis. 
D) analytical modeling. 
A) business intelligence. 
B) managerial accounting. 
C) data analysis. 
D) analytical modeling.

Question 8

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

Accepted Answer

A) normalization. 
B) decentralization. 
C) geometric data modeling. 
D) semantic data modeling. 
A) normalization. 
B) decentralization. 
C) geometric data modeling. 
D) semantic data modeling.

Question 9

Describe a major advantage of database systems over file-oriented transaction processing systems.

Accepted Answer

Database systems separate logical and ph

Question 10

List the four DBMS "languages" and describe who uses each and for what purpose.

Accepted Answer

DDL is the data definition language used

Question 11

Using the database depicted above,"Item #" 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 12

In a well-structured relational database,

Accepted Answer

A) foreign keys cannot be null. 
B) there must be at least two foreign keys. 
C) every column in a row must be single valued. 
D) one table must be related to all other tables. 
A) foreign keys cannot be null. 
B) there must be at least two foreign keys. 
C) every column in a row must be single valued. 
D) one table must be related to all other tables.

Question 13

The document that shows the items stored in a file,including the order and length of the data fields and the type of data stored is called

Accepted Answer

A) a data layout. 
B) a logical layout. 
C) a physical layout. 
D) a record layout. 
A) a data layout. 
B) a logical layout. 
C) a physical layout. 
D) a record layout.

Question 14

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Accepted Answer

In file-oriented approaches,different us

Question 15

Merlin Frodo has been doing custom piercings and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He keeps meticulous records of every job he has ever completed.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Merlin is considering adding scarification to his service offerings and has asked his accountant to identify past customers who might be likely candidates for this service.Merlin wants his accountant to engage in

Accepted Answer

A) customer auditing. 
B) customer resource management. 
C) data mining. 
D) enterprise resource planning. 
A) customer auditing. 
B) customer resource management. 
C) data mining. 
D) enterprise resource planning.

Question 16

Identify one potential outcome of the delete anomaly.

Accepted Answer

A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above 
A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above

Question 17

Describe the differences between the data definition language (DDL),data manipulation language (DML),and the data query language (DQL).

Accepted Answer

The data definition language (DDL)builds

Question 18

Which of the following is false regarding a well-structured relational database?

Accepted Answer

A) A foreign key cannot be null. 
B) A primary key cannot be null. 
C) Every column in a row must be single valued. 
D) All nonkey attributes in a table must describe a characteristic of the object identified by the primary key. 
A) A foreign key cannot be null. 
B) A primary key cannot be null. 
C) Every column in a row must be single valued. 
D) All nonkey attributes in a table must describe a characteristic of the object identified by the primary key.

Question 19

The ________ is responsible for the database.

Accepted Answer

A) database master 
B) database manager 
C) database administrator 
D) data coordinator 
A) database master 
B) database manager 
C) database administrator 
D) data coordinator

Question 20

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Accepted Answer

A schema describes the logical structure

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

What are the two ways to query a database using Microsoft Access?

A data warehouse

The logical structure of a database is described by the

Which of the statements below is incorrect?

The use of a data warehouse in strategic decision making is often referred to as

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

Describe a major advantage of database systems over file-oriented transaction processing systems.

List the four DBMS "languages" and describe who uses each and for what purpose.

Using the database depicted above,"Item #" is best described as

In a well-structured relational database,

The document that shows the items stored in a file,including the order and length of the data fields and the type of data stored is called

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Identify one potential outcome of the delete anomaly.

Describe the differences between the data definition language (DDL),data manipulation language (DML),and the data query language (DQL).

Which of the following is false regarding a well-structured relational database?

The ________ is responsible for the database.

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

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

Exam 4: Relational Databases

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

What are the two ways to query a database using Microsoft Access?

A data warehouse

The logical structure of a database is described by the

Which of the statements below is incorrect?

The use of a data warehouse in strategic decision making is often referred to as

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called

Describe a major advantage of database systems over file-oriented transaction processing systems.

List the four DBMS "languages" and describe who uses each and for what purpose.

Using the database depicted above,"Item #" is best described as

In a well-structured relational database,

The document that shows the items stored in a file,including the order and length of the data fields and the type of data stored is called

Explain the difference between file-oriented transaction processing systems and relational database systems.Discuss the advantages and disadvantages of each system.

Identify one potential outcome of the delete anomaly.

Describe the differences between the data definition language (DDL),data manipulation language (DML),and the data query language (DQL).

Which of the following is false regarding a well-structured relational database?

The ________ is responsible for the database.

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

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