:: St. Joseph's Evening College ::

Syllabus BCA

III SEMESTER

Theory Question Paper Format
The question papers of the theory examinations should follow the pattern specified below:

Section	Marks for Each Question	Number of Questions		Total Marks
Section	Marks for Each Question			Total Marks	Total	Should Answer
A	3	8	6	18
B	8	6	4	32
C	10	3	2	20
			Total Marks	70

While selecting the questions importance should be given to all major units.

PRACTICAL QUESTION PAPER FORMAT

Scheme of valuation:
1.	Writing two programs one from each section	20 marks
2.	Execution of one program	20 marks
3.	Formatting the program and output	10 marks
3.	Record verification	10 marks
4.	Viva voce related to practical topics only	10 marks
Total Marks		70

PROJECT EVALUATION FORMAT

Scheme of valuation:
1.	Demonstration and presentation	70 marks
2.	Documentation	30 marks
Total Marks		100

TITLE: OOPS Using C++
CODE: CA3112
Hrs / Week: 4 Hrs
CREDITS: 3

Introduction:
Procedural Languages, definition of OOP, Basic concept of OOP, Object, Class, Data Abstraction, Data Encapsulation, Data Hiding member functions, Reusability, Inheritance, Creating new Data Types, Polymorphism, Overloading, Dynamic binding, and Message passing.2 Hrs

C++ Features and Functions:
The iostream class, C++ Comments, C++ Keywords, Variable declaration, The Const Qualifier. The Endl, Set W, set precision, Manipulators, The scope resolution operator, new & delete Operators. Simple Functions: Passing argument to, returning value from function; passing constants, Variables, pass by value, passing structure variables, pass by reference, Default arguments, return statements, return by reference, overloaded functions; Different number of arguments, Different Kinds of arguments, inline function. 10 Hrs

Objects and Classes:
Classes & Objects, Class Declaration, Class members; Data Constructors, Destructors, Member functions, Class member visibility; private, public, protected. The scope of the class object constructors; Default Constructor, Constructor with argument, constructor with default arguments, Dynamic constructor, copy constructor, Overloaded constructor, Objects as function arguments; member functions defined outside the class, Objects as arguments, returning objects from functions, class conversion, manipulating private Data members, Destructors, objects & memory, array as class member data, Array of objects, string as class member.12 Hrs

Operator Overloading:
Overloading unary operator: Operator Keyword, Operator Arguments, Operator return value, Nameless temporary objects, limitations of increment operator, overloading binary operator, arithmetic operators, comparison operator, arithmetic assignment operator, Data conversion; conversion between Basic types, Conversion between objects & Basic types, conversion between objects of different classes.12 Hrs

Inheritance:
Derived Class & Base Class: Specifying the Derived class accessing Base class members, the protected access specifier, Derived class constructor, Overriding member functions, public and private inheritance; Access Combinations, Classes & Structures, Access Specifiers, Level of inheritance; Multilevel inheritance, Hybrid inheritance, Multiple inheritance; member functions in multiple inheritance, constructors in multiple inheritance. 12 Hrs

Virtual Functions:
Normal member function accessed with pointers, Virtual member functions accessed with pointers, pure virtual functions, Friend function; Friends for functional notation, friend classes, this pointer; Accessing Member Data with this, using this for returning values.6 Hrs

Templates and Exception Handling:
Introduction, Templates, Class Templates, function templates, Member function templates, Template arguments, Exception Handling. 6 Hrs

BOOKS:
1. Prata : C++ Primer Plus, 4/e Pearson Education
2. Lafore Robert : Object Oriented Programming in Turbo C
++, Galgotia Publications
3. Lippman : C++ Primer, 3/e Pearson Education
4. E. Balaguruswamy: Object Oriented Programming with C++, Tata McGraw Hill Publications.
5. Strousstrup : The C++ Programming Language, Pearson Edition, 3rd Edition
6. Kamthane : Object Oriented Programming with ANSI and Turbo C++, Pearson Education
7. Bhave : Object Oriented Programming Using C++, Pearson Education

TITLE: Visual Programming
CODE: CA3212
Hrs / Week: 4 Hrs
CREDITS: 3

Introduction:
Windows Concepts, Objects and events, Define design and development process, Identify elements of IDE, Write, run, save, and print a project, Use online Help. 4 Hrs

Introduce controls and their properties:
Text boxes, group boxes, check boxes, radio buttons, picture boxes and naming conventions, User friendly features: access keys, default and cancel buttons, tab sequence, Tool Tips, resetting focus, Changing properties at run-time, Concatenate strings. 4 Hrs

Variables, constants and calculations:
Declaration of variables and constants considering data types and scope, Explicit data type conversions, Perform calculations using arithmetic operators and order of operations, Use of accumulators and counters, Use formatting functions to format output. 4 Hrs

Decisions and conditions:
Use If statements to control the flow of logic, Use And and/or operators, Call event procedures, Input validation, Debug tools - set break points, stepping and observation of intermediate results. 4 Hrs

Arrays:
Declare arrays and refer to elements using subscripts, Use for Each/Next statements, Structure Variables, Store data in multidimensional array. 2 Hrs

Lists, Loops, and Printing:
Create and use list boxes and combo boxes, Use Do/Loops and For/Next statements, Send information to the printer. 2 Hrs

Menus, procedures and functions:
Create menus and submenus for program control, Write reusable code in sub procedures and sub functions. 6 Hrs

Toolbars and Status bar:
Creating toolbars, Adding images to toolbars, Writing code to work with toolbars, Creating and using a status bar, Adding panels to the status bar.4 Hrs

Other controls:
TabControl, MonthCalendar and Date/TimePicker, Common Dialog (Open/SaveFile),ProgressBar.4 Hrs

File handling and file controls in VB: 4 Hrs

Database Connectivity:
Data base basics & database engine, Create a database in Access Through VB, The nature of a relational databases, The data controls (DAO and ADO), Data Bound controls, Working with database objects in code, Data Manipulation through VB – Forms, Develop a database application.12 Hrs

Introduction to Graphics and animation: 2 Hrs

Multiple Document Interface (MDI)
Overview of MDI, Creating parent and child forms, Writing code for parent and child forms, Child window management, Creating applications.4 Hrs

Creating and using reports:
Printing with windows forms, Data reports, Using Crystal Reports. 4 Hrs

BOOKS:
1. Deitel, Visual Basic.net How to Program. Pearson Education
2. Evangelas and Petroutsos, Mastering VB 8, 1st Edition, BPB Publications (2001).
3. Gottfried, Programming with Visual Basic, Schaum's Series - Tata McGraw Hill.
4. Charuta Mundada, Harshita Vachhani VB.NET Programming
5. Michael Halvorson Microsoft Visual Basic .NET

TITLE: Database Management Systems
CODE: CA3312
Hrs / Week: 4 Hrs
CREDITS: 3

Introduction:
Data, Database, Database management system, Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Advantages of Using a DBMS and When not to use a DBMS. 6 Hrs

DBMS Architecture:
Data Models – Categories of data models, Schemas, Instances, and Database state. DBMS Architecture and Data Independence – The Three schema architecture, Data independence. DBMS Languages and Interfaces. Classifications of Database Management Systems. 6 Hrs

Data Modeling Using Entity-Relationship Model: Using High Level Conceptual Data Models for Database Design, Example Database applications. Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Roles and Structural constraints. Weak Entity Types and Drawing E- R Diagrams. 6 Hrs

Index Structures for Files:
Single Level Ordered Indexes – Primary indexes, Clustering indexes and Secondary indexes. Multi-level indexes, Dynamic Multilevel indexes using B-trees (Introductory concepts). Hashing concepts. 6 Hrs

Relational Data Model:
Relation, Integrity constraints - domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations. Functional dependencies and Normalization for Relational Databases - Normalization concepts, first, second, third normal forms, Boyce-Codd normal form. 12 Hrs

SQL:
Queries, sub queries, correlated sub query, views, updation of a database through views, Update, Delete. 4 Hrs

Transaction Processing Concepts and Concurrency Control Techniques:
Transaction and System concepts – Desirable properties of Transactions – Schedules and Recoverability. Lock-Based Protocols – Locks, Granting of Locks, and Two phase locking protocol and implementation of locking.6 Hrs

Data Base Administration:
Introduction to Database security issues, Discretionary Access Control Based on Granting/Revoking of Privileges and Multi-level security.6 Hrs

Distributed Databases:
Distributed database concepts, Data fragmentation, Replication, and Allocation Techniques for Distributed database design, Types of Distributed database systems.

Introduction to Advanced Database concepts – Brief introduction to Data warehousing and Data mining. 8 Hrs

BOOKS:
1. Elmasri & Navathe, Fundamentals of Database Systems (Fourth Edition), Pearson Education, 2003.
2. Sundarraman, Oracle 9i programming A Primer,1/e Pearson Education.
3. Karate, Introduction to Database Management System, Pearson Education 2004.
4. Abrahamsi. Silberschatag, Henry. F. Korth, S. Sudarshan, Database System Concepts, McGraw hill.
5. Jeffrey. D. Ullman, Principles of database system.
6. Oracle Press: ORACLE - Computer reference
7. C.J. Date, Introduction to database systems, Sixth Edition, Addison Wesley, 1995.
8. Raghu Ram Krishnan, Database Management Systems, Second Edition,. McGraw Hill, 2000.

TITLE: Software Engineering
CODE: CA3412
Hrs / Week: 4 Hrs
CREDITS: 3

Introduction:
Software Products and Software process, Process models: Waterfall modal, Evolutionary Development, Bohemia’s Spiral model, Overview of risk management, Process Visibility, Professional responsibility. 4 Hrs

Computer based System Engineering:
Systems and their environment, System Procurement, System Engineering Process, System architecture modeling, Human Factors, System reliability Engineering. 3 Hrs

Requirements and Specification:
The requirement Engineering Process, The Software requirement document, Validation of Evolution of requirements, Viewpoint – oriented & method based analysis, System contexts, Social 7 organizational factors, Data flow, Semantic, Object, models, Requirement definition, Requirement Specification, Non functional requirement. 8 Hrs

Software prototyping:
Prototyping in software process, Prototyping techniques, User interfaces prototyping.2 Hrs

Software Design:
Design Process, Design Strategies, Design Quality, System Structuring, Control models, Modular decomposition, Domain Specific architecture.5 Hrs

Object Oriented and function oriented design:
Objects, object Classes and inheritance, Object identification, an object oriented design example, Concurrent Objects, Data flow design, Structural decomposition, Detailed Design, A Comparison of design Strategies.5 Hrs

User interface design:
Design Principles, User System interaction, Information Presentation, User Guidance, Interface Evaluation. 3 Hrs

Software Reliability and reusability:
Software reliability metrics, Software reliability Specification, Statistical testing, Reliability Growth modeling, Fault avoidance & tolerance, Exception handling & defensive programming, Software development with reuse, Software development for reuse, Generator based reuse, Application System Portability. 8 Hrs

Software Verification and Validation:
The testing Process, Test Planning & Strategies, Black Box, Structural, interface testing, Program inspections, Mathematically based verification, Static analysis tools, Clean room software development.8 Hrs

Management Issues:
Project management, Quality management, Software cost estimation, Software maintenance.4 Hrs

BOOKS:
1. Ian Summerville, Software Engineering, 6th Edition, Pearson Publication Ltd. 2001
2. Roger Pressman, Software Engineering – A practitioner’s approach (McGraw Hill).
3. Carlo Ghejgietal, Fundamentals of Software- Engineering, Pearson Education.
4. Panakaj Jalote, An Integrated Approach to Software Engineering – Narosa
5. Publishing house.

PRACTICALS
TITLE: C++ LAB
CODE: CA3P1
Hrs / Week: 2 Hrs
CREDITS: 1

PART A (Program related to C++ concepts)
1. Find the largest and second largest of four numbers.
2. Check whether a given date is valid.
3. Find the GCD and LCM of two numbers
4. Find N C R where N C R = N ! / ((N-R)! * ( R!))
5. Generate the fibonacci series using arrays.
6. Interchange the values of two variables using reference variables.
7. Find the factorial of a number using function overloading.
8. Find whether a given number is prime using function overloading.
9. Calculate compound interest using default arguments where CI = P * ( 1 + R / 100 )T.
10. Check whether a given number is odd or even using inline functions.

PART B (Program related to OOPS concepts)
1. Write a program to create a student database for a class containing Name, Reg No, Class, Combination include the following

a. Constructors
b. Destructors
c. Default constructors
d. Input and Output functions and Input and Output for 5 people using different methods.

2. Create a class to hold information for a customer about his current-account and savings-account in a bank. Using friend functions find the total balance of both the account.

3. Write a program to overload the following operators.
a. Binary operator ‘ +’ to concatenate 2 strings and compare using ‘==’
b. Relational operator ‘ < ‘ to find whether one date is less than other.
c. Find the sum of 2 matrices using operator ‘ +’
d. Find the next date of a given date using ‘++’ operator
e. Using ‘+’. ‘-‘, ‘*’ to find the sum , difference and product of 2 complex numbers

4. Create a base class for a stack and implement push and pop operation. Include derived class to check for stack criteria’s such as
a. Stack is empty
b. Stack is full

TITLE: VISUAL PROGRAMMING and DBMS LAB
CODE: CA3P2
Hrs / Week: 2 Hrs
CREDITS: 1

1. Design an application to validate the user name and password and display message.
2. Design an application to change font style, size, color using a combo box.
3. Design a caculator.
4. Design an application to show usage of timer.
5. Design an application to find the sum of numbers.
6. Design an application to authenticate travel system using list and combo box.
7. Design an application to add and remove item from list box.
8. Design an application to find the area and perimeter of a square using subroutine.
9. Design an application to create front end and back to implement ADO connection.
10. Design an application to implement crystal report.
11. Design an application to implement arithmetic operation using subroutine.
12. Design an application to implement Menu Editor.
13. Design an application to move image using timer.
14. Design an application to implement shapes/ images/ pictures.
15. Design an application to implement message box and input box.

Part B
Mini project for connecting a sample database to VB

Teaching Plan

• Object Oriented programming Using C++

• Database Management Systems

• Software Engineering

Back

Academics