III BSC V SEM SYLLABUS

                                         V SEMESTER

Title of the Course/	Paper –IX   -   OPERATING SYSTEMS
Core	III Year & Fifth Semester	Credit: 4
Objective of the course	This course introduces the functions of operating systems.
Course outline	Unit 1: Introduction: Views –Goals –Types of system – OS Structure –Components – Services - System Structures – Layered Approach -Virtual Machines - System Design and Implementation. Process Management: Process - Process Scheduling – Cooperating Process –Threads -  Interprocess Communication. CPU Scheduling : CPU Schedulers  – Scheduling criteria – Scheduling Algorithms
	Unit-2:– Process Synchronization: Critical-Section problem - Synchronization Hardware – Semaphores – Classic Problems of Synchronization – Critical Region – Monitors. Deadlock : Characterization – Methods for handling Deadlocks – Prevention, Avoidance, and Detection of Deadlock - Recovery from deadlock.
	Unit 3: Memory Management : Address Binding – Dynamic  Loading and Linking – Overlays – Logical and Physical Address Space -  Contiguous Allocation – Internal & External Fragmentation . Non Contiguous Allocation:Paging and  Segmentation schemes –Implementation – Hardware  Protection – Sharing - Fragmentation.
	Unit-4:  Virtual  Memory :: Demand Paging – Page Replacement - Page Replacement Algorithms – Thrashing. – File System: Concepts – Access methods – Directory Structure –Protection Consistency Semantics – File System Structures – Allocation methods – Free Space Management.
	Unit-5 : I/O Systems: Overview - I/O Hardware – Application I/O Interface – Kernel I/O subsystem – Transforming I/O Requests to Hardware Operations – Performance. Secondary Storage Structures : Protection – Goals- Domain  Access matrix – The security problem – Authentication – Threats – Threat Monitoring – Encryption..

1. Recommended Texts

i. Silberschatz A., Galvin P.B., Gange,. 2002 , Operating System Principles ,Sixth

   Edition, John Wiley & Sons.

2. Reference Books

i. H.M. Deitel ,1990, An Introduction to Operating System,- Second Edition,Addison Wesley.

Title of the Course/	Paper - X - DATABASE MANAGEMENT SYSTEMS
Core	III Year & Fifth Semester	Credit: 4
Objective of the course	This course introduces the basic concepts of database management systems
Course outline	Unit 1: Advantages and Components of a Database Management Systems – Feasibility Study – Class Diagrams – Data Types – Events – Normal Forms – Integrity – Converting Class Diagrams to Normalized Tables – Data Dictionary.
	Unit-2:  Query Basics – Computation Using Queries – Subtotals and GROUP BY Command – Queries with Multiple Tables – Subqueries – Joins – DDL & DML – Testing Queries
	Unit 3: Effective Design of Forms and Reports – Form Layout – Creating Forms – Graphical Objects – Reports – Procedural Languages – Data on Forms – Programs to Retrieve and Save Data – Error Handling.
	Unit-4:  Power of Application Structure – User Interface Features – Transaction – Forms Events – Custom Reports – Distributing Application – Table Operations – Data Storage Methods – Storing Data Columns – Data Clustering and Partitioning.
	Unit-5 : Database Administration – Development Stages – Application Types – Backup and Recovery – Security and Privacy – Distributed Databases – Client/Server Databases – Web as a Client/Server System – Objects – Object Oriented Databases – Integrated Applications.

 Recommended Texts

1.    G. V. Post – Database Management Systems Designing and Building Business Application – McGraw Hill International edition – 1999.

 Reference Books

1.Raghu Ramakrishnan – Database Management Systems – WCB/McGraw Hill – 1998.

2.C.J. Date – An Introduction to Database Systems – 7^th Edition – Addison Wesley   - 2000.

 

Title of the Course/	Paper - XI -   Computer Architecture and Organization
Core	III Year & Fifth Semester	Credit: 4
Objective of the course	This course introduces the architecture of various computers and its organization.
Course outline	Unit 1: Computer Evolution: Pentium and Power PC Evolution. Computer System: Components – Function – Interconnection Structures – Bus Interconnection – Basics of PCI Bus. Memory: Characteristics – Hierarchy – Cache Memory – Principles – Cache Design – Locality of Reference.
	Unit-2: Main Memory: Static RAM – Dynamic RAM – Types of ROM – Memory Chip Organization – Types of DRAM. External Memory: Magnetic Disk – Basics of RAID – Optical Memory – Magnetic Tapes
	Unit 3: : Input/Output: External Devices – I/O Module – Programmed I/O – Interrupt Driven I/O – DMA – I/O Channels & Processors.  Computer Arithmetic: ALU – Integer Representation and Arithmetic – Floating Point Representation and Arithmetic.  Instruction Set: Characteristics – Operand Types – Operation Types – Addressing Modes – Instruction Formats – Pentium and Power PC Operands, Operations, Addressing Modes (Simple Examples).
	Unit-4: CPU: Organization of Processors and Registers – Instruction Cycle – Instruction Pipelining – Pentium Processor. RISC: Characteristics – Large Register File – Register Optimization – Architecture – RISC Vs CISC Characteristics – Pipelining.
	Unit-5: Control Unit: Micro-Operations – Control of Processors – Hardwired Implementation - Micro Programmed Control Concepts – Microinstruction Sequencing – General Microinstruction Execution.

1. Recommended Texts

i.W. Stallings ,2003,Computer Organization and Architecture, 6^th Edition- PHI,New Delhi.

2. Reference Books

i..C. Hamacher, Z. Vranesic, S.Zaky, 2002, Computer Organization,5^thEdition,Mcgraw Hill.

Title of the Course/  Paper	VISUAL PROGRAMMING
Elective	III Year & Fifth Semester	Credit: 4
Objective of the course	To inculcate knowledge on Visual Basic concepts and Programming.
Course outline	Unit 1: Customizing a Form - Writing Simple Programs - Toolbox - Creating Controls - Name Property - Command Button - Access Keys - Image Controls - Text Boxes - Labels - Message Boxes - Grid - Editing Tools - Variables - Data Types - String - Numbers.
	Unit-2:  Displaying Information - Determinate Loops - Indeterminate Loops - Conditionals - Built-in Functions - Functions and Procedures.
	Unit 3: Lists - Arrays - Sorting and Searching - Records - Control Arrays - Combo Boxes - Grid Control - Projects with Multiple forms - DoEvents and Sub Main - Error Trapping.
	Unit-4:  VB Objects - Dialog Boxes - Common Controls - Menus - MDI Forms - Testing, Debugging and Optimization - Working with Graphics.
	Unit-5 : Monitoring Mouse activity - File Handling - File System Controls - File System Objects - COM/OLE - automation - DLL Servers - OLE Drag and Drop.

1. Recommended Texts

Gary Cornell - Visual Basic 6 from the Ground up - Tata McGraw Hill - 1999.

Noel Jerke - Visual Basic 6 (The Complete Reference) - Tata McGraw Hill – 1999

ELECTIVE I

Title of the Course/ Paper	RDBMS with  ORACLE
Elective	III Year & Fifth Semester	Credit: 4
Objective of the course	To inculcate knowledge on RDBMS concepts and Programming with Oracle.
Course outline	Unit 1: Database Concepts: A Relational approach: Database – Relationships – DBMS – Relational Data Model – Integrity Rules – Theoretical Relational Languages. Database Design: Data Modeling and Normalization: Data Modeling – Dependency – Database Design – Normal forms – Dependency Diagrams - Denormalization – Another Example of Normalization.
	Unit-2:  Oracle9i: Overview: Personal Databases – Client/Server Databases – Oracle9i an introduction – SQL *Plus Environment – SQL – Logging into SQL *Plus - SQL *Plus Commands – Errors & Help – Alternate Text Editors - SQL *Plus Worksheet - iSQL *Plus. Oracle Tables: DDL: Naming Rules and conventions – Data Types – Constraints – Creating Oracle Table – Displaying Table Information – Altering an Existing Table – Dropping, Renaming, Truncating Table – Table Types – Spooling – Error codes.
	Unit 3: Working with Table: Data Management and Retrieval: DML – adding a new Row/Record – Customized Prompts – Updating and Deleting an Existing Rows/Records – retrieving Data from Table – Arithmetic Operations – restricting Data with WHERE clause – Sorting – Revisiting Substitution Variables – DEFINE command – CASE structure. Functions and Grouping: Built-in functions –Grouping Data. Multiple Tables: Joins and Set operations: Join – Set operations.
	Unit-4:  PL/SQL: A Programming Language: History – Fundamentals – Block Structure – Comments – Data Types – Other Data Types – Declaration – Assignment operation – Bind variables – Substitution Variables – Printing – Arithmetic Operators. Control Structures and Embedded SQL: Control Structures – Nested Blocks – SQ L in PL/SQL – Data Manipulation – Transaction Control statements. PL/SQL Cursors and Exceptions: Cursors – Implicit & Explicit Cursors and Attributes – Cursor FOR loops – SELECT…FOR UPDATE – WHERE CURRENT OF clause – Cursor with Parameters – Cursor Variables – Exceptions – Types of Exceptions.
	Unit-5 : PL/SQL Composite Data Types: Records – Tables – Varrays. Named Blocks: Procedures – Functions – Packages –Triggers –Data Dictionary Views.

1. Recommended Texts

1. DATABASE SYSTEMS USING ORACLE – Nilesh Shah, 2nd edition, PHI.

2. Reference Books

1. DATABASE MANAGEMNET SYSTEMS – Arun Majumdar & Pritimoy Bhattacharya, 2007, TMH.

2. DATABASE MANAGEMENT SYSTEMS – Gerald V. Post, 3rd edition, TMH.

ELECTIVE I

Title of the Course/ Paper	UNIX PROGRAMMING
Elective	III Year & Fifth Semester	Credit: 5
Objective of the course	This course introduces fundamentals & programming of Unix  basic concepts
Course outline	Unit 1: INTRODUCTION: File and common commands - Shell - More about files - Directories- Unix system - Basics of file Directories and filenames - Permissions - modes - Directory hierarchy - Devices - the grep family - Other filters - the stream editor sed - the awk pattern scanning and processing language - files and good filters.
	Unit-2: CONCEPTS OF SHELL:  Command line structure - Metacharacters - Creating new commands - Command arguments and parameters - program output as arguments - Shell variables - More on I/O redirection - loop in shell programs - Bundle - Setting shell attributes, Shift command line parameters - Exiting a command or the shell, evaluating arguments - Executing command without invoking a new process - Trapping exit codes -- Conditional expressions.
	Unit 3: SHELL PROGRAMMING: Customizing the cal command, Functions of command, While and Until loops - Traps - Catching interrupts - Replacing a file - Overwrite - Zap - Pick command - News command - Get and Put tracking file changes.
	Unit-4:  FEATURES IN UNIX: Standard input and output - Program arguments - file access - A screen at a time printer - On bugs and debugging - Examples - Zap - pick - Interactive file comparison program - Accessing the environment - Unix system calls - Low level I/O, File system Directories and modes, Processors, Signal and Interrupts
	Unit-5 : PROGRAM DEVELOPMENT AND DOCUMENT  PREPARATION: Program development - Four function calculator - Variables and error recovery - Arbitrary variable names, Built in functions, Compilation into a machine, Control flow and relational operators, Functions and procedures - Performance evaluation - Ms macro package - Troff level - Tbl and eqn preprocessors - Manual page - Other document preparation.

. Recommended Texts

1. Brian W. Kernighan, Rob Pike - The UNIX Programming Environment - Prentice Hall of India( 1984).

2. Reference Books

I. Steven Earhart - The UNIX System for MSDOS Users - Galgotia book source P. Ltd. (1990).
2. Stefen Prata - Advanced UNIX - A Programmer Guide.