SEMESTER V
Title of the Course/
|
Paper-XIII
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
-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.
Title of the Course/
|
Paper
-XV RESOURCE MANAGEMENT
TECHNIQUES
|
||
Core
|
III Year &
Fifth Semester
|
Credit: 4
|
|
Objective of the course
|
This course introduces the concepts of Resource Management Technique
|
||
Course outline
|
Unit-1: Basics of Operations Research ( OR): Characteristics of O.R ‑
Necessity of O.R in Industry ‑OR and Decision making ‑ Role of computers in
O.R. Linear programming: Formulations and Graphical solution (of 2 variables)
canonical & standard terms of Linear programming problem. Algebraic solution: Simplex method.
|
||
Unit-2: Algebraic solution: Charnes method of
penalties ‑ two phase simplex method ‑ concept of Duality ‑ properties of
duality ‑ Dual simplex method.
|
|||
Unit-3: Transportation model: Definition ‑
formulation and solution of transportation models ‑ the row ‑ minima, column ‑
minima, matrix minima and vogel's approximation methods. Assignment model:
Definition of Assignment model ‑ comparison with transportation model ‑
formulation and solution of Assignment model ‑ variations of Assignment
problem.
|
|||
Unit-4: Sequencing problem: Processing each of n jobs through m machines ‑
processing n jobs through 2 machines ‑ processing n jobs through 3 machines ‑
processing 2 jobs through m machines ‑ processing n jobs through m machines ‑
travelling salesman problem. Game Theory: Characteristics of games ‑ Maximin,
Minimax criteria of optimality ‑ Dominance property ‑ algebraic and graphical
method of solution of solving 2 x 2 games.
|
|||
Unit-5 : Pert ‑ CPM:
Networks ‑ Fulkerson's Rule ‑ measure of activity ‑ PERT computation ‑
CPM computation ‑ resource scheduling. Simulation: Various methods of
obtaining random numbers for use in computer simulation ‑ Additive,
multiplicative and mixed types of congruence random number generators ‑ Monte
Carlo method of simulation ‑ its advantages and disadvantages.
|
|||
1.Recommended Texts
i.
Hamdy A. Taha: ,1996,Operation Research ‑ An Introduction, 5th
edition, Prentice Hall of India, Pvt. Ltd., New Delhi .
ii.. Ackoff R.L. and Sasieni M.
W,1968, Fundamentals of Operations Research, John Wiley and sons, New York.
iii. Charnes A. Cooper W. and
Hendersen A.,1953, Introduction to
Linear Programming, Wiley and Sons, New York.
iv. Srinath L.S,1973, PERT and CPM
principles and applications, Affiliated
East West Press Pvt. Ltd., New York .
Title of the Course/
|
Paper
_XVI RDBMS
LAB
|
||
Core
|
III Year &
Fifth Semester
|
Credit: 4
|
|
Objective of the course
|
This course gives
an exposure to visual programming using
Visual Basic software.
|
||
Course outline
|
Creation of a Database and performing the operations given below using
a Menu Driven Program.
a) Insertion b)Deletion c)
Modification d) Generating a Simple
report for the following:
|
||
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.
*** ALL THE BEST ***
