Database Processing, 13E (Kroenke/Auer)

Full file at

Database Processing, 13e (Kroenke/Auer)

Appendix B: Getting Started with Systems Analysis and Design

1) Data is facts and numbers.

Answer: TRUE

Diff: 2 Page Ref: B-4

2) One definition of information is knowledge derived from data.

Answer: TRUE

Diff: 2 Page Ref: B-4

3) An information system is a set of components that interact to achieve some purpose or goal.

Answer: FALSE

Diff: 2 Page Ref: B-5

4) A computer-based information system has four components.

Answer: FALSE

Diff: 2 Page Ref: B-5

5) Information systems must be both developed and used to help businesses reach their goals and objectives.

Answer: TRUE

Diff: 1 Page Ref: B-5

6) Michael Porter includes manufacturing operations in his list of primary activities.

Answer: TRUE

Diff: 2 Page Ref: B-6

7) A business process is a set of activities that transforms materials into products.

Answer: FALSE

Diff: 2 Page Ref: B-6

8) Information systems are used to support business processes.

Answer: TRUE

Diff: 2 Page Ref: B-8

9) Systems analysis and design is the process of creating and maintaining information systems.

Answer: TRUE

Diff: 2 Page Ref: B-8

10) The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).

Answer: FALSE

Diff: 2 Page Ref: B-8

11) User interviews are conducted during the requirements analysis step.

Answer: TRUE

Diff: 2 Page Ref: B-10

12) One deliverable from the requirements analysis step is a statement of requirements (SOR).

Answer: FALSE

Diff: 2 Page Ref: B-11

13) Data models are created during the component design step.

Answer: FALSE

Diff: 2 Page Ref: B-11

14) Database designs are created during the component design step.

Answer: TRUE

Diff: 2 Page Ref: B-11

15) Databases are created in a DBMS during the implementation step.

Answer: TRUE

Diff: 2 Page Ref: B-11-B-12

16) Data is composed of:

A) facts

B) numbers

C) information

D) A and B

E) A, B, and C

Answer: D

Diff: 1 Page Ref: B-4

17) Information can be defined as:

A) data presented in a meaningful context.

B) knowledge derived from data.

C) data processed by summing, ordering, averaging, grouping, comparing or other similar operations.

D) A and B

E) A, B, and C

Answer: E

Diff: 2 Page Ref: B-4

18) Which of the following is a component of a computer-based information system?

A) Hardware

B) Software

C) Data

D) Procedures

E) All of the above

Answer: E

Diff: 2 Page Ref: B-5

19) Which of the following is not included in Michael Porter's list of primary or operational activities?

A) Procurement

B) Inbound logistics

C) Manufacturing operations

D) Outbound logistics

E) All of the above are considered primary or operational activities.

Answer: A

Diff: 2 Page Ref: B-6

20) Which of the following is not included in Michael Porter's list of support activities?

A) Technology management

B) Customer service

C) Human resources management

D) Firm infrastructure management

E) All of the above are considered support activities.

Answer: A

Diff: 2 Page Ref: B-6

21) The classic systems analysis methodology is called the:

A) Systems Development Life Cycle (SDLC).

B) Analysis Development Life Cycle (ADLC).

C) Component Development Life Cycle (CDLC).

D) Information Development Life Cycle (IDLC).

E) None of the above is correct.

Answer: A

Diff: 2 Page Ref: B-8

22) User interviews are conducted during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: B

Diff: 2 Page Ref: B-11-B-12

23) A deliverable from the requirements analysis step is a(n):

A) user requirements document (URD)

B) user requirements statement (URS)

C) statement of work (SOW)

D) statement of requirements (SOR)

E) A and B

Answer: E

Diff: 2 Page Ref: B-11

24) Data models are created during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: B

Diff: 2 Page Ref: B-11-B-12

25) Database designs are created during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: C

Diff: 2 Page Ref: B-11-B-12

26) Databases are created in a DBMS during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: D

Diff: 2 Page Ref: B-11-B-12

27) Hardware specifications are determined during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: C

Diff: 2 Page Ref: B-11-B-12

28) Hardware is installed and tested during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: D

Diff: 2 Page Ref: B-11-B-12

29) People are hired (if necessary) and training during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: D

Diff: 2 Page Ref: B-11-B-12

30) The system is updated with patches, service packs and new software releases during the ______step of the SDLC.

A) system definition

B) requirements analysis

C) component design

D) implementation

E) systems maintenance

Answer: E

Diff: 2 Page Ref: B-11-B-12

31) Define and discuss an information systems.

Answer: A system is a set of components that interact to achieve some purpose or goal, and an information system is a system that has the goal of producing information. An information system has five components: hardware, software, data, processing, and people.

Diff: 2 Page Ref: B-5

32) How does Michael Porter define primary or operational business activities?

Answer: Michael Porter includes five business activities in his definition of primary or operational activities. These include:

•Inbound logistics: receiving, storing and distributing product inputs.

•Manufacturing operations: transforming inputs into the final product.

•Outbound logistics: collecting, storing, and distributing the product to buyers.

•Sales and marketing: convincing customers to buy the product and selling it to them.

•Customer service: assisting the customers in their use of the product

Diff: 2 Page Ref: B-5-B-6

33) How does Michael Porter define support business activities?

Answer: Michael Porter includes four business activities in his definition of support activities. These include:

•Procurement: managing supplier relationships and buying the product inputs.

•Technology management: product research and development and new procedures, methods and techniques.

•Human resources management: managing employee resources.

•Firm infrastructure management: general management of the firm, finance, accounting, legal services, and government affairs.

Diff: 2 Page Ref: B-5-B-6

34) What are the five step or stages of the systems development life cycle (SDLC)?

Answer: The five steps or stages of the SDLC are:

•System definition.

•Requirements analysis

•Component design

•Implementation

•System maintenance

Diff: 1 Page Ref: B-9-B-12

35) What activities take place during the component design step of the systems development life cycle (SDLC)?

Answer: During the component design step of the SDLC, we

•Determine hardware specifications

•Determine program (software) specifications

•Create the database design

•Design business procedures

•Create job descriptions for business personnel

Diff: 2 Page Ref: B-11