05485nam 2200697Ia 450 991045862120332120200520144314.01-280-70763-197866107076380-08-046553-6(CKB)1000000000364117(EBL)281994(OCoLC)469396382(SSID)ssj0000293718(PQKBManifestationID)11214845(PQKBTitleCode)TC0000293718(PQKBWorkID)10274496(PQKB)10891170(MiAaPQ)EBC281994(Au-PeEL)EBL281994(CaPaEBR)ebr10151408(CaONFJC)MIL70763(EXLCZ)99100000000036411720061128d2006 uy 0engur|n|---|||||txtccrDesign of industrial information systems[electronic resource] /Thomas O. Boucher, Ali YalçinAmsterdam ;Boston Elsevierc20061 online resource (451 p.)Description based upon print version of record.1-4933-0079-2 0-12-370492-8 Includes bibliographical references and index.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 MANAGEMENT1.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 STRUCTURE2.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 FORMS3.5 SUMMARYREVIEW 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 PRIMITIVES4.6.2 HIERARCHIC DECOMPOSITION IN DFA4.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 EXERCISESCASE STUDIESDesign 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 cComputer integrated manufacturing systemsProduction managementManagement information systemsElectronic books.Computer integrated manufacturing systems.Production management.Management information systems.658.4038011670.285Boucher Thomas O283644Yalçin Ali993773MiAaPQMiAaPQMiAaPQBOOK9910458621203321Design of industrial information systems2275459UNINA