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)