Question 1

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 2

Explain the relational database data model.

Accepted Answer

A data model is an abstract representati

Question 3

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

Accepted Answer

Semantic data modeling takes advantage o

Question 4

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Accepted Answer

A) purge 
B) erase 
C) delete 
D) integrity 
A) purge 
B) erase 
C) delete 
D) integrity

Question 5

Discuss redundancy as it applies to database design.

Accepted Answer

Redundancy has been called an enemy of r

Question 6

Mary Lamb is an insurance sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She,and other sales reps,have access to view customer and insurance product information.All sales reps also have access that allows them to enter and cancel customer orders.The permissions for Mary define a ________ in the company's database management system.

Accepted Answer

A) conceptual-level schema 
B) subschema 
C) data dictionary 
D) physical view 
A) conceptual-level schema 
B) subschema 
C) data dictionary 
D) physical view

Question 7

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 8

Describe what you think will be the main impact of database technology in your career.

Accepted Answer

Answers to this question could cover a w

Question 9

Identify the statement below that is false with regards to basic requirements of a relational database model.

Accepted Answer

A) Primary keys can be null. 
B) Foreign keys,if not null,must have values that correspond to the value of a primary key in another table. 
C) All non-key attributes in a table should describe a characteristic about the object identified by the primary key. 
D) Every column in a row must be single-valued. 
A) Primary keys can be null. 
B) Foreign keys,if not null,must have values that correspond to the value of a primary key in another table. 
C) All non-key attributes in a table should describe a characteristic about the object identified by the primary key. 
D) Every column in a row must be single-valued.

Question 10

Describe a data dictionary.

Accepted Answer

A data dictionary is a means by which in

Question 11

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.As you look over her records,you realize that sometimes the same customer is recorded by a slightly different name.For example,Mike Mulligan bought a horse statue,M.Mulligan bought a bear statue,and Mike M.all seem to be the same person.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 12

The update anomaly in non-normalized database tables

Accepted Answer

A) occurs because of data redundancy. 
B) restricts addition of new fields or attributes. 
C) results in records that cannot be updated. 
D) is usually easily detected by users. 
A) occurs because of data redundancy. 
B) restricts addition of new fields or attributes. 
C) results in records that cannot be updated. 
D) is usually easily detected by users.

Question 13

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

Accepted Answer

A) The database contains only one primary key. 
B) The database contains two foreign keys. 
C) The database contains two primary keys. 
D) The database contains only one foreign key. 
A) The database contains only one primary key. 
B) The database contains two foreign keys. 
C) The database contains two primary keys. 
D) The database contains only one foreign key.

Question 14

Tom Wilson is chairman of the Rare Car Club,where he maintains a database of registered rare cars and their history.One table will store the model,make,vehicle identification number,and other characteristics of all of the registered rare cars.Each rare car is uniquely identified by a registration number.A second table will contain data that link each rare car to its most recent estimated fair market value by means of their registration numbers.The entities described by the first table are

Accepted Answer

A) rare cars. 
B) estimated fair market value. 
C) registration numbers. 
D) vehicle identification numbers. 
A) rare cars. 
B) estimated fair market value. 
C) registration numbers. 
D) vehicle identification numbers.

Question 15

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

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The two ways to query a databa

Question 20

What are the basic requirements when logically designing a relational database model?

Accepted Answer

Every row in every table must have a uni

Which statement is true regarding file systems?

Explain the relational database data model.

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Discuss redundancy as it applies to database design.

The ________ contains information about the structure of the database.

Describe what you think will be the main impact of database technology in your career.

Identify the statement below that is false with regards to basic requirements of a relational database model.

Describe a data dictionary.

The update anomaly in non-normalized database tables

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

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

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

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

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

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

What are the basic requirements when logically designing a relational database model?

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

Which statement is true regarding file systems?

Explain the relational database data model.

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Discuss redundancy as it applies to database design.

The ________ contains information about the structure of the database.

Describe what you think will be the main impact of database technology in your career.

Identify the statement below that is false with regards to basic requirements of a relational database model.

Describe a data dictionary.

The update anomaly in non-normalized database tables

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

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

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

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

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

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

What are the basic requirements when logically designing a relational database model?

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