Page 1 of 10
Database Concepts
8th Edition
David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
Instructor’s Manual
Prepared by Robert C. Yoder
APPENDIX F
Getting Started in Systems Analysis and
Design
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted,
in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior
written permission of the publisher. Printed in the United States of America.
Instructor’s Manual to accompany:
Database Concepts (8th Edition)
David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
Appendix F – Getting Started in Systems Analysis and Design
Page 3 of 10
Appendix Objectives
• To understand information systems
• To understand business processes
CHAPTER ERRATA
There are no known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the Online DBC e08 Errata document, which will be
available at http://www.pearsonhighered.com/kroenke
THE ACCESS WORKBENCH
There is no section of The Access Workbench associated with this appendix.
TEACHING SUGGESTIONS
• The general purpose of this appendix is to provide a context for the study of data
models in Chapter 4 and database designs in Chapter 5. It can be used as an
introduction to DBC Part II—Database Design, and you should assign it as a reading
before your students read Chapter 4.
• However, there is enough significant overlap with Chapter 4 and Chapter 5 topics
that you may want to assign it in parts, or, alternatively, have your students reread
appropriate sections as you work through the Chapters.
• There is also material (on the SDLC Implementation and System Maintenance steps)
that can be used with Chapter 6 on Database Administration. You can tie many of
the topics in that chapter back to the SDLC.
Appendix F – Getting Started in Systems Analysis and Design
Page 4 of 10
ANSWERS TO REVIEW QUESTIONS
F.1 What is a decision?
F.2 What is data?
F.3 What is information?
We can now define information as:
F.4 What is a system? What is an information system?
F.5 What is a computer-based information system? Describe the five components of a
computer-based information system.
F.6 What is a competitive strategy?
Appendix F – Getting Started in Systems Analysis and Design
Page 5 of 10
F.7 Describe Michael Porter’s five forces model.
According to Porter’s five forces model, the industry structure of an industry is determined by
relative strength or weakness within the industry of:
• The bargaining power of customers. Can the industry’s customers influence the
F.8 Describe Michael Porter’s primary activities.
Michael Porter defines the primary activities or operational activities of a business as:
F.9 Describe Michael Porter’s support activities.
Michael Porter defines the support activities, which, as the name implies, support the
operational activities, as:
F.10 What is a business process?
A business process is a set of activities that transforms inputs into outputs.
Inputs Activities Outputs
F.11 How do information systems support business processes?
Appendix F – Getting Started in Systems Analysis and Design
Page 6 of 10
F.12 Describe how information systems include processes.
A generalized conceptual process is input
→
process
→
output. Information systems include
such processes. For example, an inventory control application may include these steps as:
F.13 What is business process modeling?
F.14 What is systems analysis and design?
F.15 Describe the systems development life cycle (SDLC) model.
There are different interpretations or conceptualizations of the SDLC, each of which uses a
different number of steps. This book uses the same set of steps used by David Kroenke, and
includes five steps or stages:
Appendix F – Getting Started in Systems Analysis and Design
Page 7 of 10
The system definition step is a process that starts with the need for an information system to
support a business process as its input, and produces a project plan as its output. During this
process, we will need to:
The requirements analysis step is a process that starts with the project plan as its input, and
produces a set of approved user requirements as its output. During this process, we will need
to:
The component design step is a process that starts with the approved user requirements as its
input, and produces a final system design as its output. During this process, we will need to:
The implementation step is a process that starts with the final system design as its input, and
produces a final system as its output. During this process, we will need to:
The system maintenance step is a process that starts with the implemented system as its input,
and produces an updated system or a request for system modification using the SDLC as its
output. During this process, we will need to:
Appendix F – Getting Started in Systems Analysis and Design
Page 8 of 10
F.16 Define project scope.
F.17 What is a use case? How well does Microsoft Visio 2016 support modeling use cases?
F.18 What are business rules?
F.19 What is a user requirements document (URD)? What purpose does it serve?
A user requirements document (URD) is a requirements analysis deliverable that provides an
approved set of user requirements. There is no set format for a URD.
Typically a URD may contain:
F.20 What is a statement of work (SOW)? What purpose does it serve?
A statement of work (SOW) is a possible deliverable for the requirements analysis step of the
SDLC. There is no set format for an SOW, and an SOW for an in-company project may be very
different for an SOW between a consultant and client.
Typically an SOW may contain descriptions of:
Appendix F – Getting Started in Systems Analysis and Design
Page 9 of 10
ANSWERS TO EXERCISES
F.21 Review the information about Wedgewood Pacific (WP) and the WP database that has
been presented in the Access Workbench Exercises in chapters 1 and 2.
A. The database is part of an information system to support business operations at
Wedgewood Pacific. What specific business process at Wedgewood Pacific do
you think this information system is being developed to support? How does the
WP database (including the forms and reports, since we are using Microsoft
Access 2016 to create the database) support the business process?
Appendix F – Getting Started in Systems Analysis and Design
B. How does this business process overlay Michael Porter’s set of primary and
support business activities? Draw a diagram to illustrate this overlap.