Database Processing, 15e (Kroenke)
Appendix B: Getting Started with Systems Analysis and Design
1) Facts and numbers are examples of data. Data is facts and numbers.
2) One definition of information is knowledge derived from data.
3) An information system is a system that has the goal of producing data.
4) A computer-based information system has four components.
5) Information systems must be both developed and used to help businesses reach their goals and
objectives.
6) Michael Porter includes manufacturing operations in his list of primary activities.
7) A business process is a set of activities that transforms materials into products.
8) Information systems are used to support business processes.
9) Systems analysis and design is the process of creating and maintaining information systems.
10) The classic systems analysis methodology is called the Analysis Development Life Cycle
(ADLC).
11) User interviews are conducted during the requirements analysis step of the systems
development life cycle (SDLC).
12) One deliverable from the requirements analysis step of the systems development life cycle
(SDLC) is a statement of requirements (SOR).
13) Data models are created during the component design step of the SDLC.
14) Database designs are created during the component design step.
15) Databases are created in a DBMS during the implementation step of the SDLC.
16) Data is composed of ________.
A) facts
B) numbers
C) information
D) Both A and B are correct
17) Which of the following is not a definition of information?
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 list of facts
18) Which of the following is not a component of a computer-based information system?
A) Hardware
B) Software
C) The inventory in the warehouse
D) Data
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
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
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)
22) User interviews are conducted during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
23) A deliverable from the requirements analysis step is a ________.
A) user requirements document (URD)
B) user requirements statement (URS)
C) statement of work (SOW)
D) A and sometimes C
24) Data models are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
25) Database designs are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
26) Databases are created in a DBMS during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
27) Hardware specifications are determined during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
28) Hardware is installed and tested during the ________ step of the SDLC.
A) requirements analysis
B) component design
C) implementation
D) systems maintenance
29) People are hired (if necessary) and trained during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
30) The system is updated with patches, service packs and new software releases during the
________ step of the SDLC.
A) requirements analysis
B) component design
C) implementation
D) systems maintenance
31) Which of the following does a User Requirements Document (URD) typically NOT contain?
A) A data model
B) Functional requirements
C) The scope of the work to be done
D) Project delivery requirements
32) Which of the following does a Statement of work (SOW) typically not contain?
A) Non-functional requirements (speed and time, capacity and reliability)
B) An identification of who will do the work
C) The objectives of the work to be done
D) The location of where the work will be done
33) Briefly define and discuss what an information system is, the five components that comprise
an information system, and what the purpose of an information system is.
34) How does Michael Porter define primary or operational business activities? What do they
include?
35) How does Michael Porter define support business activities? What do they include?
36) What are the five steps or stages of the systems development life cycle (SDLC)?
37) What activities take place during the component design step of the systems development life
cycle (SDLC)?