Design of Industrial Information Systems
- 1st Edition - October 25, 2006
- Authors: Thomas Boucher, Ali Yalcin
- Language: English
- Hardback ISBN:9 7 8 - 0 - 1 2 - 3 7 0 4 9 2 - 4
- eBook ISBN:9 7 8 - 0 - 0 8 - 0 4 6 5 5 3 - 1
Design of Industrial Information Systems presents a body of knowledge applicable to many aspects of industrial and manufacturing systems. New software systems, such as Enterp… Read more
Purchase options
Institutional subscription on ScienceDirect
Request a sales quoteDesign of Industrial Information Systems presents a body of knowledge applicable to many aspects of industrial and manufacturing systems. New software systems, such as Enterprise Resource Planning, and new hardware technologies, such as RFID, have made it possible to integrate what were separate IT databases and operations into one system to realize the greatest possible operational efficiencies. This text provides a background in, and an introduction to, the relevant information technologies and shows how they are used to model and implement integrated IT systems.With the growth of courses in information technology offered in industrial engineering and engineering management programs, the authors have written this book to show how such computer-based knowledge systems are designed and used in modern manufacturing and industrial companies.
- Introduces Data Modeling and Functional Architecture Design, with a focus on integration for overall system design
- Encompasses hands-on approach, employing many in-chapter exercises and end-of-chapter problem sets with case studies in manufacturing and service industries
- Shows the reader how Information Systems can be integrated into a wider E-business/Web-Enabled Database business model
- Offers applications in Enterprise Resource Planning (ERP) and Manufacturing Execution Systems (MES)
upper level undergraduate and lower level graduate courses in industrial engineering and industrial management programs.
Chapter 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
1.4.2 Order Fulfi llment Management
1.4.3 Warehouse Management System
1.4.4 Quality Management
1.4.5 Human Resource Management
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 Classifi cations 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
Chapter 2
The Relational Database Model
2.1 Introduction
2.2 The Database Management System (DBMS)
2.3 The Relationship Database Viewed as a Set of Tables
2.4 Key Attributes and Linking Tables
2.5 Structured Query Language (SQL)
Contents
2.5.1 SQL: Creating the Database and Table Structure
2.5.2 SQL: Managing the Data in the Database Table
2.5.2.1 INSERT Keyword
2.5.2.2 SELECT Keyword
2.5.2.3 UPDATE Keyword
2.5.2.4 DELETE Keyword
2.5.3 SQL: Converting Data into Information
2.5.3.1 Aggregate Functions in SQL
2.5.3.2 Grouping Data
2.5.3.3 Subqueries in SQL
2.5.3.4 Appending Tables Using Joins
2.6 Summary
Review Exercises
Appendix 2A Query by Example
Chapter 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.4.4.1 A Table in First Normal Form
3.4.4.2 Conversion to Second Normal Form
3.4.4.3 Conversion to Third Normal Form
3.4.4.4 Denormalization
3.5 Summary
Review Exercises
Case Studies
Chapter 4
Structured Analysis and Functional Architecture Design
4.1 Introduction
4.2 Functional Architecture and Business Process Redesign
4.3 IDEF0 Methodology Modeling Primitives
4.4 IDEF0 Hierarchic Decomposition
4.4.1 Hierarchic Decompositions 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
Chapter 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.1.1 Line Item Amount
5.3.1.2 Freight (Estimate)
5.3.1.3 Ordered by, Phone Number
5.3.1.4 Vendor Item Number
5.3.1.5 A Preliminary Data Model
5.3.2 Analysis of Information Requirements at Node A313
5.3.2.1 Supplier
5.3.2.2 Date Received
5.3.2.3 Quantity Manufacturing Lot No, Item Code, and
Material Lot No
5.3.2.4 Storage Location
5.3.2.5 An Extended Data Model
5.3.3 Analysis of Information Requirements for the Control of Stored
Materials
5.4 Summary
Review Exercises
Case Studies
Chapter 6
Design of a User Interface
6.1 Introduction
6.2 The Functional/Entity Interaction Matrix
6.3 Screen Design
6.3.1 Form Specifi cation
6.3.2 Report Specifi cation
6.4 A Single Table Form
6.4.1 Implementing a Single Table Form in Microsoft Access
6.4.1.1 Creating a Default Form
6.4.1.2 Tailoring a Default Form
6.4.2 Providing User Interaction
6.4.2.1 Adding Command Buttons
6.4.2.2 Addressing Form Objects
6.4.2.3 Using Command Buttons for Insert, Update, and Delete
Functions 178
6.4.3 Implementing Data Integrity Requirements
6.4.4 Form Navigation
6.4.5 Implementing the Password
6.4.5.1 Input Box
6.4.5.2 Message Box
6.4.5.3 Retrieving a Database Record
6.4.5.4 A Completed Application
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.4.1 Designing the Master Form
6.5.4.2 Designing Subforms
6.5.5 Designing a Subform Base on a Query
6.5.5.1 Establishing the Query
6.5.5.2 Creating the Subform form the Query
6.5.5.3 Binding the Subform to the Master Form
6.5.5.4 Adding Derived Attributes to a Form
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.7.4.1 Creating the Query
6.7.4.2 Creating the Report Based on the Query
6.7.4.3 Report Format
6.7.4.4 Adding Derived Attributes to the Report
6.8 Organizing Forms and Reports into Applications
6.9 Database Password Security
6.10 Summary
Review Exercises
Case Studies
Chapter 7
Executing an Information System Design Project: A Case Study
7.1 Introduction
7.2 Preliminary Study and Problem Defi nition Phase
7.2.1 Description of Operations
7.2.1.1 Combine and Cook Ingredients
7.2.1.2 Mix Cooked Ingredients
7.2.1.3 Fill Packages
7.2.1.4 Weigh Packages
7.2.1.5 Seal Packages
7.2.1.6 Store Packages
7.2.2 System Redesign Objectives
7.2.2.1 Plant Manager
7.2.2.2 Quality Control Manager
7.2.2.3 Production Line Supervisor
7.2.2.4 Interview Summary
7.2.3 Defi ning “As Is” IDEF0 Model and Establishing System Boundaries
7.2.3.1 Control Production Processes
7.2.3.2 Decomposition of Node A0
7.2.3.3 Decomposition of Node A1
7.2.3.4 Decomposition of Node A2
7.2.3.5 Decomposition of Node A3
7.2.3.6 Decomposition of Node A4
7.2.3.7 Summary of “As Is” Model
7.3 Design Phase
7.3.1 Identifying User Information Needs
7.3.2 Defining Entities and Relationships
7.3.2.1 Plant Manager View
7.3.2.2 Quality Control Manager View
7.3.3 Defining Attributes
7.3.3.1 Plant Manager View
7.3.3.2 Quality Control Manager View
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
Chapter 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.2.10.1 Form Elements
8.2.10.2 Linking a Form to an ASP File
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.5.1 An ADO Tutorial
8.3.5.2 A Simple Database Retrieval Example
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
Chapter 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.5.1 Components of a Class
9.4.5.2 Associations
9.4.5.3 Generalization
9.4.5.4 Comparison Summary
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
Chapter 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 Structure, and Task Dependencies
10.4.1 Task Structure
10.4.2 Task Dependencies
10.4.2.1 Types of Control-Flow Dependencies
10.5 Modeling Workflows Using State Charts
10.5.1 Hierarchy
10.5.2 Dynamics
10.5.3 Modeling Control Flow Dependencies
10.6 Illustrative Example Using State Charts to Model Workflows
10.7 Analysis of Workflow Process Definitions
10.8 Summary
Review Exercises
Case Studies
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
1.4.2 Order Fulfi llment Management
1.4.3 Warehouse Management System
1.4.4 Quality Management
1.4.5 Human Resource Management
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 Classifi cations 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
Chapter 2
The Relational Database Model
2.1 Introduction
2.2 The Database Management System (DBMS)
2.3 The Relationship Database Viewed as a Set of Tables
2.4 Key Attributes and Linking Tables
2.5 Structured Query Language (SQL)
Contents
2.5.1 SQL: Creating the Database and Table Structure
2.5.2 SQL: Managing the Data in the Database Table
2.5.2.1 INSERT Keyword
2.5.2.2 SELECT Keyword
2.5.2.3 UPDATE Keyword
2.5.2.4 DELETE Keyword
2.5.3 SQL: Converting Data into Information
2.5.3.1 Aggregate Functions in SQL
2.5.3.2 Grouping Data
2.5.3.3 Subqueries in SQL
2.5.3.4 Appending Tables Using Joins
2.6 Summary
Review Exercises
Appendix 2A Query by Example
Chapter 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.4.4.1 A Table in First Normal Form
3.4.4.2 Conversion to Second Normal Form
3.4.4.3 Conversion to Third Normal Form
3.4.4.4 Denormalization
3.5 Summary
Review Exercises
Case Studies
Chapter 4
Structured Analysis and Functional Architecture Design
4.1 Introduction
4.2 Functional Architecture and Business Process Redesign
4.3 IDEF0 Methodology Modeling Primitives
4.4 IDEF0 Hierarchic Decomposition
4.4.1 Hierarchic Decompositions 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
Chapter 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.1.1 Line Item Amount
5.3.1.2 Freight (Estimate)
5.3.1.3 Ordered by, Phone Number
5.3.1.4 Vendor Item Number
5.3.1.5 A Preliminary Data Model
5.3.2 Analysis of Information Requirements at Node A313
5.3.2.1 Supplier
5.3.2.2 Date Received
5.3.2.3 Quantity Manufacturing Lot No, Item Code, and
Material Lot No
5.3.2.4 Storage Location
5.3.2.5 An Extended Data Model
5.3.3 Analysis of Information Requirements for the Control of Stored
Materials
5.4 Summary
Review Exercises
Case Studies
Chapter 6
Design of a User Interface
6.1 Introduction
6.2 The Functional/Entity Interaction Matrix
6.3 Screen Design
6.3.1 Form Specifi cation
6.3.2 Report Specifi cation
6.4 A Single Table Form
6.4.1 Implementing a Single Table Form in Microsoft Access
6.4.1.1 Creating a Default Form
6.4.1.2 Tailoring a Default Form
6.4.2 Providing User Interaction
6.4.2.1 Adding Command Buttons
6.4.2.2 Addressing Form Objects
6.4.2.3 Using Command Buttons for Insert, Update, and Delete
Functions 178
6.4.3 Implementing Data Integrity Requirements
6.4.4 Form Navigation
6.4.5 Implementing the Password
6.4.5.1 Input Box
6.4.5.2 Message Box
6.4.5.3 Retrieving a Database Record
6.4.5.4 A Completed Application
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.4.1 Designing the Master Form
6.5.4.2 Designing Subforms
6.5.5 Designing a Subform Base on a Query
6.5.5.1 Establishing the Query
6.5.5.2 Creating the Subform form the Query
6.5.5.3 Binding the Subform to the Master Form
6.5.5.4 Adding Derived Attributes to a Form
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.7.4.1 Creating the Query
6.7.4.2 Creating the Report Based on the Query
6.7.4.3 Report Format
6.7.4.4 Adding Derived Attributes to the Report
6.8 Organizing Forms and Reports into Applications
6.9 Database Password Security
6.10 Summary
Review Exercises
Case Studies
Chapter 7
Executing an Information System Design Project: A Case Study
7.1 Introduction
7.2 Preliminary Study and Problem Defi nition Phase
7.2.1 Description of Operations
7.2.1.1 Combine and Cook Ingredients
7.2.1.2 Mix Cooked Ingredients
7.2.1.3 Fill Packages
7.2.1.4 Weigh Packages
7.2.1.5 Seal Packages
7.2.1.6 Store Packages
7.2.2 System Redesign Objectives
7.2.2.1 Plant Manager
7.2.2.2 Quality Control Manager
7.2.2.3 Production Line Supervisor
7.2.2.4 Interview Summary
7.2.3 Defi ning “As Is” IDEF0 Model and Establishing System Boundaries
7.2.3.1 Control Production Processes
7.2.3.2 Decomposition of Node A0
7.2.3.3 Decomposition of Node A1
7.2.3.4 Decomposition of Node A2
7.2.3.5 Decomposition of Node A3
7.2.3.6 Decomposition of Node A4
7.2.3.7 Summary of “As Is” Model
7.3 Design Phase
7.3.1 Identifying User Information Needs
7.3.2 Defining Entities and Relationships
7.3.2.1 Plant Manager View
7.3.2.2 Quality Control Manager View
7.3.3 Defining Attributes
7.3.3.1 Plant Manager View
7.3.3.2 Quality Control Manager View
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
Chapter 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.2.10.1 Form Elements
8.2.10.2 Linking a Form to an ASP File
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.5.1 An ADO Tutorial
8.3.5.2 A Simple Database Retrieval Example
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
Chapter 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.5.1 Components of a Class
9.4.5.2 Associations
9.4.5.3 Generalization
9.4.5.4 Comparison Summary
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
Chapter 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 Structure, and Task Dependencies
10.4.1 Task Structure
10.4.2 Task Dependencies
10.4.2.1 Types of Control-Flow Dependencies
10.5 Modeling Workflows Using State Charts
10.5.1 Hierarchy
10.5.2 Dynamics
10.5.3 Modeling Control Flow Dependencies
10.6 Illustrative Example Using State Charts to Model Workflows
10.7 Analysis of Workflow Process Definitions
10.8 Summary
Review Exercises
Case Studies
- No. of pages: 496
- Language: English
- Edition: 1
- Published: October 25, 2006
- Imprint: Academic Press
- Hardback ISBN: 9780123704924
- eBook ISBN: 9780080465531
TB
Thomas Boucher
Affiliations and expertise
Professor Industrial & Systems Engineering,Rutgers University,
New Brunswick, New JerseyAY
Ali Yalcin
Affiliations and expertise
Associate Professor
Industrial & Management Systems Engineering,University of South Florida,Tampa, FloridaRead Design of Industrial Information Systems on ScienceDirect