ITD 256 Self-Check 1

The period that can be considered a "proof of concept" time was the:

1960s

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

1970s

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

80 percent

Which organizational function should set database standards?

Database Administration

____ do NOT concentrate on determining the requirements for the database component of an information system.

Database analysts

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

Database management system (DBMS)

____ is the most popular RDMS data model notation

ERD

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

Improved responsiveness

The three-schema approach includes which of the following schemas?

Internal

The need for consensus on data definitions is an example of which type of risk in the database environment?

Organizational conflict

An iterative methodology that rapidly repeats the analysis, design, and implementation phases pf the SLDC is called:

RAD

Which of the following is NOT an advantage or 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

The traditional methodology used to develop, maintain and replace information systems is called the:

Systems Development Life Cycle

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

Systems analysts

Which of the following is NOT an objective that drove the development and evolution of database technology?

The desire to require programmers to write all file handling functionality

A user view is:

a logical description of some portion of the database

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

analysis

In a file processing environment, descriptions for data and the logic for accessing the data are built into:

application programs

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

The most common source of database failures in organizations is:

failure to implement a strong database administration function

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

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.

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 properties of metadata EXCEPT:

processing logic

One of the most popular RAD methods is:

prototyping

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

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

repository

A knowledge base of information or facts about an enterprise is called a(n):

repository

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

repository

A workgroup database is stored on a central device called a:

server

Because applications are often developed independently in file processing systems:

unplanned duplicate data files are the rule rather than the exception

Languages, menus, and other facilities by which users interact with the database are collectively called a(n):

user interface

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

user view

A data warehouse derives its data from:

various operational data sources

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

workgroup