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
1
Copyright © 2014 Pearson Education, Inc.