IP-506 RDBMS Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

Tags: RGPV, BE, IP syllabus, RDBMS syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 506 syllabus

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 506 RDBMS SYLLABUS
Revised Syllabus and Scheme Effective from July 2007

UNIT-I Introduction: Advantage of DBMS approach, various view of data, data independence, schema and sub-schema, primary concepts of data models, Database languages, transaction management, Database administrator and users, data dictionary, overall system architecture.
ER model: basic concepts, design issues, mapping constraint, keys, ER diagram, weak and strong entity sets, specialization and generalization, aggregation, inheritance, design of ER schema, reduction of ER schema to tables.

UNIT-II Domains, Relations and keys: domains, relations, kind of relations, relational database, various types of keys, candidate, primary, alternate and foreign keys.
Relational Algebra & SQL: The structure, relational algebra with extended operations, modifications of Database, idea of relational calculus, basic structure of SQL, set operations, aggregate functions, null values, nested sub queries, derived relations, modification of Database, join relation, DDL in SQL.

UNIT-III Relational Dependencies and Normalization: basic definitions, trivial and non trivial dependencies, closure set of dependencies and of attributes, irreducible set of dependencies, introduction to normalization, non loss decomposition, FD diagram, first second, third Normal forms, dependency preservation, BCNF, multivalued dependencies and forms normal form dependeny and fifth normal forms. Distributed Database: basic idea, distributed data storage, data replication, data fragmentationhorizontal, vertical and mixed frangmentation.

UNIT-IV Emerging Fields in DBMS : object oriented Database-basic idea and the model, object structure, object class, inheritance, multiple inheritance, object identity, data warehousing-terminology, definitions, characteristics, data mining and it’s overview, Database on www, multimedia Database-difference with conventional DBMS, issues, similarity based retrived continuous media data, multimedia data formats, video servers.

Unit V: Storage structure and file organizations: Overview of physical storage media, magnetic disksperformance and optimization, basic idea of RAID, organization, organization of records in files, basic concepts of indexing, ordered indices, basic idea of B-tree and B+-tree organization.
Network and hierarchical models: basic idea, data structure diagrams, DBTG model, implementations, tree structure diagram, implementation techniques, comparision of the three models.

References:
1. A Silberschatz, H.F. Korth, Sudersan “Database System Concept”=, MGH Publication.
2. C.J. Date “An introduction to Database System”=6th ed.
3. Elmasri & Navathe “Foundamentals of Database system”- III ed.

IP-505 Metal Casting and Metal Forming Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

Tags: RGPV, BE, IP syllabus, Metal Casting and Metal Forming syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 505 syllabus

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 05 Metal Casting and Metal Forming SYLLABUS

Revised Syllabus and Scheme of Examination Effective from July 2007

Unit-1 Metal Casting Processes: Advantages and limitations, applications, casting terms, sand mould making procedure, pattern allowances, core prints, pattern materials, types of patterns, mounding-sand composition, testing sand properties, sand preparation, casting technique of cast iron, steels and nonferrous alloys.

Unit-2 Melting Practices Cupola, capacity of a cupola, cupola operation, zones of cupola, cupola efficiency, melting furnaces for non –ferrous metals, classification of crucible furnaces, gating system, pouring basin, sprue, runner, gates, types of gates, riser, gating design, numerical simulation, main consideration in design and position of risers, types of risers, feeder location and shapes use of exothermic materials, use of chills.

Unit-3 Solidification and Special casting process: Solidification of casting, permanent mould casting, slush casting, die casting, centrifugal casting, investment casting, continuous casting, casting defects and their remedies, cleaning of castings, repair of casting, inspection of casting. solid modeling of castings, design for castability.

Unit-4 Metal Forming: Nature of plastic deformation, stress-strain relation inelastic and plastic deformation, concept of flow stress, deformation mechanism, hot and cold working, rolling principal, rolling stand arrangement, roll passes, breakdown passes, roll pass sequence, analysis of rolling, sheet metal working processes.

Unit-5 Forging, Extrusion and other Processes: Forging operations, forging design, drop forging die design, die inserts; Extrusion-principle, forward and backward extrusion, impact extrusion, hydrostatic extrusion, extruding tubes Wire drawing- rod and tube drawing, tube making, swaging.

References:
(1) Roa P.N; Manufacturing Technology-foundry, forming…;TMH
(2) Ravi B; Metal casting- CAD and Analysis; PHI
(3) Jain PL; principles of foundry technology; TMH
(4) Hennie & Roshanthall; Metal casting; Mcgraw Hill New York
(5) Chambell J.S; Manufacturing Science; Mcgraw Hill New York
(6) Sharma S.K;.Manufacturing Science; I.K.International New Delhi
(7) Lindberg; Manufacturing Technology; Pretince Hall New Delhi

List of Experiment (Pl. expand it):
1. Solid modeling of casting parts using design for casting on software
2. Pattern making and sand molding using the solid model prepared in 1 above
3. Casting of molds prepared in 2 above
4. Design of Ggating system for casting using software and making physical models
5. Design and fabrication of metal forming parts
6. Design and fabrication of forging parts

IP-504 Computer Aided Design and Engg Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

Tags: RGPV, BE, IP syllabus, Computer Aided Design and Engg syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 504 syllabus

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 504 Computer Aided Design and Engg. SYLLABUS
Revised Syllabus and Scheme of Examination Effective from July 2007

Unit I: Fundamental of CAD, computer graphics, hardware and software, interactive hardware/software techniques, geometry creation, drawing standards, dimensioning and text writing, concept of layers, advanced concepts of CAD software- blocks, UCS, 3D-line, 3D object, DXF & DXB file formats.

Unit-II Geometric modeling- introduction, wire frame model, data structures for computer graphics, review of vector algebra, lines, circle, ellipses, parabolas, hyperbolas, conics, parametric representation of synthetic curves: hermite cubic splines, bezier curve, b spline curves, rational curves.

Unit-III 2Dand 3D geometric transformations, homogenous coordinates, translation, rotation, scaling, reflection, shear, and transformations between coordinate systems, affine transformations.3-D geometric transformations, 3-D viewing operations and graphics projections, visual realism, hidden line removal, shading and color models.

Unit-IV Extending the capability of CAD- rapid prototyping, stereo lithography, selective laser sintering, 3d printing, introduction to finite element analysis, solution of finite element equation-higher order and iso-parametric elements, equilibrium problems in structural mechanics, eigen value problems, overview of modeling software like- PRO-E, IDEA, CATIA, SOLID EDGE

Unit V introduction to optimization & its applications, classification of optimization problem, single variable optimization, multivariable optimization with no constraints, multivariable optimization with inequality constraints, One dimensional minimization methods, elimination method (unrestricted search), exhaustive search (Fibonacci method)

References:
1. Rao P N; CAD/CAM – Principle and application; TMH
2. Gokhle Nitin et al; Practical Finite Element Analysis; Finite to Infinite, 686 BudhwarPeth, Pune
3. Zeid Ibrahim, Sivasubramanian R; CAD/CAM; TMH
4. Alavala CR; CAD/CAM; PHI
5. Rogers and Adams; Mathematical Elements for Computer Graphics; McGraw-Hill
6. Hearn and Baker; Computer Graphics (C Version); Prentice Hall,
7. Foley, Van Dam, Feiner, Hughes; Computer Graphics: Principles and Practice; Addison Wesley
8. Omura J; Mastering Auto Cad
9. Rao S. S; Optimization & its Application; Wiley Eastern

List of Experiment (Pl. expand it):
1. Preparation of 2-D drawings for machine components (bolts, nuts, flange coupling, connecting rod, Auto components).
2. 3-D modeling - solid, surface, wireframe using standard CAD packages - Assembly of standard
parts created using 3-D model.
3. Creation of 2-D drawings from 3-D models using CAD packages, different views, sections, Isometric view and dimensioning them.
4. Parametric modeling, creating standard machine parts, connecting rod, flange coupling, bearings
5. Analysis of simple machine parts by meshing into finite elements

IP-503 Metrology Measurement & control Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

Tags: RGPV, BE, IP syllabus, Metrology Measurement & control syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 503 syllabus

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 503 Reliability and Maintenance SYLLABUS
Revised Syllabus and Scheme of Examination Effective from July 2007

UNIT 1 Transmission requirements: requirements of transmission system, general arrangement of power transmission, general arrangement of rear-engine vehicle with live axles, general arrangement of dead- axle and axles transmission; four-wheel-drive transmission.

Unit 2 Clutches Requirements of clutches, principle of friction clutches, types of clutches and materials used- cone, single-plate, diaphragm-spring, multi-plate, centrifugal, over-running and ferlecelectromagnetic clutch.

Unit 3 Gear box: Need of gear boxes, types- sliding mesh, constant mesh and epicyclic, gear boxes; synchronizers: principle, early and later Warner synchronizer, Vauxhall synchronizer- gear materialslubrication and design of gear box; Hydrodynamic drive: Advantages and limitations, principle of fluid coupling, constructional details, torque-capacity performance characteristics, drag torque, methods of minimizing drag torque; Torque converter: performance characteristics; single, multistage and polyphase torque converters, converter-coupling-performance characteristics, coupling-blade angle and fluid flow, converter fluid.

Unit-4 Transmission systems-Drive line: Definition, forces & torques acting; types of drives-Hotchkiss, torque tube & radius rod drives; components- propeller shaft, slip joint, universal joints & constant velocity universal joints; front wheel drive; Final drive: definition; types- worm-wheel, straight-bevel gear, spiral-bevel gear & hypoid-gear drives; double-reduction & twin-speed final drives; Differential: Function, principle, construction and working; non-slip differential; differential lock; rear axle- loads acting & types; multi-axled vehicles.

Unit 5 Automatic transmission: Chevrolet “turbo glide” transmission, power glide transmission, hydraulic control system of automatic transmission; Electric drive: advantages and limitations, principle of early and modified Ward-Leonard system, modern electric drive for buses; performance characteristics.

References:
1 Heldt P.M.; Torque converters; Chilton Book Co.
2 Giri NK; Automobile Engineering; Khanna Publisher
3 .Newton, Steeds & Garret; Motor Vehicles; B.H. Publication.
4. Judge, A.W., Modern Transmission Systems, Chapman & Hall Ltd.
5. Check Chart; Automatic Transmission; Harper & Row Publication.
List of Experiments (Pl. expand it):
1. Study of transmission of front and rear engine vehicles
2. Study of front and rear-wheel-drive vehicle
3. Study of four wheel-drive vehicles
4. Study of various gear boxes and presynchronization systems
5. Study of fluid couplings, hydrodynamic drives and torque converters
6. Automatic transmission system study
7. Electric drive vehicle study

IP-502 Reliability and Maintenance Revised syllabus Industrial and Production Engineering(IP) RGPV / RGTU B.E. IP, 5th (V) Semester syllabus

Tags: RGPV, BE, IP syllabus, Reliability and Maintenance syllabus, B.E. Industrial and Production Engineering, IP V Semester syllabus, IP 5th Semester syllabus, RGPV IP 502 syllabus

Rajiv Gandhi Technological University, Bhopal (MP)
B.E. (IP) Industrial and Production Engineering FOURTH IV SEMESTER
IP 502 Reliability and Maintenance SYLLABUS
Revised Syllabus and Scheme of Examination Effective from July 2007

Unit 1 Basic Concepts of Reliability: Probability distributions used in maintenance engineering- Binomial, Poisson, Exponential, Normal, Log-normal, Gamma and Weibull distribution; failure rate, hazard rate, failure modes, MTTR, MTBF, MTTF

Unit 2 System Reliability Models: System reliability–n-component series systems, m-component parallel systems and combined system; standby systems; K-out-of-m systems; redundancy techniques in system design; event space, decomposition (Key Stone), cut and tie sets, Markov analysis, reliability and quality, unreliability, maintainability, availability

Unit 3 Maintenance Concepts and Strategies: Introduction, maintenance functions and objectives, maintenance planning and scheduling, maintenance organization.
General Introduction to Maintenance Types: Breakdown, emergency, corrective, predictive, and
preventive; maintenance prevention; design-out maintenance, productive maintenance, shutdown maintenance and scheduled maintenance.

Unit 4 Condition Based Maintenance: Principles of CBM, pillars of condition monitoring, CBM implementation and benefits; condition monitoring techniques- visual monitoring, vibration monitoring, wear debris monitoring, corrosion monitoring, performance monitoring

Unit 5 Reliability Centered Maintenance (RCM):– Concept, methodology, benefits; Total Productive Maintenance: Evolution of TPM, TPM objectives, concept, pillars of TPM. Failure Modes and Effects Analysis (FMEA)/ Failure Modes, Effects and Criticality Analysis (FMECA): Overview, elements of FMECA, applications and benefits, risk evaluation, risk priority numbers,
criticality analysis, process FMEA, qualitative and quantitative approach to FMECA; design FMEA and steps for carrying out design FMEA

References:
Modarre; Reliability and Risk Analysis, Marcel Dekker Inc
Ebeling CE; An Introduction To Reliability & Maintainability Engg; John Wiley and Sons
Davidson John; The Reliability of mechanical system; Institution of Mech. Engineers, London
Patrick D.T and O.’Connor; Practical Reliability Engineerin; John Wiley and Sons
Srinath L.S; Reliability Engineering; East West Press.
Mishra R.C; Reliability and Maintenance Engineering; New age International publisher.
Kelly Anthony; Maintenance Planning and Control
R.C. Mishra and Pathak; Maintenance Engineering and Management;PHI.