Database Concepts, 7e, Global Edition (Kroenke/Auer)

Appendix F Getting Started in Systems Analysis and Design

1) Data is facts and numbers.

Answer: TRUE
Diff: 2 Page Ref: F-20

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

Answer: TRUE
Diff: 2 Page Ref: F-20

3) An information system is a set of components that interact to achieve some purpose or goal.
Answer: FALSE
Diff: 2 Page Ref: F-21

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

Answer: FALSE
Diff: 2 Page Ref: F-21

5) Information systems must be both developed and used to help businesses reach their goals and
objectives.
Answer: TRUE
Diff: 1 Page Ref: F-21

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

Answer: TRUE
Diff: 2 Page Ref: F-22

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

Answer: FALSE
Diff: 2 Page Ref: F-22

8) Information systems are used to support business processes.

Answer: TRUE
Diff: 2 Page Ref: F-23

9) Systems analysis and design is the process of creating and maintaining information systems.
Answer: TRUE
Diff: 1 Page Ref: F-24

10) The classic systems analysis methodology is called the Analysis Development Life Cycle
(ADLC).
Answer: FALSE
Diff: 2 Page Ref: F-24

1
Copyright © 2015 Pearson Education, Ltd.
11) User interviews are conducted during the requirements analysis step.
Answer: TRUE
Diff: 2 Page Ref: F-26

12) One deliverable from the requirements analysis step is a statement of requirements (SOR).
Answer: FALSE
Diff: 2 Page Ref: F-27

13) Data models are created during the component design step.
Answer: FALSE
Diff: 2 Page Ref: F-27

14) Database designs are created during the component design step.
Answer: TRUE
Diff: 2 Page Ref: F-27

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

Answer: TRUE
Diff: 2 Page Ref: F-27-F-28

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: F-20

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: F-20

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: F-21

2
Copyright © 2015 Pearson Education, Ltd.
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 above are considered primary or operational activities.
Answer: A
Diff: 2 Page Ref: F-22

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 above are considered support activities.
Answer: A
Diff: 2 Page Ref: F-22

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: F-24

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: F-26

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 C
Answer: E
Diff: 2 Page Ref: F-27

3
Copyright © 2015 Pearson Education, Ltd.
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: F-26-F-27

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: F-27

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: F-27-F-28

27) ________ is facts and numbers.

Answer: Data
Diff: 1 Page Ref: F-20

28) One definition of ________ is knowledge derived from data.

Answer: information
Diff: 2 Page Ref: F-20

29) A(n) ________ is a set of components that interact to achieve some purpose or goal.
Answer: system
Diff: 2 Page Ref: F-21

30) A computer-based information system has ________ components.

Answer: five
Diff: 2 Page Ref: F-21

31) Information systems must be both ________ and ________ to help businesses reach their
goals and objectives.
Answer: developed; used
Diff: 1 Page Ref: F-21
4
Copyright © 2015 Pearson Education, Ltd.
32) Michael Porter includes inbound logistics in his list of ________ activities.
Answer: primary or operational
Diff: 2 Page Ref: F-22

33) Michael Porter includes procurement in his list of ________ activities.

Answer: support
Diff: 2 Page Ref: F-22

34) A business process is a set of activities that transforms ________ into ________.
Answer: inputs; outputs
Diff: 2 Page Ref: F-22

35) Information systems are used to support ________.

Answer: business processes
Diff: 3 Page Ref: F-23

36) Systems analysis and design is the process of ________ and ________ information systems.
Answer: creating; maintaining
Diff: 2 Page Ref: F-24

37) The classic systems analysis methodology is called the ________.

Answer: Systems Development Life Cycle (SDLC)
Diff: 2 Page Ref: F-24

38) User interviews are conducted during the ________ step.

Answer: requirements analysis
Diff: 2 Page Ref: F-26

39) One deliverable from the requirements analysis step is a ________.

Answer: user requirements document (URD) or statement of work (SOW)
Diff: 2 Page Ref: F-27

40) Data models are created during the ________ step.

Answer: requirements analysis
Diff: 2 Page Ref: F-27

41) Database designs are created during the ________ step.

Answer: component design
Diff: 2 Page Ref: F-27

42) Databases are created in a DBMS during the ________ step.

Answer: implementation
Diff: 2 Page Ref: F-27-F-28

5
Copyright © 2015 Pearson Education, Ltd.
43) Define and discuss an information system.
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: F-21

44) 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: F-21-F-22

45) 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: F-22

46) What are the five steps 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: F-24-F-25

47) 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: F-27

6
Copyright © 2015 Pearson Education, Ltd.