Database Concepts, 8e (Kroenke)
Appendix F Getting Started with Systems Analysis and Design
1) There is no set format for a statement of work (SOW).
2) Typically, a user requirements document (URD) contains all except ________.
A) data model
B) database schema
C) introduction
D) revision history
E) project delivery requirements
3) What is a common means of gathering data and information about system requirements?
A) User interviews
B) Review of existing forms, reports and other documentation
C) Build system components
D) Both A and B
E) None of the above
4) User interviews are conducted during the requirements analysis step.
5) One deliverable from the requirements analysis step is a statement of requirements (SOR).
6) Data models are created during the component design step.
7) Database designs are created during the component design step.
8) Databases are created in a DBMS during the implementation step.
9) 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.
10) User interviews are conducted during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
11) 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) Both A and C
12) Data models are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
13) Database designs are created during the ________ step of the SDLC.
A) system definition
B) requirements analysis
C) component design
D) implementation
E) systems maintenance
14) 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
15) Systems analysis and design is the process of ________ and ________ information systems.
16) The classic systems analysis methodology is called the ________.
17) User interviews are conducted during the ________ step.
18) One deliverable from the requirements analysis step is a ________.
19) Data models are created during the ________ step.
20) Database designs are created during the ________ step.
21) Databases are created in a DBMS during the ________ step.
22) What are the five steps or stages of the systems development life cycle (SDLC)?
23) What activities take place during the component design step of the systems development life
cycle (SDLC)?
24) ________ is a commonly used system for drawing business process models.
25) Michael Porter includes manufacturing operations in his list of primary activities.
26) A business process is a set of activities that transforms materials into products.
27) 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.
28) 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) Procurement
29) Michael Porter includes inbound logistics in his list of ________ activities.
30) Michael Porter includes procurement in his list of ________ activities.
31) A business process is a set of activities that transforms ________ into ________.
32) Information systems are used to support ________.
33) How does Michael Porter define primary or operational business activities?
34) How does Michael Porter define support business activities?
35) ________ are constraints on database activities which generally arise from business policy
and practice.
36) This appendix provides an in-depth, thorough look at systems analysis and design from the
standpoint of a database course.
37) Data is recorded facts and numbers.
38) One definition of information is knowledge derived from data.
39) An information system is a set of components that interact to achieve some purpose or goal.
40) A computer-based information system has four components.
41) Information systems must be both developed and used to help businesses reach their goals
and objectives.
42) Information systems are used to support business processes.
43) Systems analysis and design is the process of creating and maintaining information systems.
44) The classic systems analysis methodology is called the Analysis Development Life Cycle
(ADLC).
45) Data is composed of recorded ________.
A) facts
B) numbers
C) information
D) Both A and B
E) A, B and C
46) 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) Both A and B
E) A, B and C
47) Which of the following is not a component of a computer-based information system?
A) Hardware
B) Networking
C) Data
D) Procedures
E) Software
48) ________ is recorded facts and numbers.
49) One definition of ________ is knowledge derived from data.
50) A(n) ________ is a set of components that interact to achieve some purpose or goal.
51) A computer-based information system has ________ components.
52) Information systems must be both ________ and ________ to help businesses reach their
goals and objectives.
53) Define and discuss an information system.
54) Which Microsoft product can be used to draw use case diagrams?
A) Outlook
B) Access
C) Visio
D) Project
E) FileShare