Business Process Reengineering
Analysis and Design
Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Assistant: Ashlee Bradbury Director of Marketing: Patrice Lumumba Jones Executive Marketing Manager: Anne Fahlgren Senior Managing Editor: Judy Leale Production Project Manager: Kelly Warsak Senior Operations Supervisor: Arnold Vila Operations Specialist: Cathleen Petersen Creative Director: Blair Brown Senior Art Director/Design Supervisor: Janet Slowik Text Designer: Michael Fruhbeis Creative Director/Cover: Jayne Conte Cover Designer: Suzanne Duda Cover Art: Fotolia/3d mosaic/©Redshinestudio Manager, Rights and Permissions: Hessa Albader Media Project Manager: Lisa Rinaldi Media Editor: Denise Vaughn Full-Service Project Management: Tiffany Timmerman/S4Carlisle Publishing Services Composition: S4Carlisle Publishing Services Printer/Binder: Courier/Kendallville Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: ITCCentury Book
Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text.
Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation.
Copyright © 2012, 2009, 2006, 2004, 2001 Pearson Education, Inc., publishing as Prentice Hall. All rights reserved. Manufactured in the United States of America. This publication is protected by Copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. To obtain permission(s) to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, One Lake Street, Upper Saddle River, New Jersey 07458, or you may fax your request to 201-236-3290.
Many of the designations by manufacturers and seller to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.
Library of Congress Cataloging-in-Publication Data Valacich, Joseph S.
Essentials of systems analysis and design / Joseph S. Valacich, Joey F. George, Jeffrey A. Hoffer.—5th ed.
p. cm. Includes bibliographical references and index. ISBN-13: 978-0-13-706711-4 ISBN-10: 0-13-706711-9
System design. 2. System analysis. I. George, Joey F. II. Hoffer, Jeffrey A. III. Title.
QA76.9.S88V345 2011 003—dc22
2011008298
10 9 8 7 6 5 4 3 2 1 ISBN 10: 0-13-706711-9 ISBN 13: 978-0-13-706711-4
Essentials of Systems Analysis and Design FIFTH EDITION
Joseph S. Valacich University of Arizona
Joey F. George Iowa State University
Jeffrey A. Hoffer University of Dayton
Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto
Delhi Mexico City Sa~o Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo
To Jackie, Jordan, and James, for your sacrifices, encouragement,
and support.
—Joe
To Karen, Evan, and Caitlin.
—Joey
To Patty, for her sacrifices, encouragement, and support.
To my students, for being receptive and critical, and for challenging me
to be a better teacher.
—Jeff
Brief Contents PART I FOUNDATIONS FOR SYSTEMS DEVELOPMENT 2
1 The Systems Development Environment 2 2 The Sources of Software 26 3 Managing the Information Systems Project 42
PART II SYSTEMS PLANNING AND SELECTION 82
4 Systems Planning and Selection 82
PART III SYSTEMS ANALYSIS 122
5 Determining System Requirements 122 6 Structuring System Requirements:
Process Modeling 152 7 Structuring System Requirements:
Conceptual Data Modeling 188
PART IV SYSTEMS DESIGN 232
8 Designing the Human Interface 232 9 Designing Databases 272
PART V SYSTEMS IMPLEMENTATION AND OPERATION 318
10 Systems Implementation and Operation 318
Appendix A Object-Oriented Analysis and Design 361 Appendix B Agile Methodologies 381
References 395 Glossary of Acronyms 401 Glossary of Terms 403 Index 409
vii
This page intentionally left blank
Contents Preface xix
PART I FOUNDATIONS FOR SYSTEMS DEVELOPMENT 2
Chapter 1 The Systems Development Environment 2 What Is Information Systems Analysis and Design? 4
Systems Analysis and Design: Core Concepts 4
Systems 6
Definition of a System and Its Parts 6
Important System Concepts 7
A Modern Approach to Systems Analysis and Design 10
Your Role in Systems Development 11
Developing Information Systems and the Systems Development Life Cycle 12
Phase 1: Systems Planning and Selection 14
Phase 2: Systems Analysis 14
Phase 3: Systems Design 15
Phase 4: Systems Implementation and Operation 15
Alternative Approaches to Development 18
Prototyping 18
Computer-Aided Software Engineering (CASE) Tools 18
Joint Application Design 19
Rapid Application Development 19
Participatory Design 21
Agile Methodologies 21
Key Points Review 21 Key Terms Checkpoint 22 Review Questions 23 Problems and Exercises 23 Discussion Questions 24 Case Problems 24
Chapter 2 The Sources of Software 26 Introduction 27
Systems Acquisition 27
Outsourcing 28
Sources of Software 29
Choosing Off-the-Shelf Software 33
ix
x Contents
Reuse 36
Key Points Review 39 Key Terms Checkpoint 39 Review Questions 40 Problems and Exercises 40 Field Exercises 40 Case: Petrie’s Electronics 40
Chapter 3 Managing the Information Systems Project 42 Pine Valley Furniture Company Background 44
Managing the Information Systems Project 45
Initiating the Project 49
Planning the Project 53
Executing the Project 60
Closing Down the Project 63
Representing and Scheduling Project Plans 64
Representing Project Plans 66
Calculating Expected Time Durations Using PERT 67
Constructing a Gantt Chart and Network Diagram at Pine Valley Furniture 68
Using Project Management Software 71
Establishing a Project Starting Date 72
Entering Tasks and Assigning Task Relationships 72
Selecting a Scheduling Method to Review Project Reports 73
Key Points Review 74 Key Terms Checkpoint 75 Review Questions 76 Problems and Exercises 76 Discussion Questions 78 Case Problems 79 Case: Petrie’s Electronics 80
PART II SYSTEMS PLANNING AND SELECTION 82
Chapter 4 Systems Planning and Selection 82 Identifying and Selecting Projects 84
The Process of Identifying and Selecting Information Systems Development Projects 84
Deliverables and Outcomes 87
Initiating and Planning Systems Development Projects 88
The Process of Initiating and Planning Systems Development Projects 88
Deliverables and Outcomes 89
Assessing Project Feasibility 90
The post Business Process Reengineering