Chapter 1

Question 1

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

Answer 1

Relationships

Question 2

Database architects establish standards for data in business units.

Answer 2

True

Question 3

Metadata are data that describe the properties of other data.

Answer 3

True

Question 4

Metatdata typically describes all of the following EXCEPT:

Answer 4

location on disk.

Question 5

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

Answer 5

False

Question 6

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

Answer 6

True

Question 7

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

Answer 7

False

Question 8

Prototyping is a type of rapid application development.

Answer 8

True

Question 9

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

Answer 9

False

Question 10

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

Answer 10

End Users

Question 11

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

Answer 11

True

Question 12

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

Answer 12

1960s

Question 13

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.

Answer 13

True

Question 14

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

Answer 14

Database management system (DBMS)

Question 15

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.

Answer 15

analysis

Question 16

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

Answer 16

user view

Question 17

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 17

True

Question 18

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

Answer 18

implementation

Question 19

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

Answer 19

True

Question 20

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

Answer 20

Improved responsiveness

Question 21

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

Answer 21

Redundant data

Question 22

Multi-tier client/server database applications contain a business logic layer.

Answer 22

True

Question 23

Although personal databases improve productivity, one risk is that data cannot be shared with other users.

Answer 23

True

Question 24

An enterprise resource planning system integrates all functions of the enterprise.

Answer 24

True

Question 25

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

Answer 25

False

Question 26

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

Answer 26

End Users

Question 27

A database is an organized collection of ________ related data.

Answer 27

logically

Question 28

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

Answer 28

False

Question 29

Because applications are often developed independently in file processing systems:

Answer 29

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

Question 30

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

Answer 30

False

Question 31

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

Answer 31

True

Question 32

________ specify computer systems requirements.

Answer 32

Systems analysts

Question 33

The data repository assists database administrators in enforcing standards.

Answer 33

True

Question 34

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

Answer 34

Improved responsiveness

Question 35

One of the most popular RAD methods is:

Answer 35

prototyping.

Question 36

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

Answer 36

entity.

Question 37

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

Answer 37

Organizational conflict

Question 38

A major difference between data warehouses and transactional systems as compared to big data is:

Answer 38

the data is unstructured in big data systems.

Question 39

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

Answer 39

True

Question 40

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

Answer 40

user view