PAPER - I
Title of the Course/ | Paper –XIV DATABASE MANAGEMENT SYSTEMS | ||
Core | III Year | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of database management systems | ||
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 – 1999– Database Management Systems Designing and Building Business Application – McGraw Hill International edition.
Reference Books
1.Raghu Ramakrishnan – 1998.– Database Management Systems – WCB/McGraw Hill
2.C.J. Date- 2000 – An Introduction to Database Systems – 7th Edition – Addison
Wesley.
PAPER-II
Title of the Course/ | Paper -XIV SOFTWARE ENGINEERING | ||
Core | III Year & Fifth Semester | Credit: 4 | |
Objective of the course | This course introduces the concepts of Life Cycle of Software | ||
Course outline | Unit-1: Introduction to Software Engineering Some definition – Some size factors – Quality and productivity factors – Managerial issue. Planning a Software Project: Defining the problem – Developing a solution strategy – planning the development process – planning an organization structure – other planning activities | ||
Unit-2: Software Cost Estimation: Software – Cost factors – Software cost estimation techniques – specification techniques – level estimation – estimating software maintenance costs. | |||
Unit-3: Software requirements definition: The software requirements specification – formal languages and processors for requirements specification. | |||
Unit-4: Software Design: Fundamental Design concepts – Modules and modularizing Criteria – Design Notations – Design Techniques – Detailed Design Consideration – Real time and distributed system design – Test plan – Mile stones walk through and inspection – Design guide lines | |||
Unit-5 : Verification and validation techniques: Quality assurance – Static analysis – symbolic exception – Unit testing and Debugging – System testing – Formal verification. Software maintenance: Enhancing maintainability during development – Managua aspects of software maintenance – Configuration management – source code metrics – other maintenance tools and techniques. | |||
1. Recommended Texts
i. Richard E.Fairly - Software Engineering Concepts - Tata McGraw-Hill book
Company.
2. Reference Books
i. R.S.Pressman, 1997, Software Engineering – 1997 - Fourth Ed., McGraw Hill.
ii. Rajib Mall ,2004,Fundamentals of Software Engineering,2nd Edition, PHI.
PAPER-III
ELECTIVE-I
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
Title of the Course/ Paper | RDBMS AND 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.
Title of the Course/ Paper | UNIX PROGRAMMING | |
Elective | III Year & Fifth Semester | Credit: 4 |
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. | ||
1. Recommended Texts
1. Brian W. Kernighan, Rob Pike - The UNIX Programming Environment - Prentice Hall
of India( 1984).
2. Reference Books
1. Steven Earhart - The UNIX System for MSDOS Users - Galgotia book source P. Ltd.
(1990).
2. Stefen Prata - Advanced UNIX - A Programmer Guide.
2. Stefen Prata - Advanced UNIX - A Programmer Guide.
I SEMESTER
Title of the Course/ Paper | Fundamentals Of Digital Computers | ||
Core | I Year & First Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of computers and fundamentals of Digital Principles | ||
Course outline | Unit 1: Fundamentals of computers – Characteristics of computers – Computer Language – Operating Systems – Generation of Computers. | ||
Unit-2: Number systems - Conversion from one number system to another - compliments - Binary codes - Binary logic - Logic gates - Truth tables. | |||
Unit 3: Boolean Algebra - Axioms - Truth table simplification of Boolean function - map method (upto 5 Variables) - Mc-Clausky tabulation method | |||
| Unit-4: Sequential logic – RS, JK, D and T Flip flops - Registers –Shift Registers - Counters – Ripple Counters – Synchronous Counter – Design of Counters | |||
Unit-5 : Adders – Subtractors – Decoders – Encoders – Multiplexer - Demultiplexer – Design of Circuits using decoders/Multiplexers – ROM – PLA – Designing circuits using ROM/PLA | |||
1.Recommended Texts
i. M.M. Mano, Digital Logic and Computer Design, Pearson Education .
ii. V.Rajaraman,2002, Fundamentals of Computers, Third Edition,
PHI, New Delhi.
2.Reference Books
i .T.C.Bartee,1991,Computer Architecture and logical Design, McGraw Hill.
II SEMESTER
Title of the Course/ Paper | Programming in C | ||
Core | I Year& Second Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in C | ||
Course outline | Unit 1: C fundamentals Character set - Identifier and keywords - data types - constants - Variables - Declarations - Expressions - Statements - Arithmetic, Unary, Relational and logical, Assignment and Conditional Operators - Library functions. | ||
Unit-2: Data input output functions - Simple C programs - Flow of control ‑ if, if‑else, while, do-while , for loop, Nested control structures - Switch, break and continue, go to statements - Comma operator. | |||
Unit 3: Functions –Definition - proto-types - Passing arguments - Recursions. Storage Classes - Automatic, External, Static, Register Variables – Multi-file programs. | |||
Unit-4: Arrays - Defining and Processing - Passing arrays to functions – Multi-dimension arrays - Arrays and String. Structures - User defined data types - Passing structures to functions - Self-referential structures – Unions - Bit wise operations. | |||
Unit-5 : Pinters - Declarations - Passing pointers to Functions - Operation in Pointers - Pointer and Arrays - Arrays of Pointers - Structures and Pointers - Files : Creating , Processing ,Opening and Closing a data file. | |||
1. Recommended Texts
i.E.Balaguruswamy, 1995,Programming in ANSI C, TMH Publishing Company Ltd.
2. Reference Books
i.B.W. Kernighan and D.M.Ritchie, 1988,The C Programming Language, 2nd Edition, PHI.
ii.H. Schildt, C,2004, The Complete Reference, 4th Edition, TMH
iii. Gottfried,B.S, 1996,Programming with C, Second Edition, TMH Pub. Co. Ltd., New Delhi .
iv. Kanetkar Y., 1999,Let us C, BPB Pub., New Delhi .
III SEMESTER
VI SEMESTER
Title of the Course/ | Paper –V PROGRAMMING IN C++ AND DATA STRUCTURES | ||
Core | II Year & Third Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in C++ and Data Structures | ||
Course outline | Unit 1: Introduction to C++; Tokens, Keywords, Identifiers, Variables, Operators, Manipulators, Expressions and Control Structures in C++; Pointers - Functions in C++ ‑ Main Function ‑ Function Prototyping ‑ Parameters Passing in Functions - Values Return by Functions - Inline Functions - Friend and Virtual Functions | ||
Unit-2: Classes and Objects; Constructors and Destructors; and Operator Overloading and Type Conversions - Type of Constructors - Function overloading. Inheritance : Single Inheritance ‑ Multilevel Inheritance ‑ Multiple Inheritance ‑ Hierarchical Inheritance ‑ Hybrid Inheritance. Pointers, Virtual Functions and Polymorphism; Managing Console I/O operations. | |||
Unit 3: Working with Files: Classes for File Stream Operations ‑ Opening and Closing a File ‑ End‑of‑File Deduction ‑ File Pointers ‑ Updating a File ‑ Error Handling during File Operations ‑ Command‑line Arguments. Data Structures: Definition of a Data structure ‑ primitive and composite Data Types, Asymptotic notations, Arrays, Operations on Arrays, Order lists. | |||
Unit-4: Stacks - Applications of Stack ‑ Infix to Postfix Conversion, Recursion, Maze Problems - Queues ‑ Operations on Queues, Queue Applications, Circular Queue. Singly Linked List ‑ Operations, Application ‑ Representation of a Polynomial, Polynomial Addition; Doubly Linked List ‑ Operations, Applications. | |||
Unit-5 : Trees and Graphs: Binary Trees ‑ Conversion of Forest to Binary Tree, Operations ‑ Tree Traversals; Graph ‑ Definition, Types of Graphs, Hashing Tables and Hashing Functions, Traversal ‑ Shortest Path; Dijkstra's Algorithm. | |||
1. Recommended Texts
i. E. Balagurusamy,1995,Object Oriented Programming with C++, Tata McGraw‑Hill
Publishing Company Ltd.
ii..E.Horowitz and S.Shani,1999,Fundamentals of Data Structures in C++ , Galgotia Pub.
2.Reference Books
i. Robert Lafore, Object Oriented Programming in Microsoft C++, Galgotia publication.
ii.. H.Schildt, C++,1998,The Complete Reference-1998-TMH Edition, 1998
iii.R. Kruse C.L. Tondo and B. Leung ,1997, Data Structures and Program design in C,
PHI.
iii.Cangsam,Auguenstein,Tenenbaum,Data Structures using C & C++,PHI
iv.D.Samantha,2005, Classic Data Structures, PHI,New Delhi.
Title of the Course/ | Microprocessors and Its Applications | ||
Core | II Year & Third Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of Microprocessors and Its Applications | ||
Course outline | Unit – I Introduction to Micro Computers, Microprocessors and Assembly Languages - Microprocessor architecture and its operations - 8085 MPU - 8085 Instruction set and classifications | ||
Unit – II Writing assembly levels programs - Programming techniques such as looping, counting and indexing addressing nodes - Data transfer instructions - Arithmetic and logic operations - Dynamic debugging. | |||
Unit – III Counters and Time delays - Hexadecimal counter - Modulol 0 counter - Pulse Timings for flashing lights - Debugging counter and time delay program - stack - subroutine - conditional call and return instructions. | |||
Unit – IV BCD to Binary and Binary to BCD conversions - BCD to HEX and HEX to BCD conversions - AS CII to BCD and BCD to ASCII conversions - BCD to Seven segment LED Code conversions - Binary to ASCII and ASCII to Binary conversions - Multibyte Addition - Multibyte subtraction - BCD addition - BCD Subtraction - Multiplication and Division | |||
Unit – V Interrupt - Implementing interrupts - Multiple interrupt - 8085 - trap - Problems on implementing 8085 interrupt - DMA - Memory interfaces - Ram & Rom - I/O interface - Direct I/O - Memory mapped I/O. | |||
Reference:
1. R. S. Gaonkar, 'Microprocessor Architecture, Programming and Applications with 8085/8080A', Wiley East em limited, 1990.
2. A. Mathur, 'Introduction to Microprocessor', Third Edition, Tata McGraw-Hill Publishing Co. Ltd., 1993.
2. A. Mathur, 'Introduction to Microprocessor', Third Edition, Tata McGraw-Hill Publishing Co. Ltd., 1993.
IV SEMESTER
Title of the Course/ | Paper –VII - PROGRAMMING IN JAVA | ||
Core | II Year & Fourth Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in JAVA | ||
Course outline | Unit 1: Introduction to Java-Features of Java-Basic Concepts of Object Oriented Programming-Java Tokens-Java Statements-Constants-Variables-Data Types- Type Casting-Operators-Expressions-Control Statements: Branching and Looping Statements. | ||
Unit-2: Classes, Objects and Methods-Constructors-Methods Overloading-Inheritance-Overriding Methods-Finalizer and Abstract Methods-Visibility Control –Arrays, Strings and Vectors-String Buffer Class-Wrapper Classes. | |||
Unit 3: Interfaces-Packages-Creating Packages-Accessing a Package-Multithreaded Programming-Creating Threads-Stopping and Blocking a Thread-Life Cycle of a Thread-Using Thread Methods-Thread Priority-Synchronization-Implementing the Runnable Interface . | |||
Unit-4: Managing Errors and Exceptions-Syntax of Exception Handling Code-Using Finally Statement-Throwing Our Own Exceptions-Applet Programming-Applet Life Cycle-Graphics Programming-Managing Input/Output Files: Concept of Streams-Stream Classes-Byte Stream Classes-Character Stream Classes – Using Streams-Using the File Class-Creation of Files-Random Access Files-Other Stream Classes. | |||
Unit-5: : Network basics –socket programming – proxy servers – TCP/IP – Net Address – URL – Datagrams -Java Utility Classes-Introducing the AWT: Working with Windows, Graphics and Text- AWT Classes- Working with Frames-Working with Graphics-Working with Color-Working with Fonts-Using AWT Controls, Layout Managers and Menus. | |||
1. Recommended Texts
i.E. Balagurusamy,2004,Programming with JAVA, 2nd Edition,Tata McGraw-Hill Publishing Co.Ltd.
ii.Herbert Schildt,2005,The Complete Reference JavaTM 2, 5th Edition,Tata McGraw-Hill Publishing Co. Ltd.
2. Reference Books
i. Y. Daniel Liang ,2003, An Introduction to JAVA Programming, Prentice-Hall of India Pvt. Ltd.
ii. Cay S. Horstmann and Gary Cornell,2005, Core JavaTM2 Volume I-Fundamentals, 7th Edition- Pearson Education.
iii. Ken Arnold, James Gosling and David Holmes,2003, The JavaTM Programming Language, 3rd Edition, Pearson Education.
Title of the Course/ | Paper –X - OPERATING SYSTEMS | ||
Core | II Year | 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 | COMPUTER GRAPHICS | ||
Elective | II Year & | Credit: 5 | |
Objective | This course introduces the fundamental concepts of Graphics. | ||
Course outline | Unit 1: INTRODUCTION TO COMPUTER GRAPHICS : Brief Survey of Computer Graphics – Graphics Systems: Video Display Devices – Types – Raster-Scan Systems and Random-Scan Systems – Input Devices – Hard-Copy Devices – Graphics Software. | ||
Unit-2: OUTPUT PRIMITIVES AND THEIR ATTRIBUTES Line-Drawing (DDA and Bresenham’s) Algorithms – Circle-Generating (Midpoint) Algorithm – Ellipse-Generating (Midpoint) Algorithms- Area-Filling (Boundary-Fill and Flood-Fill) Algorithms - Line Attributes - Color and Grayscale Levels – Character Attributes – Inquiry Functions. | |||
Unit 3: TWO-DIMENSIONAL TRANSFORMATIONS AND VIEWING : Basic Transformations - Matrix Representations and Homogeneous Coordinates – Composite Transformations - Other Transformations – Window-to- Viewport Coordinate Transformation – Clipping Algorithms: Cohen-Sutherland Line Clipping and Sutherland- Hodgeman Polygon Clipping – Basic Modeling Concepts - Interactive Input Methods: Logical Classification of Input Devices – Interactive Picture-Construction Techniques. | |||
Unit-4: THREE-DIMENSIONAL CONCEPTS: Three-Dimensional Display Methods: Parallel and Perspective Projections – Depth Cueing - Visible Line and Surface Identification – Polygon Surfaces: Polygon Tables, Plane Equations and Polygon Meshes - Three-Dimensional Transformations: Basic, Other and Composite Transformations. | |||
Unit-5 : THREE-DIMENSIONAL VIEWING : Viewing Pipeline and Coordinates – Transformation from World to Viewing Coordinates – Projection Transformations - Matrices - View Volumes - Hidden Surface and Hidden Line Elimination Methods: Back-Face Detection , Depth-Buffer and A-Buffer Methods –Wireframe Methods- Light Sources – RGB,CMY and HLS Color Models | |||
1. Recommended Texts
i. D. Hearn and M.P. Baker,2005,Computer Graphics, 2nd Edition, Pearson Education, Prentice Hall, 19th Reprint.
2.Reference Books
i. S. Harrington,1987, Computer Graphics , 2nd Edition , McGraw-Hill Book Co.
ii. W.M. Newman and R.F. Sproull ,1997, Principles of Interactive Computer
Graphics, 2nd Edition,Tata McGraw-Hill Publishing Co. Ltd.
iii. D.P. Mukherjee ,1999,Fundamentals of Computer Graphics and
Multimedia , 1st Edition, Prentice-Hall of India Pvt. Ltd.
iv. N. Krishnamurthy ,2002, Introduction to Computer Graphics, 1st Edition, Tata
McGraw-Hill Publishing Co. Ltd.
v. D.F.Rogers ,2001,Procedural Elements for Computer Graphics, 2nd Edition,
Tata McGraw-Hill Publishing Co. Ltd.
vi. Z. Xiang and R.A. Plastock,2002, Computer Graphics, Schaum’s Outline Series,
Tata McGraw-Hill Publishing Co.
VI SEMESTER
Paper - I
Title of the Course/ | Paper-XVII WEB TECHNOLOGY | |
Core | III Year & Sixth Semester | Credit: 4 |
Objective of the course | This course introduces the concepts of ASP, VB Script, Java Script. | |
Course outline | Unit 1: Introduction to VBScript - Adding VBScript Code to an HTML Page - VB Script Basics - VBScript Data Types - VBScript Variables - VBScript Constants - VBScript Operators – mathematical- comparison-logical - Using Conditional Statements - Looping Through Code - VBScript Procedures – type casting variables - math functions –date functions – string functions –other functions - VBScript Coding Conventions - Dictionary Object in VBScript - Err Object | |
Unit-2: Introduction to Javascript – Advantages of Javascript – Javascript syntax - Data type –Variable - Array – Operator & Expression – Looping – control structures - Constructor Function – user defined function Dialog Box . | ||
Unit 3: Javascript document object model – Introduction – Object in HTML – Event Handling – Window object – Document object – Browser object – Form object – Navigator object – Screen object – Build in object – User defined object – Cookies. | ||
Unit-4: ASP.NET Language Structure – Page Structure – Page event , Properties & Compiler Directives . HTML server controls – Anchor, Tables, Forms, Files . Basic Web server Controls – Label, Text box, Button, Image Links, Check & radio Button, Hyperlink, Data List Web Server Controls – Check box list. Radio button list, Drop down list, List box, Data grid, Repeater. | ||
Unit-5: Request and Response Objects, Cookies, Working with Data – OLEDB connection class, command class, transaction class, data adaptor class, data set class. Advanced issues – email, Application issues, working with IIS and page Directives , error handling. Security – Authentication, IP Address, Secure by SSL & Client Certificates | ||
1.Recommended Texts
i.I.Bayross, 2000, Web Enable Commercial Application Development Using HTML,
DHTML, Javascript, Perl CGI, BPB Publications.
ii. A.Russell Jones, Mastering Active Server Pages 3, BPB Publications.
2. Reference Books
i. Hathleen Kalata, Internet Programming with VBScript and JavaScript, Thomson
Learning
ii. Mike McGrath, XML Harness the Power of XML in easy steps, Dreamtech
Publications
iii. T.A. Powell, 2002,Complete Reference HTML , TMH.
iv. J.Jaworski, 1999, Mastering Javascript, BPB Publications.
v. Powell, Thomas; Schneider, Fritz, JavaScript: The Complete Reference,
2nd edition 2004, TMH
Paper - II
Title of the Course/ | Paper-XVIII DATA COMMUNICATION AND NETWORKING | ||
Core | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course introduces the concepts of Networking | ||
Course outline | Unit-1: Introduction to Data Communication, Network, Protocols & standards and standards organizations - Line Configuration - Topology - Transmission mode - Classification of Network - OSI Model - Layers of OSI Model. | ||
Unit-2: Parallel and Serial Transmission - DTE/DCE/such as EIA-449, EIA-530, EIA-202 and x.21 interface - Interface standards - Modems - Guided Media - Unguided Media - Performance - Types of Error - Error Detection - Error Corrections. | |||
Unit-3: Multiplexing - Types of Multiplexing - Multiplexing Application - Telephone system - Project 802 - Ethernet - Token Bus - Token Ring - FDDI - IEEE 802.6 - SMDS - Circuit Switching - Packet Switching - Message switching - Connection Oriented and Connectionless services. | |||
Unit-4: History of Analog and Digital Network - Access to ISDN - ISDN Layers - Broadband ISDN - X.25 Layers - Packet Layer Protocol - ATM - ATM Topology - ATM Protocol. | |||
Unit-5 : Repeaters - Bridges - Routers - Gateway - Routing algorithms - TCP/IP Network, Transport and Application Layers of TCP/IP - World Wide Web. | |||
1. Recommended Texts
i.Behrouz and Forouzan,2001,Introduction to Data Communication and Networking,
2nd Edition,TMH.
2. Reference Books
i.Jean Walrand 1998,Communication Networks (A first Course),Second Edition,
WCB/McGraw Hill.
ii. Behrouz and Forouzan,2006,Data Communication and Networking,3nd Edition,
TMH.
Paper-III
Title of the Course/ | Paper -XIX SOFTWARE TESTING | ||
Core | III Year & Sixth Semester | Credit:4 | |
Objective of the course | This course introduces the basic concepts of software testing | ||
Course outline | Unit-1: Introduction: Purpose – Productivity and Quality in Software – Testing Vs Debugging – Model for Testing – Bugs – Types of Bugs – Testing and Design Style. | ||
Unit-2: Flow/Graphs and Path Testing – Achievable paths – Path instrumentation – Application – Transaction Flow Testing Techniques | |||
Unit-3: Data Flow Testing Strategies - Domain Testing: Domains and Paths – Domains and Interface Testing . | |||
Unit-4: Linguistic –Metrics – Structural Metric – Path Products and Path Expressions. Syntax Testing – Formats – Test Cases . | |||
Unit-5 : Logic Based Testing – Decision Tables – Transition Testing – States, State Graph, State Testing. | |||
1. Recommended Texts
i. B. Beizer , 2003, Software Testing Techniques, II Edn., DreamTech India, New Delhi.
ii. K.V.KK. Prasad , 2005, Software Testing Tools, DreamTech. India, New Delhi.
2. Reference Books
i. Burnstein, 2003, Practical Software Testing, Springer International Edn.
ii. E. Kit, 1995, Software Testing in the Real World: Improving the Process, Pearson Education, Delhi.
iii. R.Rajani, and P.P.Oak, 2004, Software Testing, Tata Mcgraw Hill, New Delhi.
PAPER-IV
ELECTIVE II
Title of the Course/ Paper | DATA MINING | ||
Elective | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course introduces the fundamental concepts of Data Mining. | ||
Course outline | Unit-1: Introduction: Data mining – Functionalities – Classification – Introduction to Data Warehousing – Data Preprocessing : Preprocessing the Data – Data cleaning – Data Integration and Transformation – Data Reduction | ||
Unit-2: Data Mining, Primitives, Languages and System Architecture: Data Mining – Primitives – Data Mining Query Language,. Architectures of Data mining Systems. Concept Description, Characterization and Comparison: Concept Description, Data Generalization and Summarization, Analytical Characterization, Mining Class Comparison – Statistical Measures. | |||
Unit-3: Mining Association Rules : Basics Concepts – Single Dimensional Boolean Association Rules From Transaction Databases, Multilevel Association Rules from transaction databases – Multi dimension Association Rules from Relational Database and Data Warehouses. | |||
Unit-4: Classification and Prediction: Introduction – Issues – Decision Tree Induction – Bayesian Classification – Classification of Back Propagation. Classification based on Concepts from Association Rule Mining – Other Methods. Prediction – Introduction – Classifier Accuracy. | |||
Unit-5: Cluster Analysis: Introduction – Types of Data in Cluster Analysis, Petitioning Methods – Hierarchical Methods Density Based Methods – GRID Based Method – Model based Clustering Method. | |||
1. Recommended Texts
i.J.Han and M. Kamber,2001,Data Mining Concepts and Techniques,Harcourt India Pvt.
Ltd - New Delhi.
2. Reference Books
i. K.P. Soman , Shyam Diwakar, V.Ajay ,2006, Insight into Data Mining Theory and
Practice, Prentice Hall of India Pvt. Ltd - New Delhi.
3. Website, E-learning resources
i http:// www.academicpress.com
Title of the Course/ Paper | E-COMMERCE | ||
Elective | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course gives an exposure to the Electronic Commerce | ||
Course outline | Unit-1: Electronic Commerce and Opportunities : Background The Electronic Commerce Environment – Electronic Marketplace Technologies – Modes of Electronic Commerce: Overview : Electronic Data Interchange. | ||
Unit-2:. Approaches to Safe Electronic Commerce . Overview – Secure Transport Protocols – Secure Transaction – Secure Electronic Payment Protocol (SEPP) – Secure Electronic Transaction (SET) | |||
Unit-3:. Certificates for Authentication – Security on Web Servers – Payment Schemes: Internet Monetary Payment and Security Requirements- Payment and purchase order process – Online electronic cash. | |||
Unit-4:.Internet / Intranet Security Issues and Solutions : The Need for Computer Security – Specific Intruder Approaches – Security Strategies- Security Tools – Encryption – Enterprise Networking and Access to the Internet Antivirus Programs.- Security Teams | |||
Unit-5: MasterCard/Visa Secure Electronic Transaction : Introduction –Business Requirements – Concepts – payment Processing. E-mail and secure e-mail technologies for Electronic Commerce: Introduction _ The Means of Distribution – A model for Message Handling- MIME, S/MIME, MOSS , MIME and Related Facilities for EDI over the Internet. | |||
Recommended Texts:
Daniel Minoli & Emma Minoli, “Web Commerce Technology Handbook”. Tata McGraw Hill – 1999.
Reference Book:
1.K.Bajaj & D Nag , “E-Commerce”, Tata McGraw Hill – 1999.
2.Mamta Bhusry – “E-Commerce”
Title of the Course/ Paper | OBJECT ORIENTED ANALYSIS AND DESIGN | ||
Elective | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course introduces to UML, object oriented analysis and design of any application | ||
Course outline | Unit-1: System Development - Object Basics - Development Life Cycle - Methodologies - Patterns - Frameworks - Unified Approach - UML. | ||
Unit-2: Use-Case Models - Object Analysis - Object relations - Attributes - Methods - Class and Object responsibilities - Case Studies. | |||
Unit-3: Design Processes - Design Axioms - Class Design - Object Storage - Object Interoperability - Case Studies. | |||
Unit-4: User Interface Design - View layer Classes - Micro-Level Processes - View Layer Interface - Case Studies. | |||
Unit-5 : Quality Assurance Tests - Testing Strategies - Object orientation on testing - Test Cases - test Plans - Continuous testing - Debugging Principles - System Usability - Measuring User Satisfaction - Case Studies. | |||
Recommended Texts
1. Ali Bahrami - Object Oriented Systems Development - McGraw Hill International
Edition - 1999.
2. Grady Booch- Object Oriented Analysis and design –Addison Wesley.
PAPER V
ELECTIVE III
Title of the Course/ Paper | MULTIMEDIA SYSTEMS | ||
Elective | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course gives an exposure to Multimedia and its applications. | ||
Course outline | Unit-1: What is Multimedia: Definitions - CD-ROM and the Multimedia Highway - Where to use Multimedia - Introduction to Making Multimedia: The stages of a Project - What You Need - Multimedia Skills and Training: The team - Macintosh and Windows Production Platforms: Macintosh Versus PC - The Macintosh Platform - The Windows Multimedia PC Platform - Networking Macintosh and Windows Computers- Hardware Peripherals: Connection - Memory and Storage Devices - Input Devices - Output Hardware - Communication Devices. | ||
Unit-2: Basic Tools: Text Editing and Word Processing Tools - OCR Software - Painting and Drawing Tools - 3-D Modeling and Animation Tools - Image-Editing Tools - Sound Editing Tools - Animation, Video and Digital Movie Tools - Helpful Accessories - Making Instant Multimedia: Linking Multimedia Objects - Office Suites - Word Processors - Spreadsheets - Databases - Presentation Tools. Multimedia Authoring Tools: Types of Authoring Tools - Card-and-Page-Based Authoring Tools - Icon-Based Authoring Tools - Time-Based Authoring Tools - Object-Oriented Authoring Tools - Cross-Platform Authoring Notes | |||
Unit-3: Text: The Power of Meaning - About Fonts and Faces - Using Text in Multimedia - Computers and Text - Font Editing and Design Tools - Hypermedia and Hypertext - Sound: The Power of Sound - Multimedia System Sounds - MIDI Versus Digital Audio - Digital Audio - Making MIDI Audio - Audio File Formats - Working with Sound on the Macintosh - Notation Interchange File Format (NIFF) - Adding Sound to Your Multimedia Project - Toward Professional Sound: The Red Book Standard - Production Tips | |||
Unit-4: Images: Making Still Images -Color - Image File Formats. Animation: The Power of Motion - Principles of Animation - Making Animations That Work - Video: Using Video - How Video works - Broadcast Video Standards - Integrating Computers and Television - Shooting and Editing Video - Video Tips - Recording Formats - Digital Video. | |||
Unit-5:. Planning and Costing : Project Planning - Estimating - RFPs and Bid Proposals - Designing and Producing : Designing - Producing - Content and Talent : Acquiring Content - Using Content Created by Others - Using Content Created for a Project - Using Talent - Delivering : Testing - Preparing for Delivery - Delivering on CD-ROM - Compact Disc Technology - Wrapping It Up - Delivering on the World Wide Web. | |||
Recommended Texts:
a. Tay Vaughan - Multimedia: Making it Work. - Fourth Edition - Tata McGraw Hill Edition - 1999.
b) Walterworth John A - Multimedia Technologies and Application - Ellis Horwood Ltd. - London - 1991.
c) John F Koegel Buford - Multimedia Systems - Addison Wesley - First Indian Reprint - 2000.
Title of the Course/ Paper | CLIENT / SERVER COMPUTING | ||
Elective | III Year & Sixth Semester | Credit:4 | |
Objective of the course | This Subject deals with the C/S Computing, GUI. | ||
Course outline | Unit-1: Introduction to Client/Server Computing – What is Client/Server Computing – Benefits of Client/Server Computing – Evolution of C/S Computing – Hardware Trends – Software Trends-Evolution of Operating Systems – N/w Trends – Business Considerations. | ||
Unit-2: Overview of C/S Applications: Components of C/S Applications – Classes of C/S Applications – Categories of C/S Applications . Understanding C/S Computing : Dispelling the Myths – Obstacles – Upfront & Hidden – Open Systems & Standards – Standards – Setting Organizations – Factors of Success. | |||
Unit-3: The Client Hardware & Software : Client Component – Client Operating Systems – What is GUI – Database Access – Client Software Products : GUI Environments – Converting 3270/5250 Screens – Database Tools – Client Requirements : GUI Design Standards – Open GUI Standards – Interface Independence – Testing Interfaces . | |||
Unit-4: The Server : Categories of Servers – Features of Server Machines – Classes of Server Machines – Server Environment : N/W Management Environment – N/W Computing Environment – Extensions – Network Operating System – Loadable Module. | |||
Unit-5 : Server Operating System : OS/2 2.0 – Windows New Technology – Unix Based OS – Server Requirements : Platform Independence – Transaction Processing – Connectivity – Intelligent Database – Stored Procedure – Triggers – Load Leveling – Optimizer – Testing and Diagnostic Tools – Backup & Recovery Mechanisms. | |||
1. Recommended Texts
1.Patrick Smith & Steave Guengerich, “Client/Server Computing”. PHI
2. Dawna Travis Devire, “Client/Server Computing”. TMH
Title of the Course/ Paper | DISTRIBUTED COMPUTING | ||
Elective | III Year & Sixth Semester | Credit: 4 | |
Objective of the course | This course introduces the concepts of Distributed databases and Distributed File system and its Hardware concepts.. | ||
Course outline | Unit-1: Distributed data base – Security and Integrity – New Data base application – Design of data bases – Knowledge based case studies for relational network and hierarchical systems. Distributed processing – Models for distributed computing – Load balancing – Remote procedure calls – process migration – concurrency issues on data bases. | ||
Unit-2: Hardware concepts – Switched multiprocessor, Bus based multicomputers, Switched multicomputers – Software concepts – Network operating systems and NFS – Time distributed systems.- Design Issues : Transparency – Flexibility – Reliability – performance and scalability. | |||
Unit-3: Communications in distributed systems – The client – server model, Blocking vs Unbuffered primitives - Implementation of client-server model. | |||
Unit-4: Synchronization in distributed systems – Clock synchronization – Mutual exclusion – Election algorithms – Atomic transactions – Deadlocks in distributed system – Threads – Thread usage and Implementation of thread packages – processor allocation. | |||
Unit-5 : Distributed File system : File service interface – semantics of the file sharing – Distributed file system – Implementation of new trends in distributed file systems. | |||
1.Recommended Texts
i. A.S Tanenbaum, “ Modern Operating Systems “ , Pearson Education
2.. Reference Books
i.James Martin, “ Computer Networks and Distributed Processing, Software
Techniques and Architectures”, Pearson Education.
I SEMESTER
Programming in C
Title of the Course/ Paper | Programming in C | ||
Core | I Year & First Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in C | ||
Course outline | Unit 1: C fundamentals Character set - Identifier and keywords - data types - constants - Variables - Declarations - Expressions - Statements - Arithmetic, Unary, Relational and logical, Assignment and Conditional Operators - Library functions. | ||
Unit-2: Data input output functions - Simple C programs - Flow of control ‑ if, if‑else, while, do-while , for loop, Nested control structures - Switch, break and continue, go to statements - Comma operator. | |||
Unit 3: Functions –Definition - proto-types - Passing arguments - Recursions. Storage Classes - Automatic, External, Static, Register Variables – Multi-file programs. | |||
Unit-4: Arrays - Defining and Processing - Passing arrays to functions – Multi-dimension arrays - Arrays and String. Structures - User defined data types - Passing structures to functions - Self-referential structures – Unions - Bit wise operations. | |||
Unit-5 : Pinters - Declarations - Passing pointers to Functions - Operation in Pointers - Pointer and Arrays - Arrays of Pointers - Structures and Pointers - Files : Creating , Processing ,Opening and Closing a data file. | |||
1. Recommended Texts
i.E.Balaguruswamy, 1995,Programming in ANSI C, TMH Publishing Company Ltd.
2. Reference Books
i.B.W. Kernighan and D.M.Ritchie, 1988,The C Programming Language, 2nd Edition, PHI.
ii.H. Schildt, C,2004, The Complete Reference, 4th Edition, TMH
iii. Gottfried,B.S, 1996,Programming with C, Second Edition, TMH Pub. Co. Ltd., New Delhi .
iv. Kanetkar Y., 1999,Let us C, BPB Pub., New Delhi .
II SEMESTER
Digital Electronics & Microprocessors
Title of the Course/ Paper | Digital Electronics & Microprocessors | ||
Core | I Year & Second Semester | Credit: 4 | |
Objective of the course | This course introduces the concepts of fundamentals of Digital Electronics and Microprocessor. | ||
Course outline | Unit 1: Binary Systems & Code conversion,Boolean Algebra & Logic Gates – Truth Tables – Universal Gates – Simplification of Boolean functions: SOP, POS methods – K-map, – Combinational Logic: Adders & Subtractors – Multiplexer – Demultiplexer - Encoder – Decoder. | ||
Unit-2: Sequential Logic: RS, Clocked RS, D, JK, Master Slave JK, T Flip-Flops – Shift Registers – Types of Shift Registers – Counters: Ripple Counter – Synchronous Counters – Up-Down Counter. | |||
Unit 3: Introduction to Microprocessors, Microcomputers, and Assembly Language – Microprocessor Architecture and Its Operations – Memory – I/O Devices – 8085 MPU – Introduction to 8085 Instructions – Data Transfer Operations – Addressing Modes - Arithmetic, Logic and Branch Operations – Writing Assembly Language Programs . | |||
Unit-4: Time Delay Programs: Time Delay Using One Register – Using a Register Pair – Using a Loop within Loop Technique – Counter Design with Time Delay – Stack and Subroutines – BCD to Binary Conversion and Vice-versa – BCD to HEX Conversion and Vice-versa – Binary to ASCII Conversion and Vice-versa – BCD Addition and Subtraction . | |||
Unit-5 : 8085 Interrupt – Vectored Interrupts – Interfacing I/O Devices: Basic Interfacing Concepts – Interfacing Input Devices- Memory-Mapped I/O. | |||
1. Recommended Texts
i.M. Morris Mano,2005, Digital Logic and Computer Design, Prentice-Hall of India Pvt. Ltd.
ii. Ramesh S. Gaonkar,1999,Microprocessor Architecture, Programming, and Applications with the 8085, 5thEdition,Penram International Publishing (India ) Pvt. Ltd.
2. Reference Books
i. D. P. Leach and A. P. Malvino,2002,Digital Principles and Applications,5th Edition, Tata McGraw, Hill Publishing Co. Ltd.
ii. V. Vijayendran,2004,Digital Fundamentals,S. Viswanathan (Printers & Publishers) Pvt. Ltd.
iii. V. Vijayendran ,2004, Fundamentals of Microprocessor – 8085, S. Viswanathan (Printers & Publishers) Pvt. Ltd.
iv. N. K. Srinath,2005, 8085 Microprocessor Programming and Interfacing,Prentice-Hall of India Pvt. Ltd.
III SEMESTER
PROGRAMMING IN C++ AND DATA STRUCTURES
Title of the Course/ | Paper –V PROGRAMMING IN C++ AND DATA STRUCTURES | ||
Core | II Year & Third Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in C++ and Data Structures | ||
Course outline | Unit 1: Introduction to C++; Tokens, Keywords, Identifiers, Variables, Operators, Manipulators, Expressions and Control Structures in C++; Pointers - Functions in C++ ‑ Main Function ‑ Function Prototyping ‑ Parameters Passing in Functions - Values Return by Functions - Inline Functions - Friend and Virtual Functions | ||
Unit-2: Classes and Objects; Constructors and Destructors; and Operator Overloading and Type Conversions - Type of Constructors - Function overloading. Inheritance : Single Inheritance ‑ Multilevel Inheritance ‑ Multiple Inheritance ‑ Hierarchical Inheritance ‑ Hybrid Inheritance. Pointers, Virtual Functions and Polymorphism; Managing Console I/O operations. | |||
Unit 3: Working with Files: Classes for File Stream Operations ‑ Opening and Closing a File ‑ End‑of‑File Deduction ‑ File Pointers ‑ Updating a File ‑ Error Handling during File Operations ‑ Command‑line Arguments. Data Structures: Definition of a Data structure ‑ primitive and composite Data Types, Asymptotic notations, Arrays, Operations on Arrays, Order lists. | |||
Unit-4: Stacks - Applications of Stack ‑ Infix to Postfix Conversion, Recursion, Maze Problems - Queues ‑ Operations on Queues, Queue Applications, Circular Queue. Singly Linked List ‑ Operations, Application ‑ Representation of a Polynomial, Polynomial Addition; Doubly Linked List ‑ Operations, Applications. | |||
Unit-5 : Trees and Graphs: Binary Trees ‑ Conversion of | |||
1. Recommended Texts
i. E. Balagurusamy,1995,Object Oriented Programming with C++, Tata McGraw‑Hill
Publishing Company Ltd.
ii..E.Horowitz and S.Shani,1999,Fundamentals of Data Structures in C++ , Galgotia Pub.
2.Reference Books
i. Robert Lafore, Object Oriented Programming in Microsoft C++, Galgotia publication.
ii.. H.Schildt, C++,1998,The Complete Reference-1998-TMH Edition, 1998
iii.R. Kruse C.L. Tondo and B. Leung ,1997, Data Structures and Program design in C,
PHI.
iii.Cangsam,Auguenstein,Tenenbaum,Data Structures using C & C++,PHI
iv.D.Samantha,2005, Classic Data Structures, PHI,New Delhi
IV SEMESTER
PROGRAMMING IN JAVA
Title of the Course/ | Paper –VII - PROGRAMMING IN JAVA | ||
Core | II Year & Fourth Semester | Credit: 4 | |
Objective of the course | This course introduces the basic concepts of programming in JAVA | ||
Course outline | Unit 1: Introduction to Java-Features of Java-Basic Concepts of Object Oriented Programming-Java Tokens-Java Statements-Constants-Variables-Data Types- Type Casting-Operators-Expressions-Control Statements: Branching and Looping Statements. | ||
Unit-2: Classes, Objects and Methods-Constructors-Methods Overloading-Inheritance-Overriding Methods-Finalizer and Abstract Methods-Visibility Control –Arrays, Strings and Vectors-String Buffer Class-Wrapper Classes. | |||
Unit 3: Interfaces-Packages-Creating Packages-Accessing a Package-Multithreaded Programming-Creating Threads-Stopping and Blocking a Thread-Life Cycle of a Thread-Using Thread Methods-Thread Priority-Synchronization-Implementing the Runnable Interface . | |||
Unit-4: Managing Errors and Exceptions-Syntax of Exception Handling Code-Using Finally Statement-Throwing Our Own Exceptions-Applet Programming-Applet Life Cycle-Graphics Programming-Managing Input/Output Files: Concept of Streams-Stream Classes-Byte Stream Classes-Character Stream Classes – Using Streams-Using the File Class-Creation of Files-Random Access Files-Other Stream Classes. | |||
Unit-5: : Network basics –socket programming – proxy servers – TCP/IP – Net Address – URL – Datagrams -Java Utility Classes-Introducing the AWT: Working with Windows, Graphics and Text- AWT Classes- Working with Frames-Working with Graphics-Working with Color-Working with Fonts-Using AWT Controls, Layout Managers and Menus. | |||
1. Recommended Texts
i.E. Balagurusamy,2004,Programming with JAVA, 2nd Edition,Tata McGraw-Hill Publishing Co.Ltd.
ii.Herbert Schildt,2005,The Complete Reference JavaTM 2, 5th Edition,Tata McGraw-Hill Publishing Co. Ltd.
2. Reference Books
i. Y. Daniel Liang ,2003, An Introduction to JAVA Programming, Prentice-Hall of India Pvt. Ltd.
ii. Cay S. Horstmann and Gary Cornell,2005, Core JavaTM2 Volume I-Fundamentals, 7th Edition- Pearson Education.
iii. Ken Arnold, James Gosling and David Holmes,2003, The JavaTM Programming Language, 3rd Edition, Pearson Education.
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 – 7th 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, 6th Edition- PHI,New Delhi .
2. Reference Books
i..C. Hamacher, Z. Vranesic, S.Zaky, 2002, Computer Organization,5th Edition,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 – | |
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.
2. Stefen Prata - Advanced UNIX - A Programmer Guide.