Design of Industrial Information Systems book cover

Design of Industrial Information Systems

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.

Audience
upper level undergraduate and lower level graduate courses in industrial engineering and industrial management programs.

Hardbound, 496 Pages

Published: October 2006

Imprint: Academic Press

ISBN: 978-0-12-370492-4

Contents

  • Chapter 1Introduction1.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 2The Relational Database Model2.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) Contents2.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 3Data Modeling3.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 4Structured Analysis and Functional Architecture Design4.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 5Informational Architecture and Logical Database Design5.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, andMaterial 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 StoredMaterials 5.4 Summary Review Exercises Case Studies Chapter 6Design of a User Interface6.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 DeleteFunctions 1786.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 7Executing an Information System Design Project: A Case Study7.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 InformationModel 7.4 Implementation Phase 7.5 Summary Review Exercises Chapter 8E-business and Web-Enabled Databases8.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 9Unified Modeling Language9.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 10Workflow Management Systems10.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

Advertisement

advert image