Question 1

In the Customer table above,"Customer #" 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 2

The logical view of a database system refers to

Accepted Answer

A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program. 
A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program.

Question 3

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 4

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 5

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 6

In a well-structured database,the constraint that ensures the consistency of the data is known as the

Accepted Answer

A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule. 
A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule.

Question 7

In a relational database,requiring that every record in a table have a unique identifier is called the

Accepted Answer

A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule. 
A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule.

Question 8

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) unique primary key rule. 
D) foreign key rule. 
A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule.

Question 9

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.

Question 10

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 11

The physical view of a database system refers to

Accepted Answer

A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program. 
A) how a user or programmer conceptually organizes and understands the data. 
B) how the DBMS accesses data for a certain application program. 
C) how and where the data are physically arranged and stored. 
D) how master files store data values used by more than one application program.

Question 12

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

Accepted Answer

Semantic data modeling takes advantage o

Question 13

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 several key managers do not have access to the production and sales information,she recommends that they should be uploaded to the company's internal network and be made available for search.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 14

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 15

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 16

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 has access to view customer and insurance product information.She also has access that allows her to enter and cancel customer orders.The permissions for Mary (and other sales reps)define a ________ in the company's database management system.

Accepted Answer

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

Question 17

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information

Question 18

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 19

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 20

Describe the reason why it is acceptable to have null foreign key,but it is unacceptable to have a null primary key.Use the concept of entity integrity rule and referential integrity rule in your answer.

Accepted Answer

A primary key cannot uniquely identify a

In the Customer table above,"Customer #" is best described as

The logical view of a database system refers to

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

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

Databases were originally developed to address which problem?

In a well-structured database,the constraint that ensures the consistency of the data is known as the

In a relational database,requiring that every record in a table have a unique identifier 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

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

The physical view of a database system refers to

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

A fully normalized database is called

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

Describe the information that is contained in the data dictionary.

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

Describe the reason why it is acceptable to have null foreign key,but it is unacceptable to have a null primary key.Use the concept of entity integrity rule and referential integrity rule in your answer.

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

In the Customer table above,"Customer #" is best described as

The logical view of a database system refers to

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

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

Databases were originally developed to address which problem?

In a well-structured database,the constraint that ensures the consistency of the data is known as the

In a relational database,requiring that every record in a table have a unique identifier 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

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

The physical view of a database system refers to

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

A fully normalized database is called

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

Describe the information that is contained in the data dictionary.

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

Describe the reason why it is acceptable to have null foreign key,but it is unacceptable to have a null primary key.Use the concept of entity integrity rule and referential integrity rule in your answer.

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