MG S6 Electronics and Instrumentation Syllabus

EI 010 601 Process Control Instrumentation

(Common to AI010 601 and  IC010 601)

Teaching scheme                                                                                                          Credits: 4
3 hours lecture and 1 hour tutorial per week

Objectives

        

1.         To study the basics of process control

2.         To study about the various controller modes and methods of tuning of controllers

3.         To give an idea about the construction , characteristics and applications of control valves

4.         To have a case study of distillation column control.

Module 1 (12 hours)

Process Control System: Need for process control, classification of process variables, Process characteristics: Process equation, degrees of freedom, modeling of simple systems – thermal, gas, liquid systems. Process lag, load disturbance and their effect on processes. Self-regulating processes, interacting and non interacting processes, Regulator and servo control. Piping and Instrumentation diagram- instrument terms and symbols.

Module 2 (12 hours)

Controller modes: Basic control action, two position (ON-OFF), multi-position, floating control modes. Continuous controller modes: Proportional, Integral, Derivative. Composite controller modes: P-I, P-D, P-I-D. response of controllers for different types of test inputs, electronic controllers to realize various control actions, selection of control mode for different processes, Integral wind-up and prevention. Auto/Manual transfer, Bumpless transfer.

Module 3 (12 hours)

Optimum Controller Settings: Controller tuning Methods- Process reaction curve method, Ziegler Nichols method, damped oscillation method, ¼ decay ratio. Evaluation criteria - IAE, ISE, ITAE. Response of controllers for different test inputs.  Selection of control modes for processes like level, pressure, temperature and flow.

Module 4 (12 hours)

Final control elements: I/P and P/I converter, Pneumatic and Electric actuators. Pneumatic control valves, classification, construction details (Globe, butterfly and ball valve types), various plug characteristics. Valve sizing, inherent and installed valve characteristics. Cavitation and flashing in control valves. Valve actuators and positioners. Selection of control valves.

Module 5 (12 hours)

Advanced control schemes: Cascade control, ratio control, feed forward control, Adaptive and Inferential control, split range and averaging control. Multivariable process control, interaction of control loops. Case Studies: Steam boiler – control of heat exchangers, drum level control and combustion. Distillation column – Control of top and bottom product compositions – Reflux ratio, control schemes in distillation column.

Text Books:

1.         George Stephenopoulos: Chemical Process Control,

2.         Donald P. Eckman, Automatic Process Control

3.         Peter Harriot : Process Control,TMH,1985.

4.         D R Coughanowr: Process Systems Analysis and Control, McGraw Hill.

References:

1.         Patranabis D: Principles of Process Control, TMH, 1981.

2.         B.G Liptak, Process Control, Chilton Book Company

EI 010 603  Industrial Instrumentation I

(Common to AI010 603 and IC010 603)

                                                        

Teaching scheme                                                                                              Credits: 4
3 hours lecture and 1 hour tutorial per week

Objectives

                  

1.         To provide exposure to various measuring techniques for force, torque velocity, acceleration, vibration, density, pressure and temperature.

2.         At the end of the course the student will have an indepth knowlwdge in units, different techniques, and significance of measuring devices. 

Module 1 (12 hours)

Measurement of Force, Torque, Velocity :-

Basic methods of measurement of force (weight) :scales and balances- mechanical balances- electro magnetic balance  – Different types of load cells :  hydraulic load cells -  pneumatic loadcell - magneto elastic (pressductor)- strain gauge loadcell - proving ring.

Different methods of torque measurement:  Strain gauge, Relative regular twist-measurement of torque with spur gears – and proximity sensors. 

Speed and velocity measurement: Revelution counter- Capacitive tachometer -Drag cup type tacho meter- D.C and A.C tacho generators – Stroboscope- translational velocity transducers. Velocity measurement using variable reluctance proximity pickup.  Calibration methods.

Module 2 (12 hours)

Measurement of acceleration, vibration and density :-

Accelerometers –  potentiometric type – LVDT-   Piezo-electric, capacitive - Strain gauge and variable reluctance type accelerometers.

Mechanical type vibration instruments – Seismic instrument as an accelerometer and vibrometer – measurement of relative motion - Calibration of vibration pick ups

Units of density, specific gravity and viscosity used in industries – Baume scale API scale – hydro meter- density measurement using LVDT- differential pressure method-  pressure head type densitometer – float type densitometer – Ultrasonic densitometer –  Bridge type gas densitometer-coriolis densitometer. .

Module 3 (12 hours)

Pressure measurement : - Units of pressure – different types of pressure- Manometers – Different types –errors in manometers-  Elastic type pressure gauges – Bourden tube - Bellows – Diaphragms – Electrical methods – Elastic elements with LVDT and strain gauges – potentiometric pressure transducers-  Capacitive type pressure gauge –Piezo electric pressure sensor –Resonator pressure sensor – optical pressure transducers- pressure switches-  Measurement of vacuum – McLeod gauge –Thermal vacuum gauges – Ionization gauge -Testing and calibration of pressure gauges – Dead weight tester- Bulk gauge(high pressure measurement).

Module 4 (12 hours)

Temperature measurement :-   Definitions and standards – Primary and secondary fixed points – Calibration of thermometers -  Different types of filled in system thermometer – Sources of errors in filled in systems and their compensation – Bimetallic thermometers – Electrical methods of temperature measurement – resistance thermometers-3 lead and 4 lead RTDs - Thermistors –Linearization techniques. 

Module 5 (12 hours)

                        

Thermocouples –thermocouple junctions- Law of thermocouple – Fabrication of industrial thermocouples– Signal conditioning of thermocouple output –– Commercial circuits for cold junction compensation –– Special techniques for measuring high temperature using thermocouples – Radiation methods of temperature measurement –Radiation fundamentals – Total radiation pyrometers – Optical pyrometer – infra red pyrometers- Two colour radiation pyrometer.- IC temperature sensors- fiber optic temperature measurement- calibration of temperature transducers.

Text Books

1.         A.K.Sawhney, A course in mechanical measurements and      Instrumentation–Dhanpat Rai and Sons, New Delhi, 1999.

2.         R. K. Jain, Mechanical and Industrial Measurements, Khanna Publishers, New Delhi, 1999.

 

References

1.         D.Patranabis, Principles of Industrial Instrumentation, Tata McGraw Hill Publishing Ltd., New Delhi, 1999.

2.         B.C.Nakra and K.K.Chaudary, Instrumentation Measurement and Analysis, Tata McGraw Hill Publishing Company Ltd., New Delhi, 1985.

3.         S.K.singh, industrial instrumentation and control, Tata McGraw Hill Publishing Ltd., New Delhi, 2006

EI 010 604  Data Acquisition and Communication

                                

Teaching scheme                                                                                              Credits: 4
3 hours lecture and 1 hour tutorial per week

Objectives

        

1.         To get an awareness of modern data acquisition system

2.         To help students understand different types of data acquisition boards.

3.         To give an idea about industrial communication systems.

Module 1 (12 hours)

Fundamentals of data acquisition: Transducers and sensors, Field wiring and communications cabling, Signal conditioning, Data acquisition hardware, Data acquisition software, Host computer.

Data acquisition and control system configuration : Computer plug-in I/O, Distributed I/O, Stand-alone or distributed loggers/controllers, IEEE 488 (GPIB) remote programmable instruments

Data acquisition boards: A/D Boards, Single ended vs differential signals, Resolution, dynamic range and accuracy of A/D boards, Sampling techniques, Speed vs throughput, D/A boards, Digital I/O boards, Interfacing digital inputs/outputs, Counter/timer I/O boards.

Module 2

Industrial Communication systems: Introduction, Historical background, standards, OSI Model, Protocols, Physical standards, Modern instrumentation and control systems, Distributed Control systems, PLC, Impact of microprocessor, Smart instrumentation systems. 

Basic Principles of Industrial Communication: bits, bytes and characters; Communication principles; Communication modes, asynchronous systems, synchronous systems, Error detection, Transmission characteristics, Data coding.

Module 3

Serial Communication: UART, Standards organization, serial data communications interface standards, balanced and unbalanced transmission lines, EIA-232 interface standard, Test equipment, Comparison of the EIA interface standards, the 20mA current loop.

Module 4

Modems and Multiplexers: Introduction, Modulation techniques, Components of a modem, Radio modem, Modem standards, Multiplexing concepts.

Module 5

Industrial Protocols: OSI layers, OSI model for industrial control application, HART protocol, CAN bus, Foundation Field bus.

Text Books

1.         John Park, Steve Mackay, Practical Data Acquisition for Instrumentation and Control Systems; Elsevier

2.         John Park, Steve Mackay, Practical Data Communication for Instrumentation and Control Elsevier

References:

1.         Joseph J. Carr, Data acquisition and control: microcomputer applications for scientists and engineers, Tab Professional and Reference Books.

2.         V.U.Bakshi U.A.Bakshi, Measurements And Instrumentation, Technical Publications.

3.         H. Rosemary Taylor, Data Acquisition for Sensor Systems, Chapman & Hall.

EI 010 605  Control Engineering II

(Common to AI010 605 )

Teaching scheme                                                                                              Credits: 4
2 hours lecture and 1 hour tutorial per week

Objectives

1.         To study the modeling of the systems using State Space methods

2.         To learn State variable analysis and design of continuous time systems

3.         To get an exposure to digital control systems.

4.         To understand the basic concepts of nonlinear systems

Module 1 (12 Hours)

System modeling using state variable approach -Limitation of Conventional Control Theory. Concepts of state variables and state model - State model for linear time invariant systems.-State space representation of dynamic systems – Nonuniqueness of state model-  Block diagram representations- State diagrams-  Lagrange’s equations .

Module 2 (12 Hours)

Transformation of state variables- State space representations of transfer functions- Solution of differential equations in state space form- Interpretation and properties of the state transition matrix - Solution by the Laplace transform - The resolvent - Transfer function from state model.

Module 3 (12 Hours)

State variable analysis - controllability and observability. Gilber test and Kalman’s tests. Design of regulators for single input single output systems, Bass- gura pole placement formula. Linear observers: Need of observers, Structure and properties of observers, Pole  placement for single output systems.

Module 4 (12 Hours)

Discrete time systems- Introduction to digital control system –Review of Z-transform and properties.- inverse z transform- z transform method for solving difference equations- Impulse sampling and data hold  circuits  -Zero order and First order hold – signal reconstruction –Practical aspects of the choice of sampling rate-Pulse transfer function - The Z and S domain relationships -Stability analysis - Jury's test-Bilinear transformation .

Module 5 (12 Hours)

Nonlinear systems- Behaviour of nonlinear systems-Common physical nonlinearities-The  phase plane method- basic concepts-  Singular points- Describing function method – Basic concepts-- Describing functions of  saturation and dead zone nonlinearities. – Stability of nonlinear systems- limit cycles.

(Detailed analysis  not required).

Text Books

1.         K. Ogata , Modern Control Engineering , Prentice Hall of India

2.         K. Ogata , Discrete Time Control Systems ,Prentice Hall Of India.

3.         M. Gopal , Digital Controls and State Variable Methods ,TMH Pub. Com.

4.         B. C. Kuo , Automatic Control Systems, Prentice Hall of India.

5.         J. Nagrath & M. Gopal ,Control System Engineering , New Age Int. (P) Ltd

6.         B.Friedland, Control System Design- An Introduction to state space methods- Mc      Graw Hill, Inc.N Y.

EI 010 606 L01 Digital System Design

Teaching Scheme                                                                                                        Credits:4

3 hours lecture and 1 hour tutorial per week

Objectives

1.         To design and implement combinational circuits using basic programmable blocks

2.         To design and implement synchronous sequential circuits

3.         To study the fundamentals of Verilog HDL

4.         Ability to simulate and debug a digital system described in Verilog HDL
 

Module 1 (12hours)

Introduction to Verilog HDL: Design units, Data objects, Signal drivers, Delays , Data types, language elements, operators, user defined primitives, modeling-data flow, behavioral, structural, Verilog implementation of simple combinational  circuits: adder, code converter, decoder, encoder, multiplexer, demultiplexer.

Module 2 (12 hours)

Combinational circuit implementation using Quine–McCluskey algorithm, Decoders, Multiplexers, ROM and PLA, Implementation of multi output gate implementations

Module 3 (12 hours)

Finite State Machines:  State diagram, State table, State assignments, State graphs, Capabilities and limitations of FSM, Meta stability, Clock skew, Mealy and Moore machines, Modelling of clocked synchronous circuits as mealy and Moore machines: serial binary adder, Sequence detector, design examples.

Module 4 (12 hours)

Digital System Design Hierarchy: State assignments, Reduction of state tables, Equivalent states, Determination of state equivalence using implication table, Algorithmic State Machine, ASM charts, Design example.

Module 5 (12 hours)

Verilog HDL implementation of binary multiplier, divider, barrel shifter, FSM, Linear feedback shift register, Simple test bench for combinational circuits.

References:

1.         Michael D.Ciletti, Advanced Digital design with Verilog HDL, Pearson Education, 2005.

2.         S. Brown & Z. Vranestic, Fundamentals of Digital Logic with Verilog HDL, Tata McGraw Hill, 2002.

3.         Samir Palitkar, Verilog HDL A Guide To Digital Design And Synthesis, Pearson, 2^nd edition, 2003.

4.         Peter J Ashenden “Digital Design, an embedded system approach using Verilog” Elsevier, 2008

5.         Frank Vahid, Digital Design, Wiley Publishers.

6.         T R Padmanabhan, Design through Verilog HDL, IEEE press, Wiley Inter science, 2002.

7.         Donald D Givone, Digital Principles and Design, Tata McGraw Hill, 2003.

8.         Wakerly J F, Digital Design Principles and Practices, PHI, 2008.

9.         Nazeih M Botros, HDL programming VHDL and Verilog, Dreamtech press, 2009

10.       David J. Comer, Digital Logic and State Machine Design, Oxford university press, 3^rd edition, 1995.

EI 010 606 L03 Computer networks

Teaching scheme                                                                                              Credits: 4
 3 hours lecture and 1 hour tutorial per week

Objectives

1)         To understand the concepts of computer networks

2)         To study the functions of different layers.

3)         To introduce IEEE standards employed in computer networking.

4)         To make the students to get familiarized with different protocols and network components.

Module 1 (12 hours)

Network goals -topologies- configurations-concept of internet- ISO-OSI 7 Layer Standard -peer processes-Functions of each layer-TCP/IP reference model - Transmission media -description and characteristics - base band and broad band transmission-synchronous and asynchronous -full duplex, half duplex links- Concepts of WAP technology.

Module 2 (12 hours)

MODEMS-serial communication standards - X-21 digital interface- Need for data link layer-stop and wait and sliding window protocol-HDLC-terminal handling- polling-multiplexing- concentration-virtual circuit and data-grams - routing -congestion control.

Module 3 (12 hours)

LAN- base band and broad band Lan’s - carrier sense networks-CSMA/CD -ring network- shared memory -IEEE802 standards-introduction to X-25.  Transport layer- design issues- establishing and releasing connection - flow control – buffering - crash recovery - a simple transport protocol on X-25.

Module 4 (12 hours)

Session layer- design issues -data exchange - dialogue management - synchronization- remote procedure call-client server model - Presentation layer-data presentation-compression- network security-privacy- cryptography- presentation layer in ARPANET.

Module 5 (12 hours)

Application layer - virtual terminal - file transfer protocol-E-mail-introduction to distributed system - ATM-protocol architecture -ATM logical connections -ATM cells -cell transmission- ATM adaptation layer -AAL protocols -basic principles of SDH and SONET.

References

1.         Computer Networks: Andrew S Tannenbaum, Pearson Education.

2.         An Engineering Approach to Computer Networking:  Keshav, Pearson Education.

3.         Computer Networking: A Top Down Approach:  Kurose Pearson Education.

4.         Computer Network & Internet:  Comer, Pearson Education.

5.         Data communication: Hausly

6.         Computer Networks, protocols standards   & interfaces, Uyless Balack

7.         Local Area Networks: William Stallings, Pearson Education.

8.         Understanding Data Communication and networks- 2nd ed-William A Shay (Vikas Thomson Learning)

EI 010 606 L04 Micro-controller Based System Design    

  

Teaching scheme                                                                                              Credits: 4
 3 hours lecture and 1 hour tutorial per week

Objectives

        

1.         To give an idea about micro controllers and its interfacing techniques.

2.         To get an exposure in microcontroller  programming

Module 1

Various logic families – features – comparison – PLA – PAL- GAL -comparison – combinational PAL – PAL with flip-flops – study of 16L8, 22V10 GAL – dual port RAM – FIFO – FPGA – gate arrays.

Module 2

Embedded C compiler – advantages – memory models – interrupt functions – code optimization – 89C2051 micro-controller- architecture-comparison with 89C51- design of a simple trainer circuit using 89C51/89C2051 µC. Introduction to latest micro controllers (ARM Processor/ PIC microcontrollers) - introduction, architecture (block diagram explanation only), Memory organization etc.

Module 3

Analog to digital converters- single slope, dual slope, successive approximation, sigma delta, flash – comparison – typical ICs – A/D interface – digital to analog converters – different types – D/A interface – optically isolated triac interface- design of a temperature control system- sensors - opto isolator -interfacing programs using C and assembly language-.

Module 4

Serial Communication :Serial bus standards – I2C bus, SPI bus – operation – timing diagrams  – 2 wire serial EEPROM – 24C04 – 3wire serial EEPROM – 93C46 – interfacing – serial communication standards – RS232, RS422, RS485 – comparison – MAX232 line driver/ receiver – interfacing –– universal serial bus – PCI bus - interfacing programs using C and assembly language – low voltage differential signaling – PC printer port – registers – interfacing.

Module 5

Real World Interfacing: Matrix key board interface – AT keyboard – commands – keyboard response codes – watch dog timers – DS1232 watch dog timer – real time clocks – DS1302 RTC – interfacing – measurement of frequency – phase angle – power factor – stepper motor interface – dc motor speed control – L293 motor driver – design of a position control system –– interfacing of DIP switch, LED, 7 segment display, alphanumeric LCD – relay interface – design of a traffic light control system – interfacing programs using C and assembly language.

References

1.         The 8051 Microcontroller: Muhammad Ali Mazidi, Pearson Education.

2.         The 8051 Microcontroller: Kenneth J Ayala, Penram International.

3.         Digital fundamentals: Floyd, Pearson Education.

4.         Programming and customizing the 8051 µC: Myke Predko, TMH

5.         Programming with ANSI C and turbo C: Kamthane, Pearson Education.

6.         Microcomputers and Microprocessors: John Uffenbeck, PHI.

7.         Web site of Atmel semiconductors – www.atmel.com

8.         PIC 16F877 data book

EI 010 606 L05 Telemetry and Remote Control

Teaching scheme                                                                                              Credits: 4
 3 hours lecture and 1 hour tutorial per week

Objectives

1.         To study the concepts of classical telemetry systems

2.         To get an exposure to radio and satellite telemetry systems.

3.         To learn the fundamentals of optical telemetering systems.

4.         To understand the essential principles of telecontrol systems and installation

Module 1

Fundamental concepts – functional blocks of telemetry and telecontrol systems -Telemetry methods- Classical ones- Pneumatic and electrical telemetry- Electrical telemetry systems-Voltage, current, position telemetry- Principles of optical telemetry. 

Module 2

Radio telemetry: RF modulation methods-  Multiplexing techniques- TDM, FDM –comparison-Transmission channels in landline and Radio telemetry.- Methods of data transmission in telemetry- FM/FM, PCM/FM  and PAM/AM techniques. Radio receiving techniques. Introduction to telemetry standards- Antennas for telemetry.

Module 3

The complete telemetry package. Special telemetry problems- Telemetry hardware and applications- bandwidth and noise restrictions.

Introduction to satellite telemetry- TT and C services, Digital Transmission system in satellite telemetry. Multiple access Techniques.

Module 4

Optical telemetry-optical fibres for signal transmission-source for fibre optic transmission-optical detectors-trends in fibre optic device development-examples of optical telemetry systems

Module 5

Analog and digital techniques in telecontrol-remote transmission-signaling-adjustment-guidance and regulation-reliability of telecontrol installations-design of telecontrol-Installations

References

1.         A.K. Sawhney, ’A course in electrical and electronic measurements and instrumentation ‘

2.         Patranabis ‘Telemetry Principles ‘References:

3.         D. Rodyy, J. Coolen, electronics communications, 4th edition, PH

4.         O.J. Strock, Introduction to Telemetry, ISA

5.         Grenburg E I-Handbook of Telemetry and Remote Control-McGraw Hill

6.         Swoboda G-Telecontrol methods and applications of Telemetry and Remote Control-Reinhold Publishing Company

EI 010 606 L06  Robotics and Automation

Teaching scheme                                                                                              Credits: 4
 3 hours lecture and 1 hour tutorial per week

Objectives

1.         To give a basic knowledge of robots and their types.

2.         To study in detail the power sources, sensors, manipulators, actuators, grippers involved with robots and kinematics.

3.         To learn about robot programming techniques.

Module 1

Basic concepts : - Definition and origin of robotics – Different types of robotics –Various generations of robots – Degrees of freedom – Asimov’s laws of robotics – Dynamic stabilization of robots.

Module 2

Power sources and sensors : - Hydraulic, Pneumatic and Electric drives. Sensors: Sensors in Robotics-Tactile Sensors- Proximity and Range Sensors-Uses – Machine vision – Ranging – Laser – Acoustic – Magnetic and Fiber optic.

Module 3

Manipulators, actuators and grippers : - Construction of manipulators – Manipulator dynamics and force control – Electronic and pneumatic manipulator control circuits – End effectors – U various types of grippers – Design considerations.

Module 4

Robot Programming: Types of programming- Leadthrough programming-A Robot Program as a Path in Space- Motion Interpolation- Capabilities and Limitations of Leadthrough Methods. Robotic languages- The textual Robot Languages- Generations-Structure-Motion Commands-workcell control.

Module 5

Case studies :- Mutiple robots – Machine interface – Robots in manufacturing and non-manufacturing  applications – Robot cell design – Selection of robot.

Text Books

1.         Mikell P. Weiss G.M., Nagel R.N., Odraj N.G., Industrial Robotics, McGraw Hill Singapore, 1996.

2.         Ghosh, Control in Robotics and Automation: Sensor Based Integration, Allied Publishers, Chennai, 1998.

References

1.         Deb.S.R., Robotics technology and flexible Automation, John Wiley, USA 1992.

2.         Asfahl C.R., Robots and manufacturing Automation, John Wiley, USA 1992.

3.         Klafter R.D., Chimielewski T.A., Negin M., Robotic Engineering – An integrated approach, Prentice Hall of India, New Delhi, 1994.

4.         Mc Kerrow P.J. Introduction to Robotics, Addison Wesley, USA, 1991.

5.         Issac Asimov I Robot, Ballantine Books, New York, 1986.

 EI010 606 L602: Database Management Systems

(Common to EC010 606 L02)

Objectives

·          To impart an introduction to the theory and practice of database systems.

·          To develop basic knowledge on data modelling and design of efficient relations.

·          To provide exposure to oracle database programming.

Module I         (10 hours)

 Basic Concepts - Purpose of Database Systems- 3 Schema Architecture and Data Independence- Components of DBMS –Data Models, Schemas and Instances-Data Modeling using the Entity Relationship Model-Entity types, Relationship Types, Weak Entity Types .

Module II        (14 hours)

Relational Model Concepts –Constraints – Entity Integrity and Referential Integrity, Relational Algebra -Select, Project, Operations from Set Theory, Join, OuterJoin and Division - Tuple Relational Calculus.

SQL- Data Definition with SQL - Insert, Delete and Update Statements in SQL, Defining Domains, Schemas and Constraints, Constraint Violations - Basic Queries in SQL - Select Statement, Use of Aggregate functions and Group Retrieval, Nested Queries, Correlated Queries – Views.

Module III      (12 hours)

Oracle Case Study : The Basic Structure of the Oracle System – Database Structure and its Manipulation in Oracle- Storage Organization in Oracle.- Programming in PL/SQL- Cursor in PL/SQL - Assertions – Triggers.

Indexing and Hashing Concepts -: Ordered Indices, Hash Indices, Dense and Sparse Indices, Multi Level Indices, Cluster Index, Dynamic Hashing.

Module IV       (11 hours)

 Database Design– Design Guidelines– Relational Database Design – Functional Dependency- Determination of Candidate Keys, Super Key, Foreign Key, Normalization using Functional Dependencies, Normal Forms based on Primary keys- General Definitions of First, Second and Third Normal Forms. Boyce Codd Normal Form– Multi-valued Dependencies and Forth Normal Form – Join Dependencies and Fifth Normal Form – Pitfalls in Relational Database Design.

Module V        (13 hours)

Introduction to Transaction Processing- Transactions- ACID Properties of Transactions- Schedules- Serializability of Schedules- Precedence Graph- Concurrency Control – Locks and Timestamps-Database Recovery

Query processing and Optimization- Translating SQL Queries into a Relational Algebra Computing Select, Project and Join

Object Relational Databases-Distributed Databases-Different Types-Fragmentation and Replication Techniques-Functions of DDBMS.

Reference Books

1. Elmsari and Navathe, Fundamentals of Database System, Pearson Education Asia,

     5^th Edition, New Delhi, 2008.

2. Henry F Korth, Abraham Silbershatz , Database System Concepts, Mc Graw Hill

6^td Edition, Singapore, 2011.

3. Elmsari  and Navathe, Fundamentals of Database System, Pearson Education Asia,

 3^rd Edition, New Delhi, 2005, for oracle

4. Alexis Leon and Mathews Leon, Database Management Systems, Leon vikas  

Publishers, New Delhi.                                                                                                            

5. Narayanan S, Umanath and Richard W.Scamell, Data Modelling and Database Design,Cengage Learning, New Delhi, 2009.
6. S.K Singh,Database Systems Concepts,Design and Applications, Pearson Education 

Asia, New Delhi, 2006.

7. Pranab Kumar Das Gupta, Database management System Oracle SQL And 

     PL/SQL, Easter Economy Edition, New Delhi, 2009

8.  C.J.Date , An Introduction to Database Systems,   Pearson Education Asia, 7^th Edition, New Delhi.
9. Rajesh Narang, Database Management Systems, Asoke  K ghosh , PHI Learning, New Delhi, 2009.
10. Ramakrishnan and Gehrke, Database Management Systems, Mc Graw Hill, 3^rd Edition , 2003.

EI 010 608 Mini Project

(Common to AI010 608)

Teaching Scheme       

 3 hours practical per week                                                                                          2 credits                                                                                              

The mini project will involve the design, construction, and debugging of an electronic system product approved by the department. The schematic and PCB design should be done using any of the standard schematic capture & PCB design software.  Each student may choose to buy, for his convenience, his own components and accessories. Each student must keep a project notebook. The notebooks will be checked periodically throughout the semester, as part of the project grade. The student should submit the report at the end of the semester. A demonstration and oral examination on the mini project also should be done at the end of the semester.