Design of Industrial Information Systems - 1st Edition - ISBN: 9780123704924, 9780080465531

Design of Industrial Information Systems

1st Edition

Authors: Thomas Boucher Ali Yalcin
Hardcover ISBN: 9780123704924
eBook ISBN: 9780080465531
Imprint: Academic Press
Published Date: 25th October 2006
Page Count: 496
Tax/VAT will be calculated at check-out
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


Design 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.

Key Features

  • 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.

Table of Contents

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 INSERT Keyword SELECT Keyword UPDATE Keyword DELETE Keyword 2.5.3 SQL: Converting Data into Information Aggregate Functions in SQL Grouping Data Subqueries in SQL 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 A Table in First Normal Form Conversion to Second Normal Form Conversion to Third Normal Form 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 Line Item Amount Freight (Estimate) Ordered by, Phone Number Vendor Item Number A Preliminary Data Model 5.3.2 Analysis of Information Requirements at Node A313 Supplier Date Received Quantity Manufacturing Lot No, Item Code, and Material Lot No Storage Location 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 Creating a Default Form Tailoring a Default Form 6.4.2 Providing User Interaction Adding Command Buttons Addressing Form Objects 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 Input Box Message Box Retrieving a Database Record 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 Designing the Master Form Designing Subforms 6.5.5 Designing a Subform Base on a Query Establishing the Query Creating the Subform form the Query Binding the Subform to the Master Form 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 Creating the Query Creating the Report Based on the Query Report Format 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 Combine and Cook Ingredients Mix Cooked Ingredients Fill Packages Weigh Packages Seal Packages Store Packages 7.2.2 System Redesign Objectives Plant Manager Quality Control Manager Production Line Supervisor Interview Summary 7.2.3 Defi ning “As Is” IDEF0 Model and Establishing System Boundaries Control Production Processes Decomposition of Node A0 Decomposition of Node A1 Decomposition of Node A2 Decomposition of Node A3 Decomposition of Node A4 Summary of “As Is” Model 7.3 Design Phase 7.3.1 Identifying User Information Needs 7.3.2 Defining Entities and Relationships Plant Manager View Quality Control Manager View 7.3.3 Defining Attributes Plant Manager View 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 Form Elements 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 An ADO Tutorial 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 Components of a Class Associations Generalization 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 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:
© Academic Press 2006
Academic Press
eBook ISBN:
Hardcover ISBN:

About the Author

Thomas Boucher

Affiliations and Expertise

Professor Industrial & Systems Engineering,Rutgers University, New Brunswick, New Jersey

Ali Yalcin

Affiliations and Expertise

Associate Professor Industrial & Management Systems Engineering,University of South Florida,Tampa, Florida