New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester AU601- Two wheeler & Three Wheeler
History of mopeds, scooters motorcycles, classification of 2 wheelers, mopeds, scooters, motorcycles; layout of moped, layout of scooter, layout of motorcycle, basic system, Basic system used in 2-3 wheelers: frame, wheelers & brakes, suspensions, engine, drive train, fuel system, ignition and electrical system, layout of passenger and loading rickshaw.
Basic cranking mechanism, push starting, moped cranking mechanism, kick start mechanism, layout of kick start mechanism, auto-start mechanism.
2-wheeler; steering geometry and effects, steering column construction, handlebar type and construction, suspension requirements, design considerations for suspension system, spring and shock absorber assembly, springer forks suspension, girder forks suspension, trailing and leading link suspension, 3-wheeler suspension system and brake.
Linear and angular motions, handling characteristics, road holding, vehicle stability, aerodynamics, squat and drive, Performance measurements.
Two and Three wheeler technology, Dhruv U. Panchal, :PHI Learning, 2015.
Irving. P.E., Motor cycle Engineering, Temple Press Book, London, 1992
The Cycle Motor Manual, Temple Press Ltd., London, 1990.
Encyclopedia of Motorcycling, 20 volumes, Marshall Cavensih, New York and London, 1989.
Bryaut. R.V., Vespa Maintenance and Repair series.
Raymond Broad, Lambretta – A practical guide to maintenance and repair, 1987
List of Experiments (Pl. expand it):
Comparative analysis of various brands of two wheelers in Indian Market.
Comparative study of Gear mechanism in Scooter.
Comparative study of Gear mechanism in Motorcycle.
Study of any three wheeler of Indian Market.
Study of any three wheeler pickup Van of Indian Market.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester AU602- Machine Component Design
Shingley J.E; Machine Design; TMH
Bhandari VB; Design of Machine Elements; TMH
Sharma and Purohit; Design of Machine elements; PHI
Wentzell Timothy H; Machine Design; Cengage learning
Mubeen; Machine Design; Khanna Publisher
Sharma & Agrawal; Machine Design; Kataria & sons
Designing and sketching of components contained in the syllabus
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Automotive batteries: Starter batteries- principle, construction & operation of lead-acid battery; battery capacity, efficiency & rating; tests on batteries; charging methods; battery faults; battery maintenance; maintenance-free batteries; Traction batteries: Applications; electric traction; electric drive vehicle layout.
Starter and charging systems: Requirements; principle, construction & working of starter motor; starting motor drive mechanisms; starter switch; starting system faults; Generating system: Working principle of dc generator & ac alternator; armature reaction; cut-out relay; voltage & current regulator systems.
Lighting and auxiliary systems: Development of lighting technology; principle of automobile illumination; head lights; tail lights; traffic lights; Auxiliary systems: Speedometer; electric horn; wind screen wipers; alarm systems; central locking system; immobilizer system; power windows; different types of gauges.
Electronic engine control and sensors: Need of electronic engine control; engine functions & control; electronic fuel control system; basic sensor arrangement; sensors & actuators; types of sensors-oxygen sensor, vehicle speed sensor, detonation sensor, maf sensor, map sensor, rpm sensor, throttle position sensor, temperature sensor.
Electronic fuel injection and ignition systems: Introduction; fuel back carburetor system; throttle body injection; multi point fuel injection; Robert Bosch gasoline fuel injection system; ford electronic gasoline fuel injection system; injection system controls; Ignition systems: Introduction; advantages of electronic ignition systems; principle, operation & types of solid state ignition system, electronic spark timing control.
Norm Chapman Delmar; Principles of Electricity and Electronics for Automotive; Cengage
BOSCH-SAE; Automotive Electrics & Electronics-
William B Ribbens- Newnes; Understanding Automotive Electronics-
Tom Denton; Automobile Electrical and Electronic Systems; SAE
Kanemitsu Nishio; Fundamentals of Automotive Engine Control Sensors; Fontis Media
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Fundamental of Soils and machinery; different equipments, purposes and operations;
Systems of Earth Moving Equipments: Engine-all systems of engine and special features like automatic timer, turbochargers, after coolers; Transmission: Basic types and planetary transmission constructional and working principles. Hydro shift automatic trans torque converters, retarders; Hydraulics: Basic components of hydraulic systems like pumps (types); control valves, relief valves and hydraulic motors; hydraulic cylinders, circuits and controls valves
John B. Llzedaw et-al; Tractors and their power units
Donald R. Hum and LGV Garner; Farm machinery and mechanism
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Fundamentals Of Robot : Robot – Definition – Robot Anatomy – Co-ordinate Systems, Work Envelope, types and classification – Specifications – Pitch, Yaw, Roll, Joint Notations, Speed of Motion, Pay Load – Robot Parts and Functions – Need for Robots – Different Applications
Robot Drive Systems And End Effectors : Pneumatic Drives – Hydraulic Drives – Mechanical Drives – Electrical Drives – D.C. Servo Motors, Stepper Motor, A.C. Servo Motors – Salient Features, Applications and Comparison of Drives End Effectors – Grippers – Mechanical Grippers, Pneumatic and Hydraulic Grippers, Magnetic Grippers, Vacuum Grippers; Two Fingered and Three Fingered Grippers; Internal Grippers and External Grippers; Selection and Design Considerations.
Sensors And Machine Vision : Requirements of a sensor, Principles and Applications of the following types of sensors– Position of sensors (Piezo Electric Sensor, LVDT, Resolvers, Optical Encoders, Pneumatic Position Sensors), Range Sensors (Triangulation Principle, Structured, Lighting Approach, Time of Flight Range Finders, Laser Range Meters), Proximity Sensors (Inductive, Hall Effect, Capacitive, Ultrasonic and Optical Proximity Sensors),Touch Sensors, (Binary Sensors, Analogue Sensors), Wrist Sensors, Compliance Sensors, Slip Sensors. Camera, Frame Grabber, Sensing and Digitizing Image Data – Signal Conversion, Image Storage, Lighting Techniques. Image Processing and Analysis –Data Reduction: Edge detection, Feature Extraction and Object Recognition-Algorithms. Applications – Inspection, Identification, Visual Serving and Navigation.
Robot Kinematics and Robot Programming: Forward Kinematics, Inverse Kinematics and Differences; Forward Kinematics and Reverse Kinematics of Manipulators with Two, Three Degrees of Freedom (In 2Dimensional), Four Degrees of Freedom (In 3 Dimensional) – Deviations and Problems. Teach Pendant Programming, Lead through programming, Robot programming Languages – VAL Programming – Motion Commands, Sensor Commands, End effecter commands, and Simple programs
Implementation And Robot Economics : RGV, AGV; Implementation of Robots in Industries – Various Steps; Safety Considerations for Robot Operations; Economic Analysis of Robots – Pay back Method, EUAC Method, Rate of Return Method.
M.P.Groover, “Industrial Robotics – Technology, Programming and Applications”, McGraw- Hill, 2001.
Saha S. “Introduction to Robotics”, TMH
Ghoshal Ashitava, “Robotics,-Fundamental Concepts and Analysis”, Oxford.
Yu Kozyhev, “Industrial Robots Handbook”, MIR Publications.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Introduction to optimization, engineering applications in brief, design constrains and objectives, classifications, classical optimization techniques, single and multi variable optimization with no constraints/ equality / inequality constraints.
Linear programming, definitions and theorems, standard forms of linear programming , algorithms, two phases of the simplex methods, duality in programming, decomposition of principle, sensitivity analysis, transportation problems, quadratic programming.
Non linear programming, unconstrained techniques one dimension minimization methods, elimination and interpolation methods, practical considerations, implementation in multivariable problems, comparisons, constrained optimization techniques, direct / indirect methods, test problems, trusses, welded beams, gear train design, heat exchanger design.
Dynamic programming, introduction, posynomial, geometrical programming, unconstraint/constraint minimization, applications of geometric programming, multistage decision processes, suboptimization and principles of optimality, computational procedures, linear programming as a case of dynamic programming, continuous dynamic programming, design of continuous beam, trusses,
Integer linear and non linear programming, graphical representation, stochastic programming, Introduction to genetic algorithm, neural network based optimization, practical aspect of optimization,
S.S. Rao, Engineering optimization, New Age International Publishers, ISBN: 8122411495
A. Ravindran, K. Ragsdell and G. Reklaitis, Engineering Opimization, John wiley &Sons
K. Deb, Optimization for Engineering Design, Prentice Hall of India
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Solar Radiation: Extra-terrestrial and terrestrial, radiation measuring instrument, radiation measurement and predictions. Solar thermal conversion: Basics, Flat plate collectors-liquid and air type. Theory of flat plate collectors, selective coating, advanced collectors, Concentrators: optical design of concentrators, solar water heater, solar dryers, solar stills, solar cooling and refrigeration. Solar photovoltaic: Principle of photovoltaic conversion of solar energy; Technology for fabrication of photovoltaic devices; Applications of solar cells in PV generation systems.
Wind energy characteristics and measurement: Metrology of wind speed distribution, wind speed statistics, Weibull, Rayleigh and Normal distribution, Measurement of wind data, Energy estimation of wind regimes; Wind Energy Conversion: Wind energy conversion principles; General introduction; Types and classification of WECS; Power, torque and speed characteristics. Power curve of wind turbine, capacity factor, matching wind turbine with wind regimes. Application of wind energy.
Production of biomass, Photosynthesis- C3 & C4 plants on biomass production. Biomass resources assessment. CO2 fixation potential of biomass. Classification of biomass. Physicochemical characteristics of biomass as fuel Biomass conversion routes: biochemical, chemical and thermochemical Biochemical conversion of biomass to energy: anaerobic digestion, biogas production mechanism, technology, types of digesters, design of biogas plants, installation, operation and maintenance of biogas plants, biogas plant manure-utilization and manure values. Biomass Gasification: Different types, power generation from gasification, cost benefit analysis of power generation by gasification.
Small Hydropower Systems: Overview of micro, mini and small hydro system; hydrology; Elements of turbine; Assessment of hydro power; selection and design criteria of turbines; site selection and civil works; speed and voltage regulation; Investment issue load management and tariff collection; Distribution and marketing issues. Ocean Energy: Ocean energy resources, ocean energy routs; Principle of ocean thermal energy conversion system, ocean thermal power plants. Principles of ocean wave energy and Tidal energy conversion.
Geothermal energy: Origin of geothermal resources, type of geothermal energy deposits, site selection geothermal power plants; Hydrogen Energy: Hydrogen as a source of energy, Hydrogen production and storage. Fuel Cells: Types of fuel cell, fuel cell system and sub-system, Principle of working, basic thermodynamics
Kothari, Singal & Rajan; Renewable Energy Sources and Emerging Technologies, PHI Learning
Khan, B H, Non Conventional Energy, TMH
Sukhatme and Nayak, Solar Energy, Principles of Thermal Collection and Storage, TMH.
Tiwari and Ghosal, Renewable Energy Resources: Basic principle & application, Narosa Publication.
Ravindranath NH and Hall DO, Biomass, Energy and Environment, Oxford University Press.
Godfrey Boyle, Renewable Energy: Power for a sustainable future, Oxford OUP.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
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.
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.
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, and data fragmentationhorizontal, vertical and mixed frangmentation.
Emerging Fields in DBMS : object oriented Database-basic idea and the model, object structure, object class, inheritance, multiple inheritance, object identity, data warehousingterminology, 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.
A Silberschatz, H.F. Korth, Sudersan, “Database System Concept”, MGH Publication.
C.J. Date “An introduction to Database System” 6th ed.
Elmasri & Navathe “Foundamentals of Database system”- III ed.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester AU601- Two wheeler & Three Wheeler
History of mopeds, scooters motorcycles, classification of 2 wheelers, mopeds, scooters, motorcycles; layout of moped, layout of scooter, layout of motorcycle, basic system, Basic system used in 2-3 wheelers: frame, wheelers & brakes, suspensions, engine, drive train, fuel system, ignition and electrical system, layout of passenger and loading rickshaw.
Basic cranking mechanism, push starting, moped cranking mechanism, kick start mechanism, layout of kick start mechanism, auto-start mechanism.
2-wheeler; steering geometry and effects, steering column construction, handlebar type and construction, suspension requirements, design considerations for suspension system, spring and shock absorber assembly, springer forks suspension, girder forks suspension, trailing and leading link suspension, 3-wheeler suspension system and brake.
Linear and angular motions, handling characteristics, road holding, vehicle stability, aerodynamics, squat and drive, Performance measurements.
Two and Three wheeler technology, Dhruv U. Panchal, :PHI Learning, 2015.
Irving. P.E., Motor cycle Engineering, Temple Press Book, London, 1992
The Cycle Motor Manual, Temple Press Ltd., London, 1990.
Encyclopedia of Motorcycling, 20 volumes, Marshall Cavensih, New York and London, 1989.
Bryaut. R.V., Vespa Maintenance and Repair series.
Raymond Broad, Lambretta – A practical guide to maintenance and repair, 1987
List of Experiments (Pl. expand it):
Comparative analysis of various brands of two wheelers in Indian Market.
Comparative study of Gear mechanism in Scooter.
Comparative study of Gear mechanism in Motorcycle.
Study of any three wheeler of Indian Market.
Study of any three wheeler pickup Van of Indian Market.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester AU602- Machine Component Design
Shingley J.E; Machine Design; TMH
Bhandari VB; Design of Machine Elements; TMH
Sharma and Purohit; Design of Machine elements; PHI
Wentzell Timothy H; Machine Design; Cengage learning
Mubeen; Machine Design; Khanna Publisher
Sharma & Agrawal; Machine Design; Kataria & sons
Designing and sketching of components contained in the syllabus
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Automotive batteries: Starter batteries- principle, construction & operation of lead-acid battery; battery capacity, efficiency & rating; tests on batteries; charging methods; battery faults; battery maintenance; maintenance-free batteries; Traction batteries: Applications; electric traction; electric drive vehicle layout.
Starter and charging systems: Requirements; principle, construction & working of starter motor; starting motor drive mechanisms; starter switch; starting system faults; Generating system: Working principle of dc generator & ac alternator; armature reaction; cut-out relay; voltage & current regulator systems.
Lighting and auxiliary systems: Development of lighting technology; principle of automobile illumination; head lights; tail lights; traffic lights; Auxiliary systems: Speedometer; electric horn; wind screen wipers; alarm systems; central locking system; immobilizer system; power windows; different types of gauges.
Electronic engine control and sensors: Need of electronic engine control; engine functions & control; electronic fuel control system; basic sensor arrangement; sensors & actuators; types of sensors-oxygen sensor, vehicle speed sensor, detonation sensor, maf sensor, map sensor, rpm sensor, throttle position sensor, temperature sensor.
Electronic fuel injection and ignition systems: Introduction; fuel back carburetor system; throttle body injection; multi point fuel injection; Robert Bosch gasoline fuel injection system; ford electronic gasoline fuel injection system; injection system controls; Ignition systems: Introduction; advantages of electronic ignition systems; principle, operation & types of solid state ignition system, electronic spark timing control.
Norm Chapman Delmar; Principles of Electricity and Electronics for Automotive; Cengage
BOSCH-SAE; Automotive Electrics & Electronics-
William B Ribbens- Newnes; Understanding Automotive Electronics-
Tom Denton; Automobile Electrical and Electronic Systems; SAE
Kanemitsu Nishio; Fundamentals of Automotive Engine Control Sensors; Fontis Media
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Fundamental of Soils and machinery; different equipments, purposes and operations;
Systems of Earth Moving Equipments: Engine-all systems of engine and special features like automatic timer, turbochargers, after coolers; Transmission: Basic types and planetary transmission constructional and working principles. Hydro shift automatic trans torque converters, retarders; Hydraulics: Basic components of hydraulic systems like pumps (types); control valves, relief valves and hydraulic motors; hydraulic cylinders, circuits and controls valves
John B. Llzedaw et-al; Tractors and their power units
Donald R. Hum and LGV Garner; Farm machinery and mechanism
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Fundamentals Of Robot : Robot – Definition – Robot Anatomy – Co-ordinate Systems, Work Envelope, types and classification – Specifications – Pitch, Yaw, Roll, Joint Notations, Speed of Motion, Pay Load – Robot Parts and Functions – Need for Robots – Different Applications
Robot Drive Systems And End Effectors : Pneumatic Drives – Hydraulic Drives – Mechanical Drives – Electrical Drives – D.C. Servo Motors, Stepper Motor, A.C. Servo Motors – Salient Features, Applications and Comparison of Drives End Effectors – Grippers – Mechanical Grippers, Pneumatic and Hydraulic Grippers, Magnetic Grippers, Vacuum Grippers; Two Fingered and Three Fingered Grippers; Internal Grippers and External Grippers; Selection and Design Considerations.
Sensors And Machine Vision : Requirements of a sensor, Principles and Applications of the following types of sensors– Position of sensors (Piezo Electric Sensor, LVDT, Resolvers, Optical Encoders, Pneumatic Position Sensors), Range Sensors (Triangulation Principle, Structured, Lighting Approach, Time of Flight Range Finders, Laser Range Meters), Proximity Sensors (Inductive, Hall Effect, Capacitive, Ultrasonic and Optical Proximity Sensors),Touch Sensors, (Binary Sensors, Analogue Sensors), Wrist Sensors, Compliance Sensors, Slip Sensors. Camera, Frame Grabber, Sensing and Digitizing Image Data – Signal Conversion, Image Storage, Lighting Techniques. Image Processing and Analysis –Data Reduction: Edge detection, Feature Extraction and Object Recognition-Algorithms. Applications – Inspection, Identification, Visual Serving and Navigation.
Robot Kinematics and Robot Programming: Forward Kinematics, Inverse Kinematics and Differences; Forward Kinematics and Reverse Kinematics of Manipulators with Two, Three Degrees of Freedom (In 2Dimensional), Four Degrees of Freedom (In 3 Dimensional) – Deviations and Problems. Teach Pendant Programming, Lead through programming, Robot programming Languages – VAL Programming – Motion Commands, Sensor Commands, End effecter commands, and Simple programs
Implementation And Robot Economics : RGV, AGV; Implementation of Robots in Industries – Various Steps; Safety Considerations for Robot Operations; Economic Analysis of Robots – Pay back Method, EUAC Method, Rate of Return Method.
M.P.Groover, “Industrial Robotics – Technology, Programming and Applications”, McGraw- Hill, 2001.
Saha S. “Introduction to Robotics”, TMH
Ghoshal Ashitava, “Robotics,-Fundamental Concepts and Analysis”, Oxford.
Yu Kozyhev, “Industrial Robots Handbook”, MIR Publications.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Introduction to optimization, engineering applications in brief, design constrains and objectives, classifications, classical optimization techniques, single and multi variable optimization with no constraints/ equality / inequality constraints.
Linear programming, definitions and theorems, standard forms of linear programming , algorithms, two phases of the simplex methods, duality in programming, decomposition of principle, sensitivity analysis, transportation problems, quadratic programming.
Non linear programming, unconstrained techniques one dimension minimization methods, elimination and interpolation methods, practical considerations, implementation in multivariable problems, comparisons, constrained optimization techniques, direct / indirect methods, test problems, trusses, welded beams, gear train design, heat exchanger design.
Dynamic programming, introduction, posynomial, geometrical programming, unconstraint/constraint minimization, applications of geometric programming, multistage decision processes, suboptimization and principles of optimality, computational procedures, linear programming as a case of dynamic programming, continuous dynamic programming, design of continuous beam, trusses,
Integer linear and non linear programming, graphical representation, stochastic programming, Introduction to genetic algorithm, neural network based optimization, practical aspect of optimization,
S.S. Rao, Engineering optimization, New Age International Publishers, ISBN: 8122411495
A. Ravindran, K. Ragsdell and G. Reklaitis, Engineering Opimization, John wiley &Sons
K. Deb, Optimization for Engineering Design, Prentice Hall of India
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
Solar Radiation: Extra-terrestrial and terrestrial, radiation measuring instrument, radiation measurement and predictions. Solar thermal conversion: Basics, Flat plate collectors-liquid and air type. Theory of flat plate collectors, selective coating, advanced collectors, Concentrators: optical design of concentrators, solar water heater, solar dryers, solar stills, solar cooling and refrigeration. Solar photovoltaic: Principle of photovoltaic conversion of solar energy; Technology for fabrication of photovoltaic devices; Applications of solar cells in PV generation systems.
Wind energy characteristics and measurement: Metrology of wind speed distribution, wind speed statistics, Weibull, Rayleigh and Normal distribution, Measurement of wind data, Energy estimation of wind regimes; Wind Energy Conversion: Wind energy conversion principles; General introduction; Types and classification of WECS; Power, torque and speed characteristics. Power curve of wind turbine, capacity factor, matching wind turbine with wind regimes. Application of wind energy.
Production of biomass, Photosynthesis- C3 & C4 plants on biomass production. Biomass resources assessment. CO2 fixation potential of biomass. Classification of biomass. Physicochemical characteristics of biomass as fuel Biomass conversion routes: biochemical, chemical and thermochemical Biochemical conversion of biomass to energy: anaerobic digestion, biogas production mechanism, technology, types of digesters, design of biogas plants, installation, operation and maintenance of biogas plants, biogas plant manure-utilization and manure values. Biomass Gasification: Different types, power generation from gasification, cost benefit analysis of power generation by gasification.
Small Hydropower Systems: Overview of micro, mini and small hydro system; hydrology; Elements of turbine; Assessment of hydro power; selection and design criteria of turbines; site selection and civil works; speed and voltage regulation; Investment issue load management and tariff collection; Distribution and marketing issues. Ocean Energy: Ocean energy resources, ocean energy routs; Principle of ocean thermal energy conversion system, ocean thermal power plants. Principles of ocean wave energy and Tidal energy conversion.
Geothermal energy: Origin of geothermal resources, type of geothermal energy deposits, site selection geothermal power plants; Hydrogen Energy: Hydrogen as a source of energy, Hydrogen production and storage. Fuel Cells: Types of fuel cell, fuel cell system and sub-system, Principle of working, basic thermodynamics
Kothari, Singal & Rajan; Renewable Energy Sources and Emerging Technologies, PHI Learning
Khan, B H, Non Conventional Energy, TMH
Sukhatme and Nayak, Solar Energy, Principles of Thermal Collection and Storage, TMH.
Tiwari and Ghosal, Renewable Energy Resources: Basic principle & application, Narosa Publication.
Ravindranath NH and Hall DO, Biomass, Energy and Environment, Oxford University Press.
Godfrey Boyle, Renewable Energy: Power for a sustainable future, Oxford OUP.
New Scheme Based On AICTE Flexible Curricula Automobile Engineering, VI-Semester
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.
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.
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, and data fragmentationhorizontal, vertical and mixed frangmentation.
Emerging Fields in DBMS : object oriented Database-basic idea and the model, object structure, object class, inheritance, multiple inheritance, object identity, data warehousingterminology, 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.
A Silberschatz, H.F. Korth, Sudersan, “Database System Concept”, MGH Publication.
C.J. Date “An introduction to Database System” 6th ed.
Elmasri & Navathe “Foundamentals of Database system”- III ed.