INFO-I308 Chapter 1 Quiz: The Database Environment and Development Process

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

80 percent

Which of the following is software used to create, maintain, and provide controlled access to databases?

Database management system (DBMS)

Which of the following is NOT a cost and/or risk of the database approach?

Improved responsiveness

Which of the following is NOT an advantage of database systems?

Redundant data

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

Relationships

________ is a tool even non-programmers can use to access information from a database.

Structured query language (SQL)

A user view is:

a logical description of some portion of the database.

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.

analysis

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

analysis

A rule that CANNOT be violated by database users is called a:

constraint

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

data model

Organizing the database in computer disk storage is done in the ________ phase.

design

Database development begins with ________, which establishes the range and general contents of organizational databases.

enterprise data modeling

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

entity

Program-data dependence is caused by:

file descriptions being stored in each database application.

The SDLC phase in which database processing programs are created is the ________ phase.

implementation

Older systems that often contain data of poor quality are called ________ systems.

legacy

A database is an organized collection of ________ related data.

logically

Data that describe the properties of other data are:

metadata

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

providing an integrated development environment.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

relation

With the database approach, data descriptions are stored in a central location known as a:

repository

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

user view