III BCA V SEM SYLLABUS

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 – 7^th 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,2^nd 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

1. Gary Cornell - Visual Basic 6 from the Ground up - Tata McGraw Hill - 1999.
2. 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.