[SYLLABUS] MADRAS UNIVERSITY BCA 5TH SEMESTER SYLLABUS [20/06/2016]

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 – 7^th 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,2^nd 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, 5^th 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: Payroll Mark sheet Processing Saving Bank account for banking Inventory System Invoice system Library information system Student information system Income tax processing system Electricity bill preparation system 10.Telephone directory maintenance

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.

*** ALL THE BEST ***