Modern Database Management - Chapter 1

repository.

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

Answer: FALSE

A constraint is a rule in a database system that can be violated by users.

Answer: TRUE

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

Various operational data sources.

A data warehouse derives its data from:

Answer: FALSE

A well-structured database establishes the entities between relationships in order to derive the desired information.

server.

A workgroup database is stored on a central device called a(n):

user view

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

providing an integrated development environment.

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

processing logic.

All of the following are properties of metadata EXCEPT:

Answer: FALSE

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

Answer: FALSE

An enterprise data model describes the scope of data for only one information system.

RAD.

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

unplanned duplicate data files are the rule rather than the exception.

Because applications are often developed independently in file processing systems:

automates the design of databases and application programs.

CASE is a class of tools that:

Answer: FALSE

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

Answer: TRUE

File processing systems have been replaced by database systems in most critical business applications today.

application programs.

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

legacy

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

decision support.

One application of data warehouses is:

limited data sharing.

One disadvantage of file processing systems is:

prototyping.

One of the most popular RAD methods is:

Answer: TRUE

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.

Answer: FALSE

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

80 percent

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

Answer: FALSE

Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.

design

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

Answer: FALSE

Personal databases are designed to support a small group of individuals working together on a project.

file descriptors being stored in each application.

Program-data dependence is caused by:

Answer: TRUE

Prototyping is a type of rapid application development.

Answer: FALSE

Reduced program maintenance is an advantage of file processing systems.

Answer: TRUE

Redundancy increases the risk of inconsistent data.

relation.

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

Answer: FALSE

Repositories are always used in file processing systems.

Answer: TRUE

Separation of metadata from application programs that use the data is called data independence.

implementation

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

analysis

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.

Answer: TRUE

The data repository assists database administrators in enforcing standards.

Answer: FALSE

The data that you are interested in capturing about an entity is called an instance.

Answer: TRUE

The failure to implement a strong database administrative function is the most common source of database failures in organizations.

failure to implement a strong database administration function.

The most common source of database failures in organizations is:

Organizational conflict

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

1960s.

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

Answer: FALSE

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

Answer: TRUE

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

Answer: FALSE

Visual programming tools such as Visual Basic have made prototyping more difficult.

Improved responsiveness

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

Redundant data

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

The desire to require programmers to write all file handling functionality

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

Data warehouse

Which of the following is an integrated decision support database with content derived from various operational databases?

Database management system (DBMS)

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

Voice, Letters, Numbers

Which of the following types of data can be stored in a database?

Unstructured and unpredictable use of data

Which of the following will interfere with access to operational databases?

None of the above

Which organizational function should set database standards?

repository.

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

Answer: FALSE

With the traditional file processing approach, each application shares data files, thus enabling much data sharing.

Systems analysts

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

Relationships

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

Database analysts

________ concentrate on determining the requirements for the database component of an information system.

Structured query language

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

logically

A database is an organized collection of ________ related data.

data model.

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

repository.

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

Answer: TRUE

A modern database management system automates more of the backup and recovery tasks than a file system.

Answer: TRUE

A person is an example of an entity.

entity.

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

Answer: TRUE

A relational database establishes the relationships between entities by means of a common field.

workgroup.

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

constraint.

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

Answer: FALSE

A user view is how the user sees the data when it is produced.

a logical description of some portion of the database.

A user view is:

Answer: TRUE

Cost and complexity are just two of the disadvantages of database processing.

Answer: TRUE

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

information.

Data processed in a way that increases a user's knowledge is:

Answer: FALSE

Data redundancy is used to establish relationships between data but is never used to improve database performance.

none of the above.

Data that describe the properties of other data are:

enterprise data modeling

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

Answer: FALSE

Database development begins with the design of the database.

Answer: FALSE

Database development projects are never done in a bottom-up fashion.

Answer: TRUE

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

Answer: FALSE

Database processing programs are coded and tested during the design stage of the systems development life cycle.

all of the above.

Databases may be more expensive to maintain than files because of:

Answer: FALSE

Databases were developed as the first application of computers to data processing.

Answer: TRUE

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.

1970s.

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

Answer: TRUE

End users can often retrieve and display data easily with a relational database.

Answer: TRUE

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

Answer: TRUE

In practice, databases today may contain either data or information.

Answer: TRUE

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct.

Answer: TRUE

Information is processed data.

user interface.

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

Answer: TRUE

Many of the disadvantages of file processing systems can also be limitations of databases.

Answer: TRUE

Metadata are data that describe the properties of other data.

Answer: TRUE

The repository is populated during the analysis phase of the systems development life cycle.

Answer: FALSE

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

Answer: TRUE

The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.

Answer: FALSE

The term legacy system refers to a newly installed database management system.

Internal

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

Systems Development Life Cycle.

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

Answer: TRUE

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