Ch. 1

Question 1

If uncontrolled, what can lead to data anomalies?

Answer 1

data redundancy

Question 2

A record in the logical design of a database corresponds to a ____ in the physical database.

Answer 2

row

Question 3

Analyzing historical sales data stored in a database is commonly referred to as ____.

Answer 3

data mining

Question 4

A ____ is a group of interrelated files

Answer 4

database

Question 5

Which of the following terms is considered the basic unit of data in a database?

Answer 5

character

Question 6

Which of the following terms refers to a group of related records?

Answer 6

file

Question 7

Which of the following committees are responsible for establishing SQL guidelines?

Answer 7

ANSI and ISO

Question 8

Which of the following terms best describes where a group of characters that represents a customer’s address would be stored in the logical design?

Answer 8

field

Question 9

A record in the logical design of a database is represented by what in the physical database?

Answer 9

row

Question 10

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

Answer 10

systems design

Question 11

A field in the logical design of a database is represented by what in the physical database?

Answer 11

column

Question 12

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

Answer 12

systems analysis

Question 13

The multi-step process used when creating a new system is referred to as ____.

Answer 13

the Systems Development Life Cycle

Question 14

Which of the following is an example of an attribute?

Answer 14

a person’s hair color

Question 15

Data mining refers to ____.

Answer 15

analyzing data already stored in a database

Question 16

Which of the following terms represents a collection of fields?

Answer 16

record

Question 17

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

Answer 17

systems deployment

Question 18

Which of the following is used to uniquely identify each record?

Answer 18

primary key

Question 19

What represents a characteristic or attribute that is being collected about an entity?

Answer 19

field

Question 20

What is the first step in the SDLC?

Answer 20

1. Systems investigation: understanding the problem

Question 21

What is the second step in the SDLC?

Answer 21

2. Systems analysis: understanding the solution to the previously identified problem

Question 22

What is the third step in the SDLC?

Answer 22

3. Systems design: defining the logical and physical components

Question 23

What is the fourth step in the SDLC?

Answer 23

4. Systems implementation: creating the system

Question 24

What is the fifth step in the SDLC?

Answer 24

5. Systems integration and testing: placing the system into operation for testing

Question 25

What is the sixth step in the SDLC?

Answer 25

6. Systems deployment: Placing the system into production

Question 26

What is the seventh step in the SDLC?

Answer 26

7. Systems maintenance and review: evaluating the implemented system

Question 27

What are the seven step process of the Systems Development Life Cycle (SDLC)?

Answer 27

Systems investigation 
Systems analysis 
Systems design 
Systems implementation 
Systems integration and testing 
Systems deployment 
Systems Maintenance and review