Question 1

Explain the types of attributes that tables possess in a relational database.

Accepted Answer

Primary key - the attribute,or combinati

Question 2

________ in a well-structured relational database.

Accepted Answer

A) Every table must be related to all other tables 
B) One table must be related to at least one other table 
C) Every table must be related to at least one other table 
D) One table must be related to all other tables 
A) Every table must be related to all other tables 
B) One table must be related to at least one other table 
C) Every table must be related to at least one other table 
D) One table must be related to all other tables

Question 3

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

The schema that provides an organization-wide view of the entire database is known as the

Accepted Answer

A) external-level schema. 
B) internal-level schema. 
C) conceptual-level schema. 
D) logical view of the database. 
A) external-level schema. 
B) internal-level schema. 
C) conceptual-level schema. 
D) logical view of the database.

Question 5

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the same production files have been saved and stored independently on several databases,she recommends that they be stored only once.Implementation of her recommendation would benefit the company by contributing to

Accepted Answer

A) data independence. 
B) data integration. 
C) reduce data redundancy. 
D) increase data sharing. 
A) data independence. 
B) data integration. 
C) reduce data redundancy. 
D) increase data sharing.

Question 6

What acts as an interface between the database and the various application programs?

Accepted Answer

A) data warehouse 
B) database administrator 
C) database system 
D) database management system 
A) data warehouse 
B) database administrator 
C) database system 
D) database management system

Question 7

File-oriented approaches create problems for organizations because of

Accepted Answer

A) multiple transaction files. 
B) a lack of sophisticated file maintenance software. 
C) multiple users. 
D) multiple master files. 
A) multiple transaction files. 
B) a lack of sophisticated file maintenance software. 
C) multiple users. 
D) multiple master files.

Question 8

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 9

Databases were originally developed to address which problem?

Accepted Answer

A) to replace the double entry-system 
B) to address the proliferation of master files 
C) to increase the speed that an organization could process transactions 
D) to decrease the costs associated with manual accounting systems 
A) to replace the double entry-system 
B) to address the proliferation of master files 
C) to increase the speed that an organization could process transactions 
D) to decrease the costs associated with manual accounting systems

Question 10

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 11

Pat Owen is chair of the National Grizzly Society,which maintains a database of all grizzly bears within the United States.One table will store the name,birth date,and other characteristics of all of the grizzly bears that have been registered.Each grizzly bear is uniquely identified by a registration number.A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers.The entities described by the second table are

Accepted Answer

A) grizzly bears. 
B) parental relationships. 
C) registration numbers. 
D) names. 
A) grizzly bears. 
B) parental relationships. 
C) registration numbers. 
D) names.

Question 12

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 13

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 14

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.You begin development of the relational database that will form the core of the AIS by envisioning the record stored in a single table with a column that represents each attribute.You then begin to break this table down into smaller tables.This process is called

Accepted Answer

A) integration. 
B) optimization. 
C) minimization. 
D) normalization. 
A) integration. 
B) optimization. 
C) minimization. 
D) normalization.

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Pat Owen is chair of the National Grizzly Society,which maintains a database of all grizzly bears within the United States.One table will store the name,birth date,and other characteristics of all of the grizzly bears that have been registered.Each grizzly bear is uniquely identified by a registration number.A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers.The primary key in the first table is

Accepted Answer

A) name. 
B) birth date. 
C) the primary key in the second table. 
D) a foreign key in the second table. 
A) name. 
B) birth date. 
C) the primary key in the second table. 
D) a foreign key in the second table.

Question 18

A fully normalized database is called

Accepted Answer

A) first normal form (1NF). 
B) second normal form (2NF). 
C) third normal form (3NF). 
D) forth normal form (4NF). 
A) first normal form (1NF). 
B) second normal form (2NF). 
C) third normal form (3NF). 
D) forth normal form (4NF).

Question 19

In the Inventory table above,"Item number" 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 20

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.

Explain the types of attributes that tables possess in a relational database.

________ in a well-structured relational database.

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

The schema that provides an organization-wide view of the entire database is known as the

What acts as an interface between the database and the various application programs?

File-oriented approaches create problems for organizations because of

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

Databases were originally developed to address which problem?

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

The ________ is responsible for the database.

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

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

A fully normalized database is called

In the Inventory table above,"Item number" is best described as

A data warehouse

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

Explain the types of attributes that tables possess in a relational database.

________ in a well-structured relational database.

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

The schema that provides an organization-wide view of the entire database is known as the

What acts as an interface between the database and the various application programs?

File-oriented approaches create problems for organizations because of

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

Databases were originally developed to address which problem?

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

The ________ is responsible for the database.

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

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

A fully normalized database is called

In the Inventory table above,"Item number" is best described as

A data warehouse

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