Question 1

List the rules regarding where the foreign key should be placed EACH OF the following relationships: one-to-one, one-to-many, many-to-many.

Accepted Answer

The answer of List the rules regarding where the foreign...

Question 2

Which of the following relationships is asymmetrical in terms of how one record in the first table is related to one or more records in the second table and how one record in the second table is related to one or more records in the first table?

Accepted Answer

A)  One-to-one relationship 
B)  One-to-many relationship 
C)  Many-to-many relationship 
D)  B and C, but not A

Question 3

Schemas exist at the external and conceptual levels, but not at the internal level.

Accepted Answer

A) True 
 B)False

Question 4

What is a concatenated (or compound or composite) key?

Accepted Answer

The answer of What is a concatenated (or compound or...

Question 5

What is a foreign key?

Accepted Answer

A)  It is a nonkey data element that depends on another nonkey data element. 
B)  It is a data element that uniquely identifies a record. 
C)  It is the primary key of a table that is placed in another table so the tables can be joined. 
D)  A and B, but not C

Question 6

Which of the following are disadvantages of a database?

Accepted Answer

A)  Increased hardware requirements, required technical skills, and integrated data 
B)  Increased hardware requirements, vulnerability to system failure, and integrated data 
C)  Required technical skills, difficult conversion from conventional files, and high- quality and efficient data 
D)  Increased hardware requirements, required technical skills, and difficult conversion from conventional files

Question 7

Identify the types of relationships that can exist between tables in a database.

Accepted Answer

The answer of Identify the types of relationships that can...

Question 8

Define the two database models discussed in the chapter.

Accepted Answer

The answer of Define the two database models discussed in...

Question 9

Which of the following statements about the internal level of a database is true?

Accepted Answer

A)  It is the physical implementation of the conceptual level. 
B)  It includes the file organizations to store data on the physical storage devices. 
C)  It is the way all the data in the entire database are viewed logically. 
D)  A and B, but not C 
E)  B and C, but not A D

Question 10

What are the three ways in which a user can interface with a database management system?

Accepted Answer

The answer of What are the three ways in which...

Question 11

What is meant by the "logical" structure of a database?

Accepted Answer

A)  The way the data are thought about, or viewed, by users 
B)  The way the data are stored on storage devices 
C)  The internal level of a database 
D)  The conceptual and internal levels of a database

Question 12

What is the operation that materializes the relationship between tables?

Accepted Answer

A)  Union 
B)  Insertion 
C)  Projection 
D)  Join

Question 13

The database architecture includes an external level, which is the physical implementation of the conceptual level.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements best describes mapping in a database?

Accepted Answer

A)  Mapping is the process of implementing the conceptual relationship in a database. 
B)  Mapping defines the relationship among the three levels of a database. 
C)  Mapping is the process of making a data element in one schema correspond to an element in another schema. 
D)  Mapping is the process of implementing a particular application as requested by the users.

Question 15

A framework that is helpful for discussing different aspects of a database is its architecture.

Accepted Answer

A) True 
 B)False

Question 16

Where does mapping occur?

Accepted Answer

A)  Between the external and conceptual levels 
B)  Between the external and internal levels 
C)  Between the conceptual and internal levels 
D)  A and C 
E)  B and C D

Question 17

What are the subroutines called that define the external and conceptual schema in a database management system?

Accepted Answer

A)  Application programs 
B)  Data definition language 
C)  Query language 
D)  Business rules

Question 18

A query language is a high-level English-like language that enables users to make ad hoc, spur of the moment, requests from a computer.

Accepted Answer

A) True 
 B)False

Question 19

A database system consists of two major components--a database and a database management system.

Accepted Answer

A) True 
 B)False

Question 20

A primary key is one or a group of data elements that uniquely identifies a record.

Accepted Answer

A) True 
 B)False

Exam 12: Database Structure of Accounting Systems

List the rules regarding where the foreign key should be placed EACH OF the following relationships: one-to-one, one-to-many, many-to-many.

Which of the following relationships is asymmetrical in terms of how one record in the first table is related to one or more records in the second table and how one record in the second table is related to one or more records in the first table?

Schemas exist at the external and conceptual levels, but not at the internal level.

What is a concatenated (or compound or composite) key?

What is a foreign key?

Which of the following are disadvantages of a database?

Identify the types of relationships that can exist between tables in a database.

Define the two database models discussed in the chapter.

Which of the following statements about the internal level of a database is true?

What are the three ways in which a user can interface with a database management system?

What is meant by the "logical" structure of a database?

What is the operation that materializes the relationship between tables?

The database architecture includes an external level, which is the physical implementation of the conceptual level.

Which of the following statements best describes mapping in a database?

A framework that is helpful for discussing different aspects of a database is its architecture.

Where does mapping occur?

What are the subroutines called that define the external and conceptual schema in a database management system?

A query language is a high-level English-like language that enables users to make ad hoc, spur of the moment, requests from a computer.

A database system consists of two major components--a database and a database management system.

A primary key is one or a group of data elements that uniquely identifies a record.