Question 1

In two-tier database architectures, little functionality needs to be programmed into the client application.

Accepted Answer

A) True 
 B)False

Question 2

E. F. Codd developed the relational model in the:

Accepted Answer

A)  1960s. 
B)  1970s. 
C)  1980s. 
D)  1990s. 
A)  1960s. 
B)  1970s. 
C)  1980s. 
D)  1990s.

Question 3

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

Accepted Answer

A) True 
 B)False

Question 4

Discuss some of the disadvantages of file processing systems.

Accepted Answer

File processing systems have several dis

Question 5

A data warehouse contains summarized and historical information.

Accepted Answer

A) True 
 B)False

Question 6

Database development begins with the design of the database.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

Accepted Answer

A)  enterprise view 
B)  reporting document 
C)  user view 
D)  user snapshot 
A)  enterprise view 
B)  reporting document 
C)  user view 
D)  user snapshot

Question 8

________ are established between entities in a well-structured database so that the desired information can be retrieved.

Accepted Answer

A)  Entities 
B)  Relationships 
C)  Lines 
D)  Ties 
A)  Entities 
B)  Relationships 
C)  Lines 
D)  Ties

Question 9

A data model is a graphical system used to capture the nature and relationships among data.

Accepted Answer

A) True 
 B)False

Question 10

The steps of the systems development life cycle can only be viewed as a linear process.

Accepted Answer

A) True 
 B)False

Question 11

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

Accepted Answer

A) True 
 B)False

Question 12

The user interface includes languages, menus, and other facilities by which users interact with various system components.

Accepted Answer

A) True 
 B)False

Question 13

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

Accepted Answer

A) True 
 B)False

Question 14

A relatively small team of people who collaborate on the same project is called a:

Accepted Answer

A)  server group. 
B)  workgroup. 
C)  data collaborative. 
D)  typical arrangement. 
A)  server group. 
B)  workgroup. 
C)  data collaborative. 
D)  typical arrangement.

Question 15

A graphical system used to capture the nature and relationships among data is called a(n):

Accepted Answer

A)  XML data model. 
B)  hypertext graphic. 
C)  relational database 
D)  data model. 
A)  XML data model. 
B)  hypertext graphic. 
C)  relational database 
D)  data model.

Question 16

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

Accepted Answer

A)  Programmers 
B)  Users 
C)  Systems analysts 
D)  Database analysts 
A)  Programmers 
B)  Users 
C)  Systems analysts 
D)  Database analysts

Question 17

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

Accepted Answer

A)  40 percent 
B)  25 percent 
C)  60 percent 
D)  80 percent 
A)  40 percent 
B)  25 percent 
C)  60 percent 
D)  80 percent

Question 18

Organizational commitment to a database project is not necessary for its success.

Accepted Answer

A) True 
 B)False

Question 19

Enterprise modeling sets the range and general contents of organizational databases.

Accepted Answer

A) True 
 B)False

Question 20

Database maintenance is typically the longest step of the database development process.

Accepted Answer

A) True 
 B)False

In two-tier database architectures, little functionality needs to be programmed into the client application.

E. F. Codd developed the relational model in the:

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

Discuss some of the disadvantages of file processing systems.

A data warehouse contains summarized and historical information.

Database development begins with the design of the database.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A data model is a graphical system used to capture the nature and relationships among data.

The steps of the systems development life cycle can only be viewed as a linear process.

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

The user interface includes languages, menus, and other facilities by which users interact with various system components.

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

A relatively small team of people who collaborate on the same project is called a:

A graphical system used to capture the nature and relationships among data is called a(n):

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

Organizational commitment to a database project is not necessary for its success.

Enterprise modeling sets the range and general contents of organizational databases.

Database maintenance is typically the longest step of the database development process.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 1: The Database Environment and Development Process

In two-tier database architectures, little functionality needs to be programmed into the client application.

E. F. Codd developed the relational model in the:

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications.

Discuss some of the disadvantages of file processing systems.

A data warehouse contains summarized and historical information.

Database development begins with the design of the database.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A data model is a graphical system used to capture the nature and relationships among data.

The steps of the systems development life cycle can only be viewed as a linear process.

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process.

The user interface includes languages, menus, and other facilities by which users interact with various system components.

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle.

A relatively small team of people who collaborate on the same project is called a:

A graphical system used to capture the nature and relationships among data is called a(n):

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

Organizational commitment to a database project is not necessary for its success.

Enterprise modeling sets the range and general contents of organizational databases.

Database maintenance is typically the longest step of the database development process.

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters