Front cover -- Title page -- Copyright page -- Table of contents -- Preface -- INTENDED AUDIENCE -- DISTINGUISHING FEATURES -- GUIDELINES FOR ALTERNATIVE COURSE STRUCTURES -- SUPPLEMENTARY MATERIALS -- ACKNOWLEDGMENTS -- 1 Introduction -- 1.1 INTRODUCTION -- 1.2 ERP/MES/CONTROL: A HIERARCHY OF INFORMATION -- 1.3 NETWORK ARCHITECTURE -- 1.4 SOME KEY APPLICATION AREAS OF AN INDUSTRIAL INFORMATION SYSTEM (IIS) -- 1.4.1 CUSTOMER RELATIONSHIP MANAGEMENT (CRM) -- 1.4.2 ORDER FULFILLMENT MANAGEMENT -- 1.4.3 WAREHOUSE MANAGEMENT SYSTEM (WMS) -- 1.4.4 QUALITY MANAGEMENT -- 1.4.5 HUMAN RESOURCE MANAGEMENT (HRM) -- 1.4.6 ACCOUNTING AND FINANCIAL MANAGEMENT -- 1.4.7 DISTRIBUTION SYSTEM AND SUPPLY CHAIN MANAGEMENT -- 1.5 INFORMATION SYSTEMS AND DECISION SUPPORT SYSTEMS -- 1.6 PRODUCTION SYSTEM CLASSIFICATIONS AND INFORMATION REQUIREMENTS -- 1.6.1 MECHANICAL FABRICATION INDUSTRIES -- 1.6.2 PROCESS INDUSTRIES -- 1.6.3 SERVICE INDUSTRIES -- 1.7 ABOUT THIS BOOK -- 1.8 SUMMARY -- 2 The Relational Database Model -- 2.1 INTRODUCTION -- 2.2 THE DATABASE MANAGEMENT SYSTEM (DBMS) -- 2.3 THE RELATIONAL DATABASE VIEWED AS A SET OF TABLES -- 2.4 KEY ATTRIBUTES AND LINKING TABLES -- 2.5 STRUCTURED QUERY LANGUAGE (SQL) -- 2.5.1 SQL: CREATING THE DATABASE AND TABLE STRUCTURE -- 2.5.2 SQL: MANAGING THE DATA IN THE DATABASE TABLE -- 2.5.3 SQL: CONVERTING DATA INTO INFORMATION -- 2.6 SUMMARY -- REVIEW EXERCISES -- APPENDIX 2A QUERY BY EXAMPLE -- 3 Data Modeling -- 3.1 INTRODUCTION -- 3.2 ENTITY-RELATIONSHIP (E-R) MODELING -- 3.2.1 E-R MODELING PRIMITIVES -- 3.2.2 THE DEGREE OF A RELATIONSHIP -- 3.2.3 COMPOSITE ENTITIES -- 3.2.4 RECURSIVE ENTITIES -- 3.2.5 SUPERCLASS AND SUBCLASS ENTITY TYPES -- 3.3 CASE STUDY IN DATA MODELING -- 3.4 NORMALIZATION -- 3.4.1 INSERTION ANOMALIES -- 3.4.2 DELETION ANOMALIES -- 3.4.3 UPDATE ANOMALIES -- 3.4.4 NORMAL FORMS -- 3.5 SUMMARY.

REVIEW EXERCISES -- CASE STUDIES -- 4 Structured Analysis and Functional Architecture Design -- 4.1 INTRODUCTION -- 4.2 FUNCTIONAL ARCHITECTURE AND BUSINESS PROCESS REDESIGN -- 4.3 IDEF0 METHODOLOGY MODELING PRIMATIVES -- 4.4 IDEF0 HIERARCHIC DECOMPOSITION -- 4.4.1 HIERARCHIC DECOMPOSITION ILLUSTRATED: NODE A0 -- 4.4.2 DECOMPOSITION OF NODE A0 -- 4.4.3 DECOMPOSITION OF NODE A3 -- 4.4.4 DECOMPOSITION OF NODE A31 -- 4.5 THE PROCESS OF MODEL DEVELOPMENT AND VALIDATION -- 4.6 DATA FLOW DIAGRAMS: AN ALTERNATIVE STRUCTURED ANALYSIS METHODOLOGY -- 4.6.1 DFA MODELING PRIMITIVES -- 4.6.2 HIERARCHIC DECOMPOSITION IN DFA -- 4.6.3 HIERARCHIC DECOMPOSITION ILLUSTRATED: NODE A32 -- 4.6.4 DECOMPOSITION OF CONTEXT DATA FLOW DIAGRAM -- 4.7 SUMMARY -- REVIEW EXERCISES -- CASE STUDIES -- 5 Informational Architecture and Logical Database Design -- 5.1 INTRODUCTION -- 5.2 THE IDEF REPRESENTATION OF ENTITY-RELATIONSHIP MODELING -- 5.3 A CASE STUDY IN DEVELOPING A DATA MODEL -- 5.3.1 ANALYSIS OF INFORMATION REQUIREMENTS AT NODE A311 -- 5.3.2 ANALYSIS OF INFORMATION REQUIREMENTS AT NODE A313 -- 5.3.3 ANALYSIS OF INFORMATION REQUIREMENTS FOR THE CONTROL OF STORED MATERIALS -- 5.4 SUMMARY -- REVIEW EXERCISES -- CASE STUDIES -- 6 Design of a User Interface -- 6.1 INTRODUCTION -- 6.2 THE FUNCTIONAL/ENTITY INTERACTION MATRIX -- 6.3 SCREEN DESIGN -- 6.3.1 FORM SPECIFICATION -- 6.3.2 REPORT SPECIFICATION -- 6.4 A SINGLE TABLE FORM -- 6.4.1 IMPLEMENTING A SINGLE TABLE FORM IN MICROSOFT ACCESS -- 6.4.2 PROVIDING USER INTERACTION -- 6.4.3 IMPLEMENTING DATA INTEGRITY REQUIREMENTS -- 6.4.4 FORM NAVIGATION -- 6.4.5 IMPLEMENTING THE PASSWORD -- 6.4.6 ADDING TITLES IN THE HEADER AREA -- 6.4.7 SUMMARY OF A SINGLE-TABLE FORM -- 6.5 FORMS BASED ON MORE THAN ONE TABLE -- 6.5.1 CREATING A MASTER/DETAIL FORM -- 6.5.2 ESTABLISHING RELATIONSHIPS IN ACCESS.

6.5.3 DESIGNING A FORM BASED ON ITS PURPOSE -- 6.5.4 DESIGNING A MASTER/DETAIL FORM FOR DATA ENTRY -- 6.5.5 DESIGNING A SUBFORM BASED ON A QUERY -- 6.5.6 SUMMARY OF A MASTER/DETAIL FORM -- 6.6 SOME ADDITIONAL ACCESS TOOLS -- 6.6.1 MACROS AND ACTIONS -- 6.6.2 UNBOUNDED TEXT BOXES -- 6.7 IMPLEMENTING A REPORT -- 6.7.1 LAYOUT OF THE REPORT -- 6.7.2 INTERACTION WITH TABLES -- 6.7.3 DERIVED ATTRIBUTES -- 6.7.4 IMPLEMENTING A REPORT IN ACCESS -- 6.8 ORGANIZING FORMS AND REPORTS INTO APPLICATIONS -- 6.9 DATABASE PASSWORD SECURITY -- 6.10 SUMMARY -- REVIEW EXERCISES -- CASE STUDIES -- APPENDIX 6A TABLES USED IN THE CHAPTER 6 EXERCISES -- APPENDIX 6B DATA FOR TRIAL EXERCISES -- APPENDIX 6C VISUAL BASIC FOR APPLICATIONS OVERVIEW -- APPENDIX 6D GROUP LEVEL AND USER LEVEL SECURITY -- 7 Executing an Information System Design Project: A Case Study -- 7.1 INTRODUCTION -- 7.2 PRELIMINARY STUDY AND PROBLEM DEFINITION PHASE -- 7.2.1 DESCRIPTION OF OPERATIONS -- 7.2.2 SYSTEM REDESIGN OBJECTIVES -- 7.2.3 DEFINING "AS IS" IDEF0 MODEL AND ESTABLISHING SYSTEM BOUNDARIES -- 7.3 DESIGN PHASE -- 7.3.1 IDENTIFYING USER INFORMATION NEEDS -- 7.3.2 DEFINING ENTITIES AND RELATIONSHIPS -- 7.3.3 DEFINING ATTRIBUTES -- 7.3.4 ESTABLISHING THE GLOBAL DATA MODEL -- 7.3.5 DEFINING SUPERCLASS/SUBCLASS RELATIONSHIPS -- 7.3.6 EVALUATING THE NEED FOR TRANSACTION ENTITIES -- 7.3.7 NORMALIZING THE DATA MODEL -- 7.3.8 FINALIZING AND VALIDATING A "TO BE" IDEF0 MODEL -- 7.3.9 FINALIZING AND VALIDATING AN IDEF1X GLOBAL INFORMATION MODEL -- 7.4 IMPLEMENTATION PHASE -- 7.5 SUMMARY -- REVIEW EXERCISES -- 8 E-Business and Web-Enabled Databases -- 8.1 INTRODUCTION -- 8.2 AN HTML TUTORIAL -- 8.2.1 WEB PAGE DESIGN EXAMPLE -- 8.2.2 HTML PAGE TAGS -- 8.2.3 HTML TEXT BODY FORMATTING TAGS -- 8.2.4 ALIGNMENT, POSITIONING, AND FONT CONTROL -- 8.2.5 LINKING TO OTHER WEB SITES AND WEB PAGES -- 8.2.6 USING IMAGES.

8.2.7 USING CASCADING STYLE SHEETS -- 8.2.8 USING FRAMES -- 8.2.9 LISTS -- 8.2.10 FORMS -- 8.3 ACTIVE SERVER PAGES -- 8.3.1 ADDING ASP CODE TO A WEB PAGE -- 8.3.2 ASP OBJECTS -- 8.3.3 PASSING DATA TO THE ASP FILE FROM A FORM -- 8.3.4 USING THE ASP SESSION OBJECT -- 8.3.5 USING ASP FOR DATABASE RETRIEVALS -- 8.3.6 DATABASE INTERACTION WITH FORMS -- 8.3.7 INSERTING NEW RECORDS INTO DATABASE TABLES -- 8.3.8 SUMMARY OF ASP -- 8.4 EXTENSIBLE MARKUP LANGUAGE (XML) -- 8.4.1 A WELL-FORMED XML DOCUMENT -- 8.4.2 VIEWING XML IN A BROWSER WINDOW -- 8.4.3 DOCUMENT TYPE DEFINITIONS -- 8.4.4 THE XML SCHEMA -- 8.4.5 PROCESSING XML FILES -- 8.5 SUMMARY -- REVIEW EXERCISES -- CASE STUDIES -- APPENDIX 8A INSTALLING INTERNET INFORMATION SERVER SOFTWARE -- APPENDIX 8B CREATING A DATA SOURCE NAME -- APPENDIX 8C TABLES OF THE ORDERS. MDB DATABASE -- APPENDIX 8D CORRECTING WRITE ERRORS WHEN USING MICROSOFT JET CONNECTION -- 9 Unified Modeling Language -- 9.1 INTRODUCTION -- 9.2 OBJECT-ORIENTED DESIGN CONCEPTS -- 9.3 UML DESIGN FORMALISMS -- 9.4 ARCHITECTURE DESIGN USING UML -- 9.4.1 USE CASE DIAGRAM -- 9.4.2 SEQUENCE DIAGRAM -- 9.4.3 ACTIVITY DIAGRAM -- 9.4.4 STATE CHART DIAGRAM -- 9.4.5 CLASS DIAGRAM -- 9.4.6 LOGICAL SYSTEM DESIGN AND IMPLEMENTATION -- 9.5 CASE STUDY: UNIVERSITY FOOD RECEIVING DEPARTMENT -- 9.5.1 USE CASE DIAGRAM -- 9.5.2 SEQUENCE DIAGRAM -- 9.5.3 ACTIVITY DIAGRAM -- 9.5.4 STATE CHART DIAGRAM -- 9.5.5 CLASS DIAGRAM -- 9.6 SUMMARY -- REVIEW EXERCISES -- 10 Workflow Management Systems -- 10.1 INTRODUCTION -- 10.2 CLASSIFICATION OF WORKFLOWS -- 10.2.1 TRANSACTION WORKFLOWS -- 10.2.2 AD HOC WORKFLOWS -- 10.2.3 CLASSIFICATION BASED ON WORKFLOW TECHNOLOGY -- 10.3 WORKFLOW MANAGEMENT SYSTEMS -- 10.4 WORKFLOW BASICS: TASKS, TASK STRUCTURES, AND TASK DEPENDENCIES -- 10.4.1 TASK STRUCTURE -- 10.4.2 TASK DEPENDENCIES -- 10.5 MODELING WORKFLOWS USING STATE CHARTS.

10.5.1 HIERARCHY -- 10.5.2 DYNAMICS -- 10.5.3 MODELING CONTROL-FLOW DEPENDENCIES USING ECA RULES -- 10.6 ILLUSTRATIVE EXAMPLE USING STATE CHARTS TO MODEL WORKFLOWS -- 10.7 ANALYSIS OF WORKFLOW PROCESS DEFINITIONS -- 10.8 SUMMARY -- REVIEW EXERCISES -- CASE STUDIES -- Bibliography -- Index.