- Written by KamatchiPriya
- Hits: 1585
2012 CSE IV SEM- B.E CURRICULUM AND SYLLABUS
Curriculum and Syllabus: B.E. 2012 CSE, AUC 2012
Semester: 4
CS2255, Database Management Systems
Subject Introduction / Notes not available
Unit I - INTRODUCTION
Purpose of Database System - Views of data - Data Models - Database Languages - Database System Architecture - Database users and Administrator - Entity-Relationship model (E-R model ) - E-R Diagrams - Introduction to relational databases
Unit II - RELATIONAL MODEL
The relational Model - The catalog - Types - Keys - Relational Algebra - Domain - Relational Calculus - Tuple Relational Calculus - Fundamental operations - Additional Operations - SQL fundamentals - Integrity - Triggers - Security - Advanced SQL features - Embedded SQL - Dynamic SQL - Missing Information - Views - Introduction to Distributed Databases and Client/Server Databases
Unit III - DATABASE DESIGN
Functional Dependencies - Non-loss Decomposition - Functional Dependencies - First,Second, Third Normal Forms, Dependency Preservation - Boyce/Codd Normal Form - Multi-valued Dependencies and Fourth Normal Form - Join Dependencies and Fifth Normal Form
Unit IV - TRANSACTIONS
Transaction Concepts - Transaction Recovery - ACID Properties - System Recovery - Media Recovery - Two Phase Commit - Save Points - SQL Facilities for recovery - Concurrency - Need for Concurrency - Locking Protocols - Two Phase Locking - Intent Locking - Deadlock - Serializability - Recovery Isolation Levels - SQL Facilities for Concurrency
Unit V - IMPLEMENTATION TECHNIQUES
Overview of Physical Storage Media - Magnetic Disks - RAID - Tertiary storage - File Organization - Organization of Records in Files - Indexing and Hashing - Ordered Indices - B+ tree Index Files - B tree Index Files - Static Hashing - Dynamic Hashing - Query Processing Overview - Catalog Information for Cost Estimation - Selection Operation - Sorting - Join Operation - Database Tuning
TEXT BOOKS:
1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, "Database System Concepts", Fifth Edition, Tata McGraw Hill, 2006
(Unit I and Unit-V) .
2. C.J.Date, A.Kannan, S.Swamynathan, "An Introduction to Database Systems", Eighth Edition, Pearson Education, 2006.
( Unit II, III and IV).
REFERENCES:
1. Ramez Elmasri, Shamkant B. Navathe, -Fundamentals of Database Systems-, FourthEdition , Pearson / Addision wesley, 2007.
2. Raghu Ramakrishnan, -Database Management Systems-, Third Edition, McGraw Hill, 2003.
3. S.K.Singh, -Database Systems Concepts, Design and Applications-, First Edition, Pearson Education, 2006.
MA2262, Probability and Queueing Theory
The probabilistic models are employed in countless applications in all areas of science and engineering. Queuing theory provides models for a number of situations that arise in real life. The course aims at providing necessary mathematical support and confidence to tackle real life problems.
Unit I - RANDOM VARIABLES
Discrete and continuous random variables - Moments - Moment generating functions and their properties. - Binomial, Poisson ,Geometric ,Negative binomial, Uniform,Exponential, Gamma, and Weibull distributions
Unit II - TWO DIMENSIONAL RANDOM VARIABLES
Joint distributions - Marginal and conditional distributions - Covariance - Correlation and regression - Transformation of random variables - Central limit theorem.
Unit III - MARKOV PROCESSES AND MARKOV CHAINS
Classification - Stationary process - Markov process - Markov chains - Transition probabilities - Limiting distributions - Poisson process
Unit IV - QUEUEING THEORY
Markovian models - Birth and Death Queuing models - Steady state results: Single and multiple server queuing models queues with finite waiting rooms - Finite source models - Little?s Formula
Unit V - NON-MARKOVIAN QUEUES AND QUEUE NETWORKS
M/G/1 queue - Pollaczek - Khintchine formula, series queues - open and closed networks
TEXT BOOKS:
1. O.C. Ibe, -Fundamentals of Applied Probability and Random Processes-,sevier, 1st Indian Reprint, 2007 (For units 1, 2 and 3).
2. D. Gross and C.M. Harris, -Fundamentals of Queueing Theory-, Wiley Student edition, 2004 (For units 4 and 5).
REFERENCES:
1. A.O. Allen, -Probability, Statistics and Queueing Theory with Computer Applications-, Elsevier, 2nd edition, 2005.
2. H.A. Taha, -Operations Research-, Pearson Education, Asia, 8th edition, 2007.
3. K.S. Trivedi, -Probability and Statistics with Reliability, Queueing and
Computer Science Applications-, John Wiley and Sons, 2nd edition, 2002.
CS2251, Design and Analysis of Algorithms
Subject Introduction / Notes not available
Unit I - Algorithm Analysis
Time Space Tradeoff - Asymptotic Notations - Conditional asymptotic notation - Removing condition from the conditional asymptotic notation - Properties of big-Oh notation - Recurrence equations - Solving recurrence equations - Analysis of linear search.
Unit II - Divide and Conquer: General Method
Binary Search - Finding Maximum and Minimum - Merge Sort - Greedy Algorithms: General Method - Container Loading - Knapsack Problem.
Unit III - Dynamic Programming: General Method
Multistage Graphs - All-Pair shortest paths - Optimal binary search trees - 0/1 Knapsack - Travelling salesperson problem .
Unit IV - Backtracking: General Method
8 Queens problem - sum of subsets - graph coloring - Hamiltonian problem - knapsack problem.
Unit V - Graph Traversals
Connected Components - Spanning Trees - Biconnected components - Branch and Bound: General Methods (FIFO & LC) - 0/1 Knapsack problem - Introduction to NP-Hard and NP-Completeness.
TEXT BOOKS:
1. Ellis Horowitz, Sartaj Sahni and Sanguthevar Rajasekaran, Computer Algorithms/C++, Second Edition, Universities Press, 2007. (For Units II to V)
2. K.S. Easwarakumar, Object Oriented Data Structures using C++, Vikas Publishing House pvt. Ltd., 2000 (For Unit I)
REFERENCES:
1. T. H. Cormen, C. E. Leiserson, R.L.Rivest, and C. Stein, "Introduction to Algorithms", Second Edition, Prentice Hall of India Pvt. Ltd, 2003.
2. Alfred V. Aho, John E. Hopcroft and Jeffrey D. Ullman, "The Design and Analysis of Computer Algorithms", Pearson Education, 1999.
CS2252, Microprocessors and Microcontrollers
Subject Introduction / Notes not available
Unit I - THE 8085 AND 8086 MICROPROCESSORS
8085 Microprocessor architecture - Addressing modes - Instruction set - Programming the 8085
Unit II - 8086 SOFTWARE ASPECTS
Intel 8086 microprocessor - Architecture - Signals - Instruction Set - Addressing Modes - Assembler Directives - Assembly Language Programming - Procedures - Macros - Interrupts And Interrupt Service Routines - BIOS function calls.
Unit III - MULTIPROCESSOR CONFIGURATIONS
Coprocessor Configuration - Closely Coupled Configuration - Loosely Coupled Configuration - 8087 Numeric Data Processor - Data Types - Architecture - 8089 I/O Processor - Architecture - Communication between CPU and IOP.
Unit IV - I/O INTERFACING
Memory interfacing and I/O interfacing with 8085 - parallel communication interface - serial communication interface - timer - keyboard/display controller - interrupt controller - DMA controller (8237) - applications - stepper motor - temperature control.
Unit V - MICROCONTROLLERS
Architecture of 8051 Microcontroller - signals - I/O ports - memory - counters and timers - serial data I/O interrupts - Interfacing - keyboard, LCD,ADC & DAC
TEXT BOOKS:
1. Ramesh S. Gaonkar ,-Microprocessor - Architecture, Programming and Applications with the 8085- Penram International Publisher , 5th Ed.,2006
2. Yn-cheng Liu,Glenn A.Gibson, -Microcomputer systems: The 8086 / 8088 Family architecture, Programming and Design-, second edition, Prentice Hall of India , 2006.
3. Kenneth J.Ayala, -The 8051 microcontroller Architecture, Programming and applications- second edition ,Penram international.
REFERENCES:
1. Douglas V.Hall, - Microprocessors and Interfacing : Programming and Hardware-,second edition , Tata Mc Graw Hill ,2006.
2. A.K.Ray & K.M Bhurchandi, -Advanced Microprocessor and Peripherals - Architecture, Programming and Interfacing-, Tata Mc Graw Hill , 2006.
3. Peter Abel, - IBM PC Assembly language and programming- , fifth edition, Pearson education / Prentice Hall of India Pvt.Ltd,2007.
4. Mohamed Ali Mazidi,Janice Gillispie Mazidi,- The 8051 microcontroller and embedded systems using Assembly and C-,second edition, Pearson education /Prentice hall of India , 2007.
CS2253, Computer Organization and Architecture
Subject Introduction / Notes not available
Unit I - BASIC STRUCTURE OF COMPUTERS
Functional units - Basic operational concepts - Bus structures - Performance and metrics - Instructions and instruction sequencing - Hardware - Software Interface - Instruction set architecture - Addressing modes - RISC - CISC. - ALU design - Fixed point and floating point operations.
Unit II - BASIC PROCESSING UNIT
Fundamental concepts - Execution of a complete instruction - Multiple bus organization - Hardwired control - Micro programmed control - Nano programming.
Unit III - PIPELINING
Basic concepts - Data hazards - Instruction hazards - Influence on instruction sets - Data path and control considerations - Performance considerations - Exception handling.
Unit IV - MEMORY SYSTEM
Basic concepts - Semiconductor RAM - ROM - Speed - Size and cost - Cache memories - Improving cache performance - Virtual memory Memory management - requirements - Associative memories - Secondary storage devices.
Unit V - I/O ORGANIZATION
Accessing I/O devices - Programmed Input/Output - Interrupts - Direct Memory Access - Buses - Interface circuits - Standard I/O Interfaces (PCI, SCSI, USB), I/O devices and processors.
TEXT BOOK:
1. Carl Hamacher, Zvonko Vranesic and Safwat Zaky, -Computer Organization-, Fifth Edition, Tata McGraw Hill, 2002.
REFERENCES:
1. David A. Patterson and John L. Hennessy, -Computer Organization and Design: The Hardware/Software interface-, Third Edition, Elsevier, 2005.
2. William Stallings, -Computer Organization and Architecture - Designing for Performance-, Sixth Edition, Pearson Education, 2003.
3. John P. Hayes, -Computer Architecture and Organization-, Third Edition, Tata McGraw Hill, 1998.
4. V.P. Heuring, H.F. Jordan, -Computer Systems Design and Architecture-, Second Edition, Pearson Education, 2004.
CS2254, Operating Systems
Subject Introduction / Notes not available
Unit I - PROCESSES AND THREADS
Introduction to operating systems - review of computer organization - operating system structures - system calls,system programs,system structure - virtual machines - Processes: Process concept,Process scheduling,Operations on processes - Cooperating processes,Interprocess communication - Communication in client-server systems - Case study:IPC in Linux. Threads: Multi-threading models,Threading issues - Case Study:Pthreads library
Unit II - PROCESS SCHEDULING AND SYNCHRONIZATION
CPU Scheduling:Scheduling criteria,Scheduling algorithms - Multiple-processor scheduling - Real time scheduling,Algorithm Evaluation - Case study:Process scheduling in Linux. - Process Synchronization:The critical-section problem - Synchronization hardware,Semaphores,Classic problems of synchronization - critical regions,Monitors - Deadlock: System model,Deadlock characterization,Methods for handling deadlocks - Deadlock prevention,Deadlock avoidance, - Deadlock detection,Recovery from deadlock.
Unit III - STORAGE MANAGEMENT
Memory Management:Background,Swapping - Contiguous memory allocation,Paging - Segmentation, - Segmentation with paging - Virtual Memory,Background - Demand paging,Process creation - Page replacement, - Allocation of frames,Thrashing - Case Study: Memory management in Linux
Unit IV - FILE SYSTEMS
File-System Interface - File concept,Access methods - Directory structure,File-system mounting - Protection,File-System Implementation - Directory implementation,Allocation methods - Free-space management,efficiency and performance - recovery,log-structured file systems - Case studies:File system in Linux - file system in Windows XP
Unit V - I/O SYSTEMS
I/O Systems,I/O Hardware - Application I/O interface - kernel I/O subsystem,streams,performance - Mass-Storage Structure,Disk scheduling - Disk management,Swap-space management - RAID,disk attachment - stable storage,tertiary storage - Case study: I/O in Linux
TEXT BOOKS:
1.Silberschatz, Galvin, and Gagne, ?Operating System Concepts?, Sixth Edition, Wiley India Pvt Ltd, 2003.
REFERENCES:
2. Andrew S. Tanenbaum, ?Modern Operating Systems?, Second Edition, Pearson Education, 2004.
3. Gary Nutt, ?Operating Systems?, Third Edition, Pearson Education,2004.
4. Harvey M. Deital, ?Operating Systems?, Third Edition, Pearson Education,2004.
CS2257, Operating Systems Lab
Subject Introduction / Notes not available
Unit I - Exercises
1. Write programs using the following system calls of UNIX operating system - fork, exec, getpid, exit, wait, close, stat, opendir, readdir - 2. Write programs using the I/O system calls of UNIX operating system (open, read, - write, etc) - 3. Write C programs to simulate UNIX commands like ls, grep, etc. - 4. Given the list of processes, their CPU burst times and arrival times, display/print - the Gantt chart for FCFS and SJF. For each of the scheduling policies, compute - and print the average waiting time and average turnaround time. (2 sessions) - 5. Given the list of processes, their CPU burst times and arrival times, display/print - the Gantt chart for Priority and Round robin. For each of the scheduling policies, - compute and print the average waiting time and average turnaround time. (2 - sessions) - 6. Developing Application using Inter Process communication (using shared - memory, pipes or message queues) - 7. Implement the Producer-Consumer problem using semaphores (using UNIX - system calls). - 8. Implement some memory management schemes ? I - 9. Implement some memory management schemes ? II - 10. Implement any file allocation technique (Linked, Indexed or Contiguous)
Books information not available
CS2258, Data Base Management Systems Lab
Subject Introduction / Notes not available
Unit I - Exercises
1. Data Definition, Table Creation, Constraints, - 2. Insert, Select Commands, Update & Delete Commands. - 3. Nested Queries & Join Queries - 4. Views - 5. High level programming language extensions (Control structures, Procedures and Functions). - 6. Front end tools - 7. Forms - 8. Triggers - 9. Menu Design - 10. Reports. - 11. Database Design and implementation (Mini Project).
Books information not available
CS2259, Microprocessors Lab
To learn the assembly language programming of 8085,8086 and 8051 and also to give a practical training of interfacing the peripheral devices with the processor.
Unit I - Exercises
1. Programming with 8085 - 2. Programming with 8086-experiments including BIOS/DOS calls:Keyboard control, Display, File Manipulation. - 3. Interfacing with 8085/8086-8255,8253 - 4. Interfacing with 8085/8086-8279,8251 - 5. 8051 Microcontroller based experiments for Control Applications - 6. Mini- Project
List of equipments/components for 30 students (two per batch)
1. 8085 Trainer Kit with onboard 8255, 8253, 8279 and 8251 - 15 nos.
2. TASM/MASM simulator in PC (8086 programs) - 30 nos.
3. 8051 trainer kit - 15 nos.
4. Interfacing with 8086 - PC add-on cards with 8255, 8253, 8279 and 8251 - 15
nos.
5. Stepper motor interfacing module - 5 nos.
6. Traffic light controller interfacing module - 5 nos.
7. ADC, DAC interfacing module - 5 nos.
8. CRO-s - 5 nos.
More by KamatchiPriya
