Question 1

The abstract representation of the contents of a database is called the

Accepted Answer

A)  logical data model. 
B)  data dictionary. 
C)  physical view. 
D)  schema. 
A)  logical data model. 
B)  data dictionary. 
C)  physical view. 
D)  schema.

Question 2

Shandra Bundawi is a new graduate who has been hired by an old-line,family-owned furniture manufacturing company in the northeast.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

Accepted Answer

A)  independence. 
B)  integration. 
C)  redundancy. 
D)  qualifications. 
A)  independence. 
B)  integration. 
C)  redundancy. 
D)  qualifications.

Question 3

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

Accepted Answer

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

Question 4

Using a file-oriented approach to data and information,data is maintained in

Accepted Answer

A)  a centralized database. 
B)  many interconnected files. 
C)  many separate files. 
D)  a decentralized database. 
A)  a centralized database. 
B)  many interconnected files. 
C)  many separate files. 
D)  a decentralized database.

Question 5

The logical structure of a database is described by the

Accepted Answer

A)  data dictionary. 
B)  schema. 
C)  database management system. 
D)  internal level. 
A)  data dictionary. 
B)  schema. 
C)  database management system. 
D)  internal level.

Question 6

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Accepted Answer

A DBMS will use data definition,data man

Question 7

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

Accepted Answer

Primary key the attribute,or combination

Question 8

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Accepted Answer

A)  data warehouse. 
B)  database administrator. 
C)  database system. 
D)  database manager. 
A)  data warehouse. 
B)  database administrator. 
C)  database system. 
D)  database manager.

Question 9

Scuz Bootes has been doing custom choppers,piercings,and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He has meticulous records of every job he has ever done,carefully handwritten with the customer name and address,a description of the job,and an attached picture of the bike or body part before and after customization.His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work.Business is booming.Consequently,Scuz has hired you to construct an accounting information system,beginning with the historical 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 10

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 11

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers.The primary key in the second table is:

Accepted Answer

A)  name 
B)  registration number 
C)  date of birth 
D)  relationship number 
A)  name 
B)  registration number 
C)  date of birth 
D)  relationship number

Question 12

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 13

Scuz Bootes has been doing custom choppers,piercings,and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He has meticulous records of every job he has ever done,carefully handwritten with the customer name and address,a description of the job,and an attached picture of the bike or body part before and after customization.His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work.Business is booming.Consequently,Scuz has hired you to construct an accounting information system,beginning with the historical records.As you read through the records,you notice that some describe multiple services.For example,Sheila Yasgur (notation: won lottery)got a custom chopper,multiple tattoos,and piercings in undisclosed locations (no pictures.)You realize that,in these cases,a single written record will have to be translated into multiple sales records.This is an example of what type of problem in the existing records?

Accepted Answer

A)  Entity integrity 
B)  Referential integrity 
C)  Update anomaly 
D)  Insert anomaly 
A)  Entity integrity 
B)  Referential integrity 
C)  Update anomaly 
D)  Insert anomaly

Question 14

Which of the following would not be found in a data dictionary entry for a data item?

Accepted Answer

A)  records containing a specific data item 
B)  physical location of the data 
C)  source of the data item 
D)  field type 
A)  records containing a specific data item 
B)  physical location of the data 
C)  source of the data item 
D)  field type

Question 15

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers.The entities described by the first table are:

Accepted Answer

A)  marmosets 
B)  parental relationships 
C)  registration numbers 
D)  names 
A)  marmosets 
B)  parental relationships 
C)  registration numbers 
D)  names

Question 16

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

Accepted Answer

A)  DDL; DML 
B)  DQL; SQL 
C)  DDL; DQL 
D)  DML; DDA 
A)  DDL; DML 
B)  DQL; SQL 
C)  DDL; DQL 
D)  DML; DDA

Question 17

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information

Question 18

Dana Halsey is chair of the Purebred Marmoset Society,which maintains a database of registered purebred marmosets and their breeding history.One table will store the name,birth date,and other characteristics of all of the marmosets that have been registered.Each marmoset is uniquely identified by a registration number.A second table will contain data that link each marmoset 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)  a foreign key in the second table. 
D)  the primary key in the second table. 
A)  name 
B)  birth date 
C)  a foreign key in the second table. 
D)  the primary key in the second table.

Question 19

All of the following are benefits of the database approach except:

Accepted Answer

A)  Data integration and sharing 
B)  Decentralized management of data 
C)  Minimal data redundancy 
D)  Cross-functional analysis and reporting 
A)  Data integration and sharing 
B)  Decentralized management of data 
C)  Minimal data redundancy 
D)  Cross-functional analysis and reporting

Question 20

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Accepted Answer

A)  update anomaly. 
B)  insert anomaly. 
C)  integrity anomaly. 
D)  delete anomaly. 
A)  update anomaly. 
B)  insert anomaly. 
C)  integrity anomaly. 
D)  delete anomaly.

The abstract representation of the contents of a database is called the

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

Using a file-oriented approach to data and information,data is maintained in

The logical structure of a database is described by the

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

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

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Which statement is true regarding file systems?

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

Which of the following would not be found in a data dictionary entry for a data item?

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .

Describe the information that is contained in the data dictionary.

All of the following are benefits of the database approach except:

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Accounting Information Systems: an Overview

Overview of Transaction Processing and Erp Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Information Systems Controls for System Reliability Part 1: Information Security

Information Systems Controls for Systems Reliability Part 2: Confidentiality and Privacy

Information Systems Controls for Systems Reliability Part 3: Processing Integrity and Availability

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

The Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Exam 4: Relational Databases

The abstract representation of the contents of a database is called the

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

Using a file-oriented approach to data and information,data is maintained in

The logical structure of a database is described by the

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

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

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Which statement is true regarding file systems?

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

Which of the following would not be found in a data dictionary entry for a data item?

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

Describe the information that is contained in the data dictionary.

All of the following are benefits of the database approach except:

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Accounting Information Systems: an Overview

Overview of Transaction Processing and Erp Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Information Systems Controls for System Reliability Part 1: Information Security

Information Systems Controls for Systems Reliability Part 2: Confidentiality and Privacy

Information Systems Controls for Systems Reliability Part 3: Processing Integrity and Availability

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

The Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Creating an empty table in a relational database requires use of the ,and populating that table requires the use of .