CM4016 Manufacturing Information Systems Syllabus:

CM4016 Manufacturing Information Systems Syllabus – Anna University PG Syllabus Regulation 2021

OBJECTIVES:

 To introduce the evolution of order policies and agile manufacturing information systems
 To elaborate database terminologies, data models, data independence and trends in database
 To impart knowledge on database designing, normalization types and query languages
 To give an overview of modules involved in inventory, process flow and shop floor control
 To be acquainted with integration of the modules to function as a single application that aids different departments of factory

UNIT I INTRODUCTION

The Evolution of order policies, from MRP to MRP II to ERP – Agile Manufacturing Information Systems, Manufacturing Database Integration.

UNIT II DATABASE

Terminologies – Entities and attributes – Data models, schema and subschema – Data Independence – ER Diagram – UML notation for describing the enterprise–wide data objects- Trends in database.

UNIT III DESIGNING DATABASE

Hierarchical model – Network approach- Relational Database concepts, principles, keys,– functional dependency – Normalization types – relational operations- Query Languages-Case studies

UNIT IV MANUFACTURING CONSIDERATION

The product and its structure, inventory and process flow – Shop floor control Data structure and procedure – various models – the order scheduling module, Input/output analysis module, and stock status database – the complete IOM database.

UNIT V INFORMATION SYSTEM FOR MANUFACTURING

Parts oriented production information system – concepts and structure – Computerized production scheduling, online production control systems, Computer based production management system, computerized manufacturing information system -RFID-Telecommunication– case study.

OUTCOMES

At the end of this course, the students shall be able to
CO1: Perceive the evolution of order policies, agile manufacturing information systems and manufacturing database integration
CO2: Explain the database terminologies, data models, data independence and trends in database
CO3: Acquire knowledge on database designing, normalization types and query languages
CO4: Elaborate modules involved in inventory, process flow and shop floor control
CO5: Understand the integration of the modules to function as a single application that aids different departments of factory

REFERENCES

1. Date, C.J., ”An Introduction to Database Systems” Addison Wesley”, 8th Edn,. 2004.
2. Franjo, C., “Manufacturing Information & Data Systems Analysis, Design & Practice”, ButterworthHeinemann, 2002.
3. Kerr, R., “Knowledge based Manufacturing Management”, Addison-Wesley, 1991.
4. Oliver, G. and Wolfhard, K., “RFID in Manufacturing”, Kubach.vwe.,2008
5. Orlicky, G., “Material Requirements Planning”,Third edition McGraw-Hill, 2011.
6. Sartori, L.G., “Manufacturing Information Systems”, Addison-Wesley Publishing Company, 1988.
7. Weiming S, “Information Technology for Balanced Manufacturing Systems”, Springer, 2006.
8. www.ist.psu.edu
9. www.cse.wustl.edu (UML Notation Guide)