Engineering tools, Science and Technology Articles and Comments by Deekshith Allamaneni

Sunday, May 15, 2011

JNTU ECE 4-1 R07 Syllabus View And Download (PDF)

Here is the complete syllabus of Jawaharlal Nehru Technological University Hyderabad (JNTUH) for the course Electronics And Communications Engineering 4th year 1st semester R07 regulation. Preferred textbooks and reference books anong with credits included.

[DOWNLOAD THE UPDATED SYLLABUS BY CLICKING HERE. OPTICAL COMMUNICATIONS NOT INCLUDED HERE. CLICK HERE TO VIEW UPDATED POST FOR FULL SYLLABUS]






COMPUTER NETWORKS
Credits: T: 4+1*    P:0    C:4
UNIT – I: Introduction : OSI, TCP/IP and other networks models, Examples of Networks: Novell Networks ,Arpanet, Internet, Network Topologies WAN, LAN, MAN.
UNIT – II: Physical Layer : Transmission media copper, twisted pair wireless, switching and encoding asynchronous communications; Narrow band, broad band ISDN and ATM.
UNIT – III: Data link layer : Design issues, framing, error detection and correction, CRC, Elementary Protocol-stop and wait, Sliding Window, Slip, Data link layer in HDLC, Internet, ATM.
UNIT – IV: Medium Access sub layer : ALOHA, MAC addresses, Carrier sense multiple access. IEEE 802.X Standard Ethernet, wireless LANS. Bridges,
UNIT – V: Network Layer : Virtual circuit and Datagram subnets-Routing algorithm shortest path routing, Flooding, Hierarchical routing, Broad cast, Multi cast, distance vector routing.
UNIT – VI: Dynamic routing – Broadcast routing. Rotary for mobility. Congestion, Control Algorithms – General Principles – of Congestion prevension policies. Internet working: The Network layer in the internet and in the ATM Networks.
UNIT –VII: Transport Layer: Transport Services, Connection management, TCP and UDP protocols; ATM AAL Layer Protocol.
UNIT – VIII: Application Layer – Network Security, Domain name system, SNMP, Electronic Mail; the World WEB, Multi Media.
TEXT BOOKS :
1. Computer Networks — Andrew S Tanenbaum,4th Edition. Pearson Education/PHI.
2. Data Communications and Networking – Behrouz A. Forouzan.Third Edition TMH.
REFERENCES :
1. An Engineering Approach to Computer Networks-S.Keshav, 2nd Edition, Pearson Education.
2. Understanding communications and Networks, 3rd Edition, W.A. Shay, Thomson.







ELECTRONIC MEASUREMENTS AND INSTRUMENTATION
Credits: T: 4+1*    P:0    C:4


UNIT I: Performance characteristics of instruments, Static characteristics, Accuracy, Resolution, Precision, Expected value, Error, Sensitivity. Errors in Measurement, Dynamic Characteristics-speed of response, Fidelity, Lag and Dynamic error. DC Voltimeters- Multirange, Range extension/Solid state and differential voltmeters, AC voltmeters- multi range, range extension, shunt. Thermocouple type RF ammeter, Ohmmeters series type, shunt type, Multimeter for Voltage, Current and resistance measurements.
UNIT II: Signal Generator- fixed and variable, AF oscillators, Standard and AF sine and square wave signal generators, Function Generators, Square pulse, Random noise, sweep, Arbitrary waveform.
UNIT III: Wave Analyzers, Haromonic Distortion Analyzers, Spectrum Analyzers, Digital Fourier Analyzers.
UNIT IV: Oscilloscopes CRT features, vertical amplifiers, horizontal deflection system, sweep, trigger pulse, delay line, sync selector circuits, simple CRO, triggered sweep CRO, Dual beam CRO, Measurement of amplitude and frequency.
UNIT V: Dual trace oscilloscope, sampling oscilloscope, storage oscilloscope, digital readout oscilloscope, digital storage oscilloscope, Lissajous method of frequency measurement, standard specifications of CRO, probes for CRO- Active & Passive, attenuator type, Frequency counter, Time and Period measurement.
UNIT VI: AC Bridges Measurement of inductance- Maxwell’s bridge, Anderson bridge. Measurement of capacitance - Schearing Bridge. Wheat stone bridge. Wien Bridge, Errors and precautions in using bridges. Q-meter.
UNIT VII: Transducers- active & passive transducers : Resistance, Capacitance, inductance; Strain gauges, LVDT, Piezo Electric transducers, Resistance Thermometers, Thermocouples, Thermistors, Sensistors.
UNIT VIII: Measurement of physical parameters force, pressure, velocity, humidity, moisture, speed, proximity and displacement. Data acquisition systems.
TEXTBOOKS :
1. Electronic instrumentation, second edition - H.S.Kalsi, Tata McGraw Hill, 2004.
2. Modern Electronic Instrumentation and Measurement Techniques – A.D. Helfrick and W.D. Cooper, PHI, 5th Edition, 2002.
REFERENCES :
1. Electronic Instrumentation & Measurements - David A. Bell, PHI, 2nd Edition, 2003.
2. Electronic Test Instruments, Analog and Digital Measurements - Robert A.Witte, Pearson Education, 2nd Ed., 2004.
3. Electronic Measurements & Instrumentations by K. Lal Kishore, Pearson Education – 2005.





CELLULAR AND MOBILE COMMUNICATIONS
Credits: T: 4+1*    P:0    C:4


UNIT I: CELLULAR MOBILE RADIO SYSTEMS: Introduction to Cellular Mobile System, Performance criteria, uniqueness of mobile radio environment, operation of cellular systems, Hexagonal shaped cells, Analog and Digital Cellular systems.
UNIT II: ELEMENTS OF CELLULAR RADIO SYSTEM DESIGN : General description of the problem, concept of frequency channels, Co-channel Interference Reduction Factor, desired C/I from a normal case in a omni directional Antenna system, Cell splitting, consideration of the components of Cellular system.
UNIT III: INTERFERENCE : Introduction to Co-Channel Interference, real time Co-Channel interference, Co-Channel measurement, design of Antenna system, Antenna parameters and their effects, diversity receiver, non-co-channel interference-different types.
UNIT IV: CELL COVERAGE FOR SIGNAL AND TRAFFIC : Signal reflections in flat and hilly terrain, effect of human made structures, phase difference between direct and reflected paths, constant standard deviation, straight line path loss slope, general formula for mobile propagation over water and flat open area, near and long distance propagation antenna height gain, form of a point to point model.
UNIT V: CELL SITE AND MOBILE ANTENNAS : Sum and difference patterns and their synthesis, omni directional antennas, directional antennas for interference reduction, space diversity antennas, umbrella pattern antennas, minimum separation of cell site antennas, high gain antennas.
UNIT VI: FREQUENCY MANAGEMENT AND CHANNEL ASSIGNMENT : Numbering and grouping, setup access and paging channels channel assignments to cell sites and mobile units, channel sharing and borrowing, sectorization, overlaid cells, non fixed channel assignment.
UNIT VII: Handoff, dropped calls and cell splitting, types of handoff, handoff invitation, delaying handoff, forced handoff, mobile assigned handoff. Intersystem handoff, cell splitting, micro cells, vehicle locating methods, dropped call rates and their evaluation.
UNIT VIII: DIGITAL CELLULAR NETWORKS : GSM architecture, GSM channels, multiplex access scheme , TDMA, CDMA.
TEXTBOOKS :
1. Mobile Cellular Telecommunications – W.C.Y. Lee, Tata McGraw Hill, 2rd Edn., 2006.
2. Principles of Mobile Communications – Gordon L. Stuber, Springer International 2nd Edition, 2007.
REFERENCES :
1.Wireless Communications - Theodore. S. Rapport, Pearson education, 2nd Edn., 2002.
2.Wireless and Mobile Communications – Lee McGraw Hills, 3rd Edition, 2006.
3.Wireless Communication and Networking – Jon W. Mark and Weihua Zhqung, PHI, 2005.
4. Wireless Communication Technology – R. Blake, Thompson Asia Pvt. Ltd., 2004.







RADAR SYSTEMS
Credits: T: 4+1*    P:0    C:4


UNIT I: Introduction Nature of Radar, Maximum Unambiguous Range, Radar Waveforms, Simple form of Radar Equation, Radar Block Diagram and Operation, Radar Frequencies and Applications. Related Problems.
UNIT II: Radar Equation : Prediction of Range Performance, Minimum Detectable Signal, Receiver Noise and SNR, Integration of Radar Pulses, Radar Cross Section of Targets (simple targets - sphere, cone-sphere), Transmitter Power, PRF and Range Ambiguities, System Losses (qualitative treatment). Related Problems.
UNIT III: CW and Frequency Modulated Radar : Doppler Effect, CW Radar – Block Diagram, Isolation between Transmitter and Receiver, Non-zero IF Receiver, Receiver Bandwidth Requirements, Applications of CW radar.
UNIT IV: FM-CW Radar, Range and Doppler Measurement, Block Diagram and Characteristics (Approaching/ Receding Targets), FM-CW altimeter, Measurement Errors, Multiple Frequency CW Radar.
UNIT V: MTI and Pulse Doppler Radar : Introduction, Principle, MTI Radar with - Power Amplifier Transmitter and Power Oscillator Transmitter, Delay Line Cancellers – Filter Characteristics, Blind Speeds, Double Cancellation, Staggered PRFs. Range Gated Doppler Filters. MTI Radar Parameters, Limitations to MTI Performance. Non-coherent MTI, MTI versus Pulse Doppler Radar.
UNIT VI: Tracking Radar : Tracking with Radar, Sequential Lobing, Conical Scan, Monopulse Tracking Radar – Amplitude Comparison Monopulse (one- and two- coordinates), Phase Comparison Monopulse. Target Reflection Characteristics and Angular Accuracy. Tracking in Range, Acquisition and Scanning Patterns. Comparison of Trackers.
UNIT VII: Detection of Radar Signals in Noise : Introduction, Matched Filter Receiver – Response Characteristics and Derivation, Correlation Function and Cross-correlation Receiver, Efficiency of Non-matched Filters, Matched Filter with Non-white Noise.
UNIT VIII: Radar Receivers – Noise Figure and Noise Temperature. Displays – types. Duplexers – Branch type and Balanced type, Circulators as Duplexers. Introduction to Phased Array Antennas – Basic Concepts, Radiation Pattern, Beam Steering and Beam Width changes, Series versus Parallel Feeds, Applications, Advantages and Limitations.
TEXT BOOKS : 1.Introduction to Radar Systems – Merrill I. Skolnik, SECOND EDITION, McGraw-Hill, 1981.
REFERENCES :1. Introduction to Radar Systems – Merrill I. Skolnik, THIRD EDITION, Tata McGraw-Hill, 2001.








MICRO CONTROLLERS AND APPLICATIONS (ELECTIVE–I)
Credits: T: 4+1*    P:0    C:4


UNIT I: OVERVIEW OF ARCHITECTURE AND MICROCONTROLLER RESOURCES : Architecture of a microcontroller – Microcontroller resources – Resources in advanced and next generation microcontrollers – 8051 microcontroller – Internal and External memories – Counters and Timers – Synchronous serial-cumasynchronous serial communication - Interrupts.
UNIT II: 8051 FAMILY MICROCONTROLLERS INSTRUCTION SET : Basic assembly language programming – Data transfer instructions – Data and Bit-manipulation instructions – Arithmetic instructions – Instructions for Logical operations on the test among the Registers, Internal RAM, and SFRs – Program flow control instructions – Interrupt control flow.
UNIT III: REAL TIME CONTROL : INTERRUPTS : Interrupt handling structure of an MCU – Interrupt Latency and Interrupt deadline – Multiple sources of the interrupts – Non-maskable interrupt sources – Enabling or disabling of the sources – Polling to determine the interrupt source and assignment of the priorities among them – Interrupt structure in Intel 8051.
UNIT IV: REAL TIME CONTROL: TIMERS : Programmable Timers in the MCU’s – Free running counter and real time control – Interrupt interval and density constraints.
UNIT V: SYSTEMS DESIGN : DIGITAL AND ANALOG INTERFACING METHODS : Switch, Keypad and Keyboard interfacings – LED and Array of LEDs – Keyboard-cum-Display controller (8279) – Alphanumeric Devices – Display Systems and its interfaces – Printer interfaces – Programmable instruments interface using IEEE 488 Bus – Interfacing with the Flash Memory – Interfaces – Interfacing to High Power Devices – Analog input interfacing – Analog output interfacing – Optical motor shaft encoders – Industrial control – Industrial process control system – Prototype MCU based Measuring instruments – Robotics and Embedded control – Digital Signal Processing and Digital Filters.
UNIT VI: REAL TIME OPERATING SYSTEM FOR MICROCONTROLLERS : Real Time operating system – RTOS of Keil (RTX51) – Use of RTOS in Design – Software development tools for Microcontrollers.
UNIT VII: 16-BIT MICROCONTROLLERS : Hardware – Memory map in Intel 80196 family MCU system – IO ports – Progammable Timers and High-speed outputs and input captures – Interrupts – instructions.
UNIT VIII: ARM 32 Bit MCUs : Introduction to 16/32 Bit processors – ARM architecture and organization – ARM / Thumb programming model – ARM / Thumb instruction set – Development tools.
TEXT BOOKS :
  1. Microcontrollers Architecture, Programming, Interfacing and System Design – Raj Kamal, Pearson Education, 2005.
  2. The 8051 Microcontroller and Embedded Systems – Mazidi and Mazidi, PHI, 2000.
REFERENCES :
  1. Microcontrollers (Theory & Applications) – A.V. Deshmuk, WTMH, 2005.
  2. Design with PIC Microcontrollers – John B. Peatman, Pearson Education, 2005.





OPERATING SYSTEMS (ELECTIVE – I)
Credits: T: 4+1*    P:0    C:4


UNIT I: Computer System and Operating System Overview; Overview of Computer System hardware – Instruction execution – I/O function – Interrupts – Memory hierarchy – I.O Communication techniques. Operating System Objectives and functions – Evaluation of operating System – Example Systems.
UNIT II: Process Description – Process Control-process states – Process and Threads - Examples of Process description and Control.
UNIT III: Concurrency : Principles of Concurrency – Mutual Exclusion – Software and hardware approaches – semaphores – Monitors – Message Passing – Readers Writers Problem.
UNIT IV: Principles of deadlock – deadlock prevention, detection and avoidance dining philosophers problem – example Systems.
UNIT V: Memory Management: Memory Management requirements – loading programmes in to main memory – virtual memory – hardware and Control structures – OS Software – Examples of Memory Management.
UNIT VI: Uniprocessor Scheduling: Types of Scheduling – Scheduling algorithms – I/O management and Disc Scheduling – I/o devices – organization – of I/O function – OS design issues – I/O buffering – Disk I/O – disk scheduling Policies – examples System.
UNIT VII: File Management and Security: Overview of file management – file organization and access – File Directories – File sharing – record blocking – secondary Storage Management – example system.
UNIT VIII: Security : Security threats – Protection – intruders – Viruses – trusted System.
TEXT BOOKS :
  1. Operating Systems’ – Internal and Design Principles, Fifth Edition–2005, Pearson education./PHI
  2. Operating System Principles- Abraham Silberchatz, Peter B. Galvin, Greg Gagne,7th Edition John Wiley
REFERENCES :
1. Operating Systems A design approach- Crowley,TMH. 2. Modern Operating Systems, Andrew S Tanenbaum. 2nd Edition, PHI/PEARSON.



TELEVISION ENGINEERING (ELECTIVE – I)
Credits: T: 4+1*    P:0    C:4


UNIT I: INTRODUCTION : TV transmitter and receivers, synchronization. Television Pictures: Geometric form and aspect ratio, image continuity, interlaced scanning, picture resolution, Composite video signal: Horizontal and vertical sync, scanning sequence. Colour signal generation and Encoding: Perception of brightness and colours, additive colour mixing, video signals for colours, luminance signal, colour difference signals, encoding of colour difference signals, formation of chrominance signals, PAL encoder.
UNIT II: TV SIGNAL TRANSMISSION AND PROPAGATION : Picture signal transmission, positive and negative modulation, VSB transmission, sound signal transmission, standard channel BW, TV transmitter, TV signal propagation, interference, TV broadcast channels, TV transmission Antennas.
UNIT III: TV CAMERAS : Camera tube types, Vidicon, Silicon Diode Array Vidicon, Monochrome TV camera, color camera. CCD Image Sensors.
UNIT IV: PICTURE TUBES : Monochromatic Picture tube, Electrostatic focussing, Beam deflection, picture tube characteristics and specifications, colour picture tubes. TV Standards: American 525 line B&W TV system, NTSC colour system, 625-line monochrome system,b PAL colour system, TV standards.
UNIT V: MONOCHROME TV RECEIVER : RF tuner, IF subsystem, video amplifier, sound section, sync separation and processing, deflection circuits, scanning circuits. PAL-D Colour Receiver: Electron tuners, IF subsystem, Y-signal channel, Chroma decoder, Separation of U & V Colour Phasors, synchronous demodulators, Subcarrier generation, raster circuits.
UNIT VI: VISION IF SUBSYSTEM : AGC, noise cancellation, video and intercarrier sound signal detection, vision IF subsystem of Black and White receivers, Colour receiver IF subsystem. Receiver sound system: FM detection, FM Sound detectors, typical applications. TV Receiver Tuners: Tuner operation, VHF and UHF tuners, digital tuning techniques, remote control of receiver functions.
UNIT VII: COLOUR SIGNAL DECODING : PAL – D decoder, chroma signal amplifiers, separation of U and V signals, Color burst separation, Burst phase discriminator, ACC amplifier, Reference oscillator, Indent and colour killer circuits, RO phase shift and 180o PAL–SWITCH circuitry, U & V demodulators, Colour signal mixing.
UNIT VIII: SYNC SEPARATION, AFC AND DEFLECTION OSCILLATORS : Synchronous separation, k noise in sync pulses, separation of frame and line sync pulses. AFC, single ended AFC circuit. Deflection Oscillators, deflection drive Ics. Receiver Antennas. DIGITAL TV Digital Satellite TV, Direct to Home Satellite TV, Digital TV Receiver, Digital Terrestrial TV.
TEST BOOKS :
  1. Modern Television Practice – Principles, Technology and Service – R.R. Gulati, New Age International Publication, 2002.
  2. Monochrome and Colour TV – R.R. Gulati, New Age International Publication, 2002.
REFERENCES :
  1. Colour Television Theory and Practice – S.P. Bali, TMH, 1994.
  2. Television and Video Engineering - A.M. Dhake, 2nd Edition.
  3. Basic Television and Video Systems – B. Grob and C.E. Herndon, McGraw Hill, 1999.




DIGITAL IMAGE PROCESSING (ELECTIVE – II)
Credits: T: 4+1*    P:0    C:4


UNIT I: Digital image fundamentals - Digital Image through scanner, digital camera. Concept of gray levels. Gray level to binary image conversion. Sampling and quantization. Relation ship between pixels. Imaging Geometry.
UNIT II: Image Transforms 2-D FFT , Properties. Walsh transform, Hadamard Transform, Discrete cosine Transform, Haar transform, Slant transform, Hotelling transform.
UNIT III: Image enhancement Point processing. Histogram processing. Spatial filtering.
UNIT IV: Enhancement in frequency domain, Image smoothing, Image sharpening.
UNIT V: Colour image processing : Psedo colour image processing, full colour image processing.
UNIT VI: Image Restoration Degradation model, Algebraic approach to restoration, Inverse filtering, Least mean square filters, Constrained Least Squares Restoration, Interactive Restoration.
UNIT VII: Image segmentation Detection of discontinuities. Edge linking and boundary detection, Thresholding, Region oriented segmentation.
UNIT VIII: Image compression Redundancies and their removal methods, Fidelity criteria, Image compression models, Source encoder and decoder, Error free compression, Lossy compression.
TEXT BOOK :
1. Digital Image processing – R.C. Gonzalez & R.E. Woods, Addison Wesley/ Pearson education,
2nd Education, 2002.
REFERENCES :
  1. Fundamentals of Digital Image processing – A.K.Jain , PHI.
  2. Digital Image processing using MAT LAB – Rafael C. Gonzalez, Richard E Woods and Steven L. Edition, PEA, 2004.
  3. Digital Image Processing – William K. Pratt, John Wilely, 3rd Edition, 2004.
  4. Fundamentals of Electronic Image Processing –Weeks Jr., SPIC/IEEE Series, PHI.


SATELLITE COMMUNICATIONS (ELECTIVE – II)
Credits: T: 4+1*    P:0    C:4


UNIT I: INTRODUCTION [2] : Origin of Satellite Communications, Historical Back-ground, Basic Concepts of Satellite Communications, Frequency allocations for Satellite Services, Applications, Future Trends of Satellite Communications.
UNIT II: ORBITAL MECHANICS AND LAUNCHERS[1] : Orbital Mechanics, Look Angle determination, Orbital perturbations, Orbit determination, launches and launch vehicles, Orbital effects in communication systems performance.
UNIT III: SATELLITE SUBSYSTEMS[1] : Attitude and orbit control system, telemetry, tracking, Command and monitoring, power systems, communication subsystems, Satellite antenna Equipment reliability and Space qualification.
UNIT IV: SATELLITE LINK DESIGN[1] : Basic transmission theory, system noise temperature and G/T ratio, Design of down links, up link design, Design of satellite links for specified C/N, System design example.
UNIT V: MULTIPLE ACCESS[1][2] : Frequency division multiple access (FDMA) Intermodulation, Calculation of C/N. Time division Multiple Access (TDMA) Frame structure, Examples. Satellite Switched TDMA Onboard processing, DAMA, Code Division Multiple access (CDMA),Spread spectrum transmission and reception.
UNIT VI: EARTH STATION TECHNOLOGY[3] : Introduction, Transmitters, Receivers, Antennas, Tracking systems, Terrestrial interface, Primary power test methods.
UNIT VII: LOW EARTH ORBIT AND GEO-STATIONARY SATELLITE SYSTEMS[1] : Orbit consideration, coverage and frequency considerations, Delay & Throughput considerations, System considerations, Operational NGSO constellation Designs
UNIT VIII: SATELLITE NAVIGATION & THE GLOBAL POSITIONING SYSTEM [1] : Radio and Satellite Navigation, GPS Position Location principles, GPS Receivers and codes, Satellite signal acquisition, GPS Navigation Message, GPS signal levels, GPS receiver operation, GPS C/A code accuracy, Differential GPS.
TEXT BOOKS :
  1. Satellite Communications – Timothy Pratt, Charles Bostian and Jeremy Allnutt, WSE, Wiley Publications, 2nd Edition, 2003.
  2. Satellite Communications Engineering – Wilbur L. Pritchard, Robert A Nelson and Henri G.Suyderhoud, 2nd Edition, Pearson Publications, 2003.
REFERENCES :
  1. Satellite Communications : Design Principles – M. Richharia, BS Publications, 2nd Edition, 2003.
  2. Satellite Communication - D.C Agarwal, Khanna Publications, 5th Ed.
  3. Fundamentals of Satellite Communications – K.N. Raja Rao, PHI, 2004
  4. Satellite Communications – Dennis Roddy, McGraw Hill, 2nd Edition, 1996.




DATABASE MANAGEMENT SYSTEMS (ELECTIVE-II)
Credits: T: 4+1*    P:0    C:4


UNIT – I: Data base System Applications, data base System VS file System – View of Data – Data Abstraction – Instances and Schemas – data Models – the ER Model – Relational Model – Other Models – Database Languages – DDL – DML – database Access for applications Programs – data base Users and Administrator – Transaction Management – data base System Structure – Storage Manager – the Query Processor – History of Data base Systems.Data base design and ER diagrams – Beyond ER Design Entities, Attributes and Entity sets – Relationships and Relationship sets – Additional features of ER Model – Concept Design with the ER Model – Conceptual Design for Large enterprises.
UNIT – II: Relational Model: Introduction to the Relational Model – Integrity Constraint Over relations – Enforcing Integrity constraints – Querying relational data – Logical data base Design – Introduction to Views – Destroying /altering Tables and Views. Relational Algebra and Calculus: Relational Algebra – Selection and projection set operations – renaming – Joins – Division – Examples of Algebra overviews – Relational calculus – Tuple relational Calculus – Domain relational calculus – Expressive Power of Algebra and calculus.
UNIT – III: Form of Basic SQL Query – Examples of Basic SQL Queries – Introduction to Nested Queries – Correlated Nested Queries Set – Comparison Operators – Aggregative Operators – NULL values – Comparison using Null values – Logical connectivity’s – AND, OR & NOTR –Impact on SQL Constructs – Outer Joins – Disallowing NULL values – Complex Integrity Constraints in SQL 0 Triggers and Active Data bases.
UNIT – IV: Schema refinement – Problems Caused by redundancy – Decompositions – Problem related to decomposition – reasoning about FDS – FIRST, SECOND, THIRD Normal forms – BCNF – Lossless join Decomposition – Dependency preserving Decomposition – Schema refinement in Data base Design – Multi valued Dependencies – forth Normal Form.
UNIT – V: Overview of Transaction Management: ACID Properties – Transactions and Schedules – Concurrent Execution of transaction – Lock Based Concurrency Control – Performance Locking – Transaction Support in SQL – Introduction to Crash recovery.
UNIT – VI: Concurrency Control: Serializability, and recoverability – Introduction to Lock Management – Lock Conversions – Dealing with Dead Locks – Specialized Locking Techniques – Concurrency without Locking. Crash recovery: Introduction to ARIES – the Log – Other Recovery related Structures – the Write-Ahead Log Protocol – Check pointing – re3covering from a System Crash – Media recovery – Other approaches and Interaction with Concurrency control.
UNIT – VII: Overview of Storage and Indexing: Data on External Storage – File Organization and Indexing – Cluster Indexes, Primary and Secondary Indexes – Index data Structures – Hash Based Indexing – Tree base Indexing – Comparison of File Organizations – Indexes and Performance Tuning.
UNIT – VIII: Storing data: Disks and Files : - The Memory Hierarchy – Redundant Arrays of Independent – Disks – Disk Space Management – Buffer Manager – Files of records – Page Formats – record formats. Tree Structured Indexing: Intuitions for tree Indexes – Indexed Sequential Access Methods (ISAM) – B+ Trees: A Dynamic Index Structure. Hash Based Indexing: Static Hashing – Extendable hashing – Linear Hashing – Exendble vs. Liner hashing.
TEXT BOOKS :
  1. Data base Management Systems, Raghurama Krishnan, Johannes Gehrke, TATA McGrawHill 3rd Edition.
  2. Data base System Concepts, Silberschatz, Korth, Mc.Graw hill, IV edition.
REFERENCES :
  1. Introduction to Database Systems, C.J.Date Pearson Education
  2. Data base Systems design, Implementation, and Management, Rob & Coronel 5th Edition.Thomson.
  3. Data base Management System, Elmasri Navrate Pearson Education.
  4. Data base Management System Mathew Leon, Leon Vikas.
  5. Data base Systems, Connoley Pearson education.




MICROWAVE AND OPTICAL COMMUNICATIONS LAB
Credits: T: 0    P:3    C:2


Minimum Twelve Experiments to be conducted:

Part – A ( Any 7 Experiments) :
Reflex Klystron Characteristics,
Gunn Diode Characteristics,
Attenuation Measurement,
Directional Coupler Characteristics,
VSWR Measurement,
Impedance and Frequency Measurement,
Waveguide parameters measurement,
Scattering parameters of Circulator,
Scattering parameters of Magic Tee.

Part – B ( Any 5 Experiments ):
Characterization of LED,
Characterization of Laser Diode,
Intensity modulation of Laser output through an optical fiber,
Measurement of Data rate for Digital Optical link,
Measurement of NA,
Measurement of losses for Analog Optical link.

Equipment required for Laboratories: Regulated Klystron Power Supply, VSWR Meter, Micro Ammeter 0-500 µA, Multimeter, CRO, GUNN Power Supply, Pin Moderator, Reflex Klystron, Crystal Diodes, Micro wave components (Attenuation), Frequency Meter, Slosted line carriage, Probe detector, wave guide shorts, Pyramidal Horn Antennas, Directional Coupler, E, H, Magic Tees, Circulators, Isolator, Matched Loads, Fiber Optic Analog Trainer based LED, Fiber Optic Analog Trainer based laser,Fiber Optic Digital Trainer,Fiber cables (Plastic, Glass).


DIGITAL SIGNAL PROCESSING LAB
Credits: T: 0    P:3    C:2


LIST OF EXPERIMENTS :
  1. To study the architecture of DSP chips – TMS 320C 5X/6X Instructions.
  2. To verify linear convolution.
  1. To verify the circular convolution.
  2. To design FIR filter (LP/HP) using windowing technique
    a) Using rectangular window
    b) Using triangular window
    c) Using Kaiser window
  1. To Implement IIR filter (LP/HP) on DSP Processors
  2. N-point FFT algorithm.
  1. MATLAB program to generate sum of sinusoidal signals.
  2. MATLAB program to find frequency response of analog LP/HP filters.
  1. To compute power density spectrum of a sequence.
  2. To find the FFT of given 1-D signal and plot.


to download JNTUH ECE 4-1 syllabus in PDF format
[TIP: If any ad appears after clicking, wait for 5 sec and click on "SKIP AD" that appears at the top-right of the page to download (Disable Ad Blocker like softwares if any)]
Disclaimer: The contents of this document are provided as is without any warranty. You are free to read/ print/ re-distribute this document at your own risk. The author(Deekshith Allamaneni) or adeekshith.tk shall not be held responsible for any kind of damage that occurred by using this document.

Please spend a few moments to share it with your friends on Facebook/ Orkut/ email, etc.



No comments:

Post a Comment