Question 1

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

Accepted Answer

DDL is the data definition language used

Question 2

The data on this sales invoice would be generated from how many well-structured tables in a well-designed relational database?

Accepted Answer

A)  6 
B)  5 
C)  4 
D)  7 
A)  6 
B)  5 
C)  4 
D)  7

Question 3

What is the difference in logical view and physical view?

Accepted Answer

The logical view is how the user or prog

Question 4

Chelsana Washington is a medical equipment 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 the other sales reps,have access to view customer and product information.They have access that allows them to enter and cancel customer orders.The permissions for the sales reps define a(an)________ in the company's database management system.

Accepted Answer

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

Question 5

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 customer last names have different first names in different records.For example,R.Framington Farnsworth (custom chopper),Bob Farnsworth (tattoo),and Snake Farnsworth (tattoos and piercings)all seem to be the same person.You explain to Scuz that every customer must be identified by a unique customer number in the AIS.You are referring to the

Accepted Answer

A)  entity integrity rule. 
B)  referential integrity rule. 
C)  update anomaly. 
D)  insert anomaly. 
A)  entity integrity rule. 
B)  referential integrity rule. 
C)  update anomaly. 
D)  insert anomaly.

Question 6

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 7

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)  registration number 
C)  date of birth 
D)  relationship number 
A)  name 
B)  registration number 
C)  date of birth 
D)  relationship number

Question 8

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

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)  birth date 
C)  a combination of primary keys in the first table 
D)  the same as the primary key in the first table 
A)  name 
B)  birth date 
C)  a combination of primary keys in the first table 
D)  the same as the primary key in the first table

Question 10

A set of individual user views of the database is called the

Accepted Answer

A)  conceptual-level schema. 
B)  internal-level schema. 
C)  external-level schema. 
D)  meta-schema. 
A)  conceptual-level schema. 
B)  internal-level schema. 
C)  external-level schema. 
D)  meta-schema.

Question 11

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 customer last names have different first names in different records.For example,R.Framington Farnsworth (custom chopper),Bob Farnsworth (tattoo),and Snake Farnsworth (tattoos and piercings)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 database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Accepted Answer

A)  entity integrity rule. 
B)  referential integrity rule. 
C)  rule of keys. 
D)  foreign key rule. 
A)  entity integrity rule. 
B)  referential integrity rule. 
C)  rule of keys. 
D)  foreign key rule.

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.These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Scuz is considering an expansion of his business into scarification,and has asked his accountant to identify past customers who might be likely candidates for this service.Scuz 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

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A)  Customer Order 
B)  Customer 
C)  Sales 
D)  Sales Order 
A)  Customer Order 
B)  Customer 
C)  Sales 
D)  Sales Order

Question 15

In the database design approach known as normalization,the first assumption made about data is

Accepted Answer

A)  there is no redundancy in the data. 
B)  the delete anomaly will not apply since all customer records will be maintained indefinitely. 
C)  everything is initially stored in one large table. 
D)  the data will not be maintained in 3NF tables. 
A)  there is no redundancy in the data. 
B)  the delete anomaly will not apply since all customer records will be maintained indefinitely. 
C)  everything is initially stored in one large table. 
D)  the data will not be maintained in 3NF tables.

Question 16

In a well-structured relational database,

Accepted Answer

A)  every table must be related to at least one other table. 
B)  every table must be related to all other tables. 
C)  one 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 at least one other table. 
B)  every table must be related to all other tables. 
C)  one table must be related to at least one other table. 
D)  one table must be related to all other tables.

Question 17

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

Question 18

Discuss redundancy as it applies to database design.

Accepted Answer

Redundancy has been called an enemy of r

Question 19

Describe a data dictionary.

Accepted Answer

A data dictionary is a means by which in

Question 20

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

Accepted Answer

A)  Customer number 
B)  Cash receipt date 
C)  Remittance advice number 
D)  Customer check number 
A)  Customer number 
B)  Cash receipt date 
C)  Remittance advice number 
D)  Customer check number

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

The data on this sales invoice would be generated from how many well-structured tables in a well-designed relational database?

What is the difference in logical view and physical view?

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

A set of individual user views of the database is called the

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

In the database design approach known as normalization,the first assumption made about data is

In a well-structured relational database,

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

Discuss redundancy as it applies to database design.

Describe a data dictionary.

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

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

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

The data on this sales invoice would be generated from how many well-structured tables in a well-designed relational database?

What is the difference in logical view and physical view?

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

A set of individual user views of the database is called the

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

In the database design approach known as normalization,the first assumption made about data is

In a well-structured relational database,

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

Discuss redundancy as it applies to database design.

Describe a data dictionary.

In a well-designed and normalized database,which of the following attributes would be a foreign key in a cash receipts table?

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