SNR SONS COLLEGE (AUTONOMOUS)

DEPARTMENT OF COMPUTER APPLICATIONS (UG)

BCA (Academic Year 2015 – 2016 and onwards)

SCHEME OF EXAMINATION

SEMESTER I

Number
Exam
Sl. No. Course Code Course of CIA CE Total
Hours
Credits
Part - I
15T01/15M01
1 Tamil I / Malayalam I/ Hindi I/ 3 3 25 75 100
15H01/15F01
French I
Part – II
2 15E01 3 3 25 75 100
English for Communication I
Part - III
3 15CA101 Computer Organization & 5 3 25 75 100
Architecture
4 15CA102 C Programming 5 3 25 75 100
5 15CA103 Allied – I : Business Accounting 4 3 25 75 100
Practical - I :
6 15CA104 3 3 40 60 100
PC Software Lab
Practical – II :
7 15CA105 3 3 40 60 100
C Programming Lab
Part - IV
8 15ES01 2 2 50 - 50*
Environmental Studies
Total 28 700
SEMESTER II

Number Exam
Sl. No. Course Code Course CIA CE Total
of Credits Hours
Part I
15T02/15M02
9 Tamil II/ Malayalam II/ Hindi II/ 3 3 25 75 100
15H02/15F02
French II
Part II
10 15E02 3 3 25 75 100
English for Communication II
Part III
11 15CA201 5 3 25 75 100
OOPS with C++
12 Supportive Course I 4 3 25 75 100
Allied – II : Numerical Methods And
13 15CA202 4 3 25 75 100
Statistics
Practical – III:
14 15CA203 3 3 40 60 100
Multimedia Lab
Practical –IV :
15 15CA204 3 3 40 60 100
C++ Lab
Part IV
16 15VE01 2 2 50 - 50*
Value Education
Total 27 700
SEMESTER III

Sl.
Course Number Exam
No. Course CIA CE Total
Code of Credits Hours

Part III
17 15CA301 5 3 25 75 100
Java Programming

18 15CA302 ELECTIVE I 4 3 25 75 100

19 15CA303 Allied – III : Operations Research 4 3 25 75 100

Practical – V:
20 15CA304 3 3 40 60 100
Java Programming Lab
Practical – VI:
21 15CA305 3 3 40 60 100
Web Programming Lab
Skill based Course : 1
22 15CA306 3 3 25 75 100
Web Techonology
Part IV
15BCT01 3 75 -
Basic Tamil I
23 15AT01 Advanced Tamil I 2 3 - 75 75*
Non Major – I ( Personality
15NM01 3 - 75
Development)
Total 24 600

SEMESTER IV

Number
Course Exam
Sl. No. Course of CIA CE Total
Code Hours
Credits
Part III
24 15CA401 5 3 25 75 100
VB. Net
25 Supportive Course II 4 3 25 75 100
26 15CA402 Allied – IV : Marketing Management 4 3 25 75 100
Practical – VII:
27 15CA403 3 3 40 60 100
VB. Net lab
Practical – VIII:
28 15CA404 3 3 40 60 100
Oracle Lab
Skill based Course : 2
29 15CA405 3 3 25 75 100
RDBMS & Oracle
Part IV
15BCT02 3 75 -
Basic Tamil- II
30 15AT02 Advanced Tamil- II 2 3 - 75 75*
15NM02 Non Major – II (General Awareness) 3 - 75
Total 24 600
 SEMESTER V

Course Number Exam

Sl. No. Course CIA CE Total
Code of Credits Hours
Part III
31 15CA501 5 3 25 75 100
Computer Networks

32 15CA502 ELECTIVE – II 4 3 25 75 100

Practical – IX:
33 15CA503 3 3 40 60 100
S/W Testing Lab
Practical – X:
34 15CA504 3 3 40 60 100
PHP Lab
Skill based Course : 3
35 15CA505 3 3 25 75 100
PHP
Total 18 500

SEMESTER VI

Course Number Exam

Sl.No. Course CIA CE Total
Code of Credits Hours
Part III
36 15CA601 5 3 25 75 100
ASP.NET
37 Supportive Course III 4 3 25 75 100
Practical – XI:
38 15CA602 3 3 40 60 100
OS Lab
Practical – XII:
39 15CA603 3 3 40 60 100
ASP.NET Lab
Skill Based Course : 4
40 15CA604 3 3 25 75 100
Operating System
Part V
41 15EA01 1 - 50 - 50*
Extension Activities
Total 19 500

CIA à CONTINUOUS INTERNAL ASSESSMENT Total credits for the Programme = 140
CE à COMPREHENSIVE EXAMINATIONS Total Marks for the Programme =
3600

*NOT INCLUDED FOR CGPA

Dr.Anna Saro Vijendran,

Chairman-Board of Studies,
Department of ComputerApplications(UG),
S N R Sons College (Autonomous),
Coimbatore – 06
 SNR SONS COLLEGE (AUTONOMOUS)
DEPARTMENT OF COMPUTER APPLICATIONS (UG)
BCA (Academic Year 2015– 2016 and onwards)

SUPPORTIVE COURSE

SUPPORTIVE COURSE – I SUPPORTIVE COURSE – II SUPPORTIVE COURSE – III

Semester
II IV VI
Paper
1.
1 Data and file structures Internet & E-Commerce Artificial Intelligence

Management Information
2 System System Software Mobile Communication

3 Microprocessor and Assembly Software Testing Embedded System

Language Programming

ELECTIVES

ELECTIVE – I ELECTIVE – II

Semester
III V
Paper
15CA302 15CA502
1 Software Engineering Introduction to Open Source
Tools
15CA302 15CA502
2 System Analysis and Design Unified Modeling Language

15CA302 15CA502
3 Compiler Design Client / Server Technology
 PART-III

Computer Organization & Architecture

Number of Instruction Hours: 4 Sub. Code: 15CA101

Subject Description:
This subject presents the Architecture and Organization of computers.

Goal:
To enable the students to learn the basic functions, principles and concepts of Computer Architecture.

Objectives:
On successful completion of the course the students should have:
Understood Architecture of Computer
Understood number systems, I/O, Registers and Memory Organization

UNIT I
NUMBER SYSTEMS : Binary, Octal, Decimal and Hexadecimal – Number conversion - Binary
Addition and Subtraction – Binary Multiplication and Division – Use of Complements in Number
Systems – BCD – Codes (binary,Gray,Excess-3,ASCII,EBCDIC) - Error detection & correction.

UNIT II
BOOLEAN ALGEBRA AND GATE NETWORKS:
Basic Gates – Universal gates – Exclusive Gates - Boolean Algebra – Basic Laws and Theorem –
Simplification of Expressions – De_Morgan’s Theorems – Derivation of a Boolean Expression –
Interconnecting Gates - The Karnaugh Map for Simplifying Expressions – Sum of Products and
Product-of-Sums Expressions-Don’t Cares – Design using NAND Gates.

UNIT III
LOGIC DESIGN: Flip-flops: RS flip-flop, JK flip-flop, D flip-flop, T flip-flop, Master-Slave flip-flop
– Shift Register – Counters: Binary Counter – BCD Counters – Ripple counters – Decade counters.

UNIT IV
THE ARITHMETIC-LOGIC UNIT : Binary Half-Adder – Full-Adder – Serial Binary Adder -
Parallel Binary Adder – Full-Adder Designs – Binary-Coded-Decimal Adder – Encoder – Decoder-
Multiplexers - Demultiplexers.
INPUT-OUTPUT DEVICES: Punched Cards – Card Readers - Punched Tape – Tape Readers ––
MICR– OCR – Printers – Cathode-Ray-Tube– Magnetic-Tape – Keyboards.

UNIT V
THE MEMORY ORGANIZATION : Random-Access Memories – Dimensions of Memory Access –
Connecting Memory Chips to a Computer Bus – Random-Access Semiconductor Memories – Static
Random-Access Memories – Dynamic Random-Access Memories – Read-Only Memories – Magnetic
Disk Memory – Floppy Disk – Magnetic Tape – Magnetic Bubble Memories .

TEXT BOOKS

1. DIGITAL COMPUTER FUNDAMENTALS – 6TH EDITION- THOMAS C BARTEE -

TATA MCGRAW-HILL EDITION.
UNIT I – Chapter 2 UNIT II – Chapter 3,
UNIT III – Chapter 4 UNIT IV- Chapter 5,7 UNIT V – Chapter 6

REFERENCE BOOKS

1. COMPUTER ARCHITECTURE AND ORGANIZATION – THIRD EDITION – JOHN . P.

HAYES, “MCGRAW-HILL PUBLICATIONS.
2. COMPUTER SYSTEM ARCHITECTURE - THIRD EDITION – M . MORRIS MANO –
PEARSON PRENTICE HALL, PEARSON EDUCATION.
 C PROGRAMMING

Number of Instruction Hours: 4 Sub. Code: 15CA102

Subject Description:
This course presents the Programming techniques in C, explains data types, arrays, pointers, files.
Goal:
To enable the students to learn the basic functions, principals and concepts of programming in C
fundamentals.
Objectives:
On successful completion of the course the students should have:
 Understood the Programming in C language

UNIT I
Getting started with C – Constants and Variables – Data types and sizes – Storage classes: Automatic,
Extern, Register and Static – Operators – Expressions – C Instructions – Console Input / Output
functions.

UNIT II
Control Statements: While, Do-While, Foe Statements, Nested For, If- Else, Switch, break, Continue
and goto Statements. – Case control structure – Loop control structure – Arrays – Strings: Defining and
Operations on Strings.

UNIT III
Functions – Passing values between functions – Function declaration and prototypes – Call by value
and Call by reference – Recursion – Structures and Unions.

UNIT IV
Pointers – Pointers and arrays – Pointers and functions – Pointers and strings – Pointers and structures.

UNIT V
File Management: Creation, Copy, delete, Update, Text file – Command line arguments.

TEXT BOOKS
1. “Let us C”, Yashavant Kanetkar, Third edition, BPB Publications.
(UNIT I : Chapters 1, 6, 11) (UNIT II: Chapters 2, 3, 4, 8, 9)
(UNIT III : Chapters 5, 18) (UNIT V : Chapters 7, 17, 20 )
2. “Programming in ANSI C”, E.Balagurusamy, Second edition, 1992, Tata McGraw Hill
Publishing Company.(UNIT III : Chapter 10) (UNIT IV : Chapters 11, 13)
(UNIT V: Chapters 12, 13)
REFERENCE BOOKS
1. “Programming with ANSI and TURBO C”, Ashok N. Kamthane, Pearson Education, Asia, 2003.
2. “C How to program”, Deitel & Deitel, Third Edition, Pearson Education, Asia.
 ALLIED - I
BUSINESS ACCOUNTING

Number of Instruction Hours: 4 Sub. Code: 15CA103

Subject Description: This subject deals the concepts of Accounting in Business.

Goal: To enable the students to learn principles and concepts of Accountancy.

Objective: On successful completion of this course, the student should have understood
 Concepts and conventions of Accounting.
Basic Accounting framework

UNIT - I
Introduction – Accounting principles – Branches of accounts – Accounting rules – Journalizing ledger
– Subsidiary book including cash book – Bank reconciliation statement – Rectification of Errors – Trial
Balance.

UNIT - II
Preparation of final Accounts with sample adjustments.

UNIT - III
Cost accounts – Meaning – Objectives – Elements of cost – cost sheet preparation – stores ledger –
LIFO,FIFO, Average stock – Weighted average stock.

UNIT - IV
Management Accounts – Meaning – Merits and demerits – Preparation of fund flow statement – cash
flow statement

UNIT - V
Budget – Meaning – advantages – Preparation of various budgets.

TEXT BOOK
1. ACCOUNTING FOR MANAGEMENT –N.P.SRNIVASAN & M..SAKTHIVELMURUGAN
UNIT – I (CHAPTER 2,3,4) UNIT – II (CHAPTER 5)
UNIT – III (CHAPTER 13,14) UNIT – IV (CHAPTER 1,9,10)
UNIT – V (CHAPTER 12)

REFERENCE BOOKS
1. DOUBLE ENTRY BOOK KEEPING – T.S.GREWAL
2. MANAGEMENT ACCOUNTING - SHARMA&GUPTA
 PRACTICAL - I

PC SOFTWARE LAB
Number of Instruction Hours: 3 Sub. Code: 15CA104

MS – WORD
1. Using MS – WORD perform the following.
a) Change the font size to 20
b) Change the font type Garamond
c) Align the text to left, right, justify and center
d) Underline the text.
e) Table manipulation.
2. Create a simple news letter.
3. Type your own resume.
4. Design a greeting card & Design a cover page of a project.
5. Prepare an interview call letter for the post of programmer for a software company for minimum
of 5 persons using mail merge.
MS – POWER POINT

6.Prepare an organization for a college environment in PowerPoint.

7. Perform frame movement by inserting clip arts to illustrate running of a car automatically.
MS – EXCEL
8.Create a worksheet with four columns and enter ten records and find the sum of all columns.
9.Built a worksheet to perform correlation and regression coefficients using formulae and
check the answer with built-in.
10. Create a worksheet importing data from database and calculate sum of all the columns.
11. Illustrate a pie chart for a sample data and give Legends.

MS- ACCESS

12.Create a form to update/modify the result processing table.

13. Design a report to print the result sheet and marks card for the result.
14 Perform sorting on name, place and pin code of students database and list them in the sorted
order.
15. Create mailing labels for employee database.
 PRACTICAL - II

C PROGRAMMING LAB

Number of Instruction Hours: 3 Sub. Code: 15CA105

1. Write a C program to generate the first n terms of the sequence.

2. Write a C program to find the sum of individual digits of a positive integer.
3. Write C programs that use both recursive and non-recursive functions to find the factorial of a
given integer.
4. Write a C program, which takes two integer operands and one operator form the user, performs
the operation and then prints the result. (Consider the operators +,-,*, /, % and use Switch
Statement)
5. Write a C program to find both the largest and smallest number in a list of integers.
6. Write a C program to find the factorial of a given number.
7. Write a C program to count the lines, words and characters in a given text.
8. Linear search c program
9. C program to add two matrix
10. Write a C program to multiply or find multiplication of two matrices / write a C program to
multiply two matrices
11. Write a C program to convert UPPERCASE alphabets to LOWERCASE alphabets in a given
string and vice-versa.
12. Write a C program to list the names of students who have scored more than 60% of total marks
in three subjects using structure variables.
13. Check for palindromes in a sentence using pointers
14. Write a C program to read and write to a file.
15. Write a C program to Create and count number of characters in a file.
 PART IV

SEMESTER I

ENVIRONMENTAL STUDIES

Number of Instruction Hours: 2 Sub. Code : 15ES01

UNIT I The multidisciplinary nature of environmental studies

UNIT II Ecosystems

UNIT III Biodiversity and its conversion

UNIT IV Environmental pollution

UNIT V Social issues and the environment

Text Book:

Environmental Studies for undergraduate courses – Bharathiar University.

Reference Book:
Environmental Education – V.K.Nantha
A Textbook of Environmental Studies – Thangamani.A and T.Shymama.
 PART III

OOPS WITH C++

Number of Instruction Hours: 4 Sub. Code: 15CA201

Subject Description: This subject deals with Object–oriented programming concepts like
Abstraction, Encapsulation, Inheritance and Polymorphism.

Goal: Knowledge on Object–oriented concept and programming with C++.

Objective: To inculcate knowledge on Object-oriented programming concepts using C++.

UNIT – I
Principles of Object-Oriented Programming : Software evolution – Procedure-oriented programming –
Object-oriented programming paradigm – Basic concepts of OOP – Benefits of OOP – OOP languages
– Application of OOP.
Beginning with C++ : What is C++ - Application of C++ - Structure of C++ program – Tokens,
Expressions and Control Structures : Tokens – keywords – Identifiers – Data types – Declaration of
variables – dynamic initialization of variables – Reference variables – Operators – Scope resolution
operator – Operator Precedence – Control Structures.

UNIT – II
Functions in C++ : The main() function - Function prototype – Call by Reference – Inline functions –
Default arguments – Function overloading
Classes and Objects : Specifying Class – Defining member functions – Private member functions –
Array with a class – Static data members – Static member functions - Array of objects – Objects as
function arguments – Returning objects – Const member functions – Friend functions.

UNIT – III
Constructors and Destructors : Constructors – Types of constructors – Multiple constructors in a class –
Dynamic constructors – Destructors.
Operator Overloading and Type Conversion : Defining operator overloading function – Overloading
unary operators - Overloading binary operators - Overloading operators with friend functions – Rules
for overloading operators.

UNIT – IV
Inheritance : Defining derived classes – Types of inheritance – Virtual base classes – Abstract classes –
Nesting of classes.
Pointers, Virtual functions and polymorphism : Pointers to objects – this pointer – pointers to derived
classes – virtual functions – pure virtual functions
UNIT – V

Managing Console I/O Operators : C++ streams – Stream classes – Unformatted I/O operations –
Formatted console I/O operations.
Working with Files : Classes for file stream operations – Opening and Closing a file – Detecting end-
of-file – File open modes – File pointers and their manipulators

TEXT BOOKS

1. OBJECT-ORIENTED PROGRAMMING WITH C++ - E.BALAGURUSAMY, TATA MCGRAW

HILL PUBLISHING COMPANY LTD, 1998.
UNIT – I (CHAPTER 1,2,3) UNIT – II (CHAPTER 4,5)
UNIT – III (CHAPTER 6,7) UNIT – IV (CHAPTER 8,9)
UNIT – V (CHAPTER 10,12)

REFERENCE BOOKS
1. ASHOK N. KAMATHENE , “OBJECT ORIENTED PROGRAMMING WITH ANSI AND
TURBO C++ “, PEARSON EDUCATION.
 NUMERICAL METHODS AND STATISTICS
Number of Instruction Hours: 4 Sub. Code: 15CA202

Subject Description: This subject deals various numerical methods and statistical applications
for computer science.

Goal: To learn about the computer based numerical and statistical methods.

Objective: On successful completion of this subject the students should have:

- Understanding various concepts of numerical analysis.
- Learning various applications statistical methods for Computer Science

UNIT - I
Polynomial equation : Initial approximation – Bisection , Secant, Newton – Raphson-Birgevieta and
Bairstou and Grafee’s root squaring methods.

UNIT - II
System of linear algebraic equations : Gauss elimination, Gauss Jordan, Gauss Jacobi and Gauss
Siedel methods. Eigen value Problems using power method.

UNIT - III
Interpolation : Newton, Lagrange’s methods.
Numerical Differentiation : Newton’s forward and backward differentiation
Numerical Integration : Trapezoidal rule- Simpson rule ( 1/3rd ) – Romberg’s method.

UNIT - IV
Statistics
Measures of central tendency : simple averages mean, median and mode.
Measures of dispersion : Range, mean deviation and standard deviation.
Method of Least squares for fitting a straight line.

UNIT - V
Correlation Analysis : Meaning – Types – Karl Pearson’s Co-efficient of Correlation – Rank
correlation .
Regression Analysis : Meaning – Regression equations- Properties of Regression
Co-efficient – Correlation and Regression a comparison.

TEXT BOOK
1. NUMERICAL METHODS FOR SCIENTIFIC AND ENGG. COMPUTATION,
- M.K.JAIN, S.R.K. IYENGAR, R.K.JAIN (I , II, III UNITS)
2 STATISTICS - R.S.N.PILLAI AND BHAGAVATHY. (IV , V UNITS)
REFERENCE BOOK
1. NUMERICAL METHODS IN SCIENCE AND ENGINEERING
- DR.M.K.VENKATARAMAN
2. STATISTICAL METHODS – S.P.GUPTA
 PRACTICAL – III
MULTIMEDIA LAB
(FLASH, PHOTOSHOP)

Number of Instruction Hours: 3 Sub. Code: 15CA203

Perform Any Ten :

FLASH
1. Create an animation to represent the growing moon.
2. Create an animation to indicate a ball bouncing on steps.
3. To simulate a movement of a cloud.
4. Draw the Fan Blades and to give proper animation.
5. Display the background given filename through your name.
6. Create an animation with following features:
Letters should appear one by one.
The fill colour of the text should change to a different colour after the display of the fill word.
7. Simulate a ball hitting another ball.
8. To change a circle into a square

PHOTOSHOP

9. Extract an image from one image and paste it into another organization.
10. Adjust the brightness and contrast of a picture to give elegant look.
11. Position the picture on a plain background and include rotation and scaling.
12. Organizing images (Cut the objects from three files and organize in a single file and apply filter
effects).
13.Using masking concept display the background file name.
14. To convert a part of picture to black and white.
15. Type a word and apply the effects shadows emboss.
 PRACTICAL - IV

C++ Lab

Number of Instruction Hours: 3 Sub. Code:15CA204

Write C++ Programs to illustrate the concept of the following:

1. Arrays
2. Inline Functions
3. Objects and Classes
4. Console I/O operations
5. Multilevel Inheritance
6. Multiple Inheritance
7. Virtual Functions
8. Overloading unary operator
9. Overloading binary operators
10. Overloading operators using friend function
11. Constructors and Destructors
12. Create a Stack and perform operation like Insertion, Deletion and View its elements.
13. Create a Queue and perform operation like Insertion, Deletion and View its elements.
14. Sort out the given numbers using Merge sort techniques.
15. Sort out the given numbers using Quick sort techniques.
 PART –IV
SEMESTER-II
VALUE EDUCATION – HUMAN RIGHTS
Number of Instruction Hours: 2/Week Sub. Code: 15VE01
UNIT –I : Concept of Human Values, Value Education Towards Personal Development
Aim of education and value education : Evolution of value oriented education; Concept of Human Values; Types
of values; Components of value education.
Personal Development :
Self analysis and introspection; sensitization towards gender equality, physically challenged, intellectually
challenged, Respect to – age, experience, maturity, family members, neighbours, co-workers.
Character Formation Towards Positive Personality:
Truthfulness, Construtivity, Sacrifice, Sincerity, Self Control, Altruism, Tolerance, Scientific Vision.
UNIT- II: Value Education Towards National and Global Development
National and International Values:
Constitutional or national values –Democracy socialism, secularism, equality, justice, liberty, freedom and
fraternity.
Social values- Pity and probity,self control, universal brotherhood.
Professional Values – Knowledge thirst, sincerity in profession, regularity , punctuality and faith.
Religious Values – Tolerance, wistom, character.
Aesthetic Values – Love and appreciation of literature and fine arts and respect for the same.
National Integration and international understanding.

UNIT – III: Impact of Global Development on ethics and values

Conflict of cross – cultural influences, mass media , cross- border education, materialistic values, professional
challenges and compromise.
Modern challenges of Adolescent Emotions and behavior; Sex and spirituality;
Comparison and competition; positive and negative thoughts.
Adolescent Emotions, arrogance, anger, sexual instability, selfishness, defiance.
UNIT – IV : Theraupatic Measures
Control of the mind through
a. Simplified physical exercise
b. Meditation – Objectives, Types, effect o
c. Asanas.
d. Activites:
(i) Moralisation of desires
(ii) Neutralization of anger
(iii) Eradication of worries
(iv) Benefits of blessings
UNIT-V: Human Rights
1. Concept of Human Rights – Indian and International perspectives
a. Evolution of Human Rights
b. Definition under Indian and Internatonal documents
1. Broad classification of human rights and Relevant Constitutional Provisions.
a. Right to life, liberty and dignity
b. Right to equality
c. Right against Exploitation
d. Cultural and Educational rights
e. Economic rights
f. Political rights
g. Social rights
2. Human Rights of Women and Children
a. Social Practice and Constitutional Safeguards
i) Female Foeticide and Infanticide
ii) Physical assault and harassment
iii) Domestic violence
iv) Conditions of Working women
3. Institution for Implementation
a. Human Rights Commission
b. Judiciary
4. Violations and Redressel
a. Violation by State
b. Violation by Individuals
c. Nuclear Weapons and terrorism
d. Safeguards

Text Book:
Learning Material from Bharathiar University

Reference Books:
a. Value Oriented Education – D.Dayakara Reddy, DPH, New Delhi-02
b. Value Education - De.N.Venkataiah, APH, New Delhi-02
c. Free Yourself from Tension with yoga- KR.Ganesh Babu, AUM Yoga Theraphy Research Institute,
Coimbatore.

.
 SUPPORTIVE COURSE-I

DATA AND FILE STRUCTURES

Number of Instruction Hours: 4

Subject Description: This subject deals the concepts ,Techniques and applications of data & file
structures.

Goal: To learn about the concepts of linear data structures, non linear data structures, searching and
sorting techniques.

Objective: On successful completion of this course, the student should have understood
Concepts on data structures dealing with stacks, queues, list, searching & sorting algorithms

UNIT-I
Introduction: Definition, Structure and properties of algorithms, Development of an algorithm, Data
Structures and algorithms ,Data Structure-Definition and Classification. Arrays: Introduction, Array
operations, Number of elements in an array, Representations of arrays in memory, applications.
UNIT-II
Stacks: Introduction ,Stack Operations, Applications.
Queues: Circular Queues, Other types of queues, Applications

UNIT-III
Linked Lists: Introduction, Singly linked lists, Circular Linked lists, Doubly linked lists, Applications.

UNIT- IV
Trees: Introduction, Trees-basic terminologies, Representation of Trees. Binary Trees: Basic
terminologies and types, representation of Binary Trees, Binary tree Traversals, Threaded Binary
Trees, Applications. Graphs: Introduction, Definition and basic terminologies

UNIT- V
File organizations; Introduction, Files, Keys, Basic file operations. Sequential file Organisations,
Indexed sequential file Organizations, Direct file organizations

Searching :Linear search, Binary search. Sorting: Merge sort and Quick sort

TEXT BOOK:

1.” Data Structures and Algorithms-Concepts , Techniques and Applications”, GAV PAI TATA
MRAW HILL,2008.
UNIT-I(CHAPTERS 1,3) UNIT-II(CHAPTERS 4,5)
UNIT-III(CHAPTER 6) UNIT-IV(CHAPTERS 8,9)
UNIT-V(CHAPTERS 14,15 & 16)
REFERENCE BOOKS

1.ELLIS HOROWITZ & SARTAJ SHANI “DATA AND FILE STRUCTURES”,GALGOTIA

PUBLICATION. UNIT-IV(CHAPTERS 1,2,3 & 4) UNIT-V(CHAPTER 7)

2.JEAN PAUL TREMBLAY, PAUL G. SORENSON, “ AN INTRODUCTION TO DATA

STRUCTURES WITH APPLICATIONS”, SECOND EDITION, TATA McGRAW HILL.
 SUPPORTIVE COURSE-I
MANAGEMENT INFORMATION SYSTEM

Number of Instruction Hours: 4

Subject Description: This subject deals with various management approaches of Information
Systems.

Goal: Knowledge on how to manage Information like an experienced manager.

Objective: To inculcate knowledge on managing different information systems.

UNIT - I
Management Information Systems - Role and Importance of Management - Process of Management -
Organization Structure and Theory - Strategic Management of Business.

UNIT - II
Basic of Management information Systems : Decision Making – Information –Systems.

UNIT - III
Systems Analysis and Design - Development of MIS - Choice of Information Technology.

UNIT - IV
Applications in Manufacturing Sector - Applications in Service Sector -Decision Support Systems -
Enterprise Management Systems.

UNIT - V
Technology of Information Systems - Database management Systems - Object Oriented Technology
(OOT): Conceptual Presentation - Client Server
Architecture - Networks - Business Process Re-engineering (BPR).

TEXT BOOK

1. W.S.JAWADEKAR - MANAGEMENT INFORMATION SYSTEMS – Tata

McGraw hill , Publishing Company Limited - 1998.
UNIT - I : (Chapter 1,2,3,4,5) UNIT - II : (Chapter 6,7,8)
UNIT - III : (Chapter 9,10,11) UNIT - IV : (Chapter 12,13,14,15)
UNIT - V : (Chapter 16,17,18,19,20,21)

REFERENCE BOOK
1. JAMES O’BRIEN, “MANAGEMENT INFORMATION SYSTEM”, SIXTH EDITION, TATA
McGRAW HILL.
 SUPPORTIVE COURSE-I
MICROPROCESSOR AND ASSEMBLY
LANGUAGE PROGRAMMING

Number of Instruction Hours: 4

.
Subject Description: This subject deals fundamentals of microprocessor, instruction set of 8085,
memory and I/O interfacing, peripheral and applications.

Goal: To gain Knowledge on 8085, 8255A, 8259A microprocessor .

Objective: To inculcate assembly language programming knowledge on 8085 and to understand the
various application areas of microprocessor.

UNIT - I
Intel 8085 Microprocessor: Introduction to microprocessor - Intel 8085 Pin diagram and functions-
8085 architecture-Generating control signals- Addressing modes

UNIT - II
Instruction set of 8085:Data transfer operations-Arithmetic operations-Logic operations-Branch
operations-Stack and Subroutine

UNIT - III
Memory and I/O device interfacing: Memory interfacing-Basic concepts in memory interfacing-
Address Decoding Interfacing I/O devices- I/O mapped I/O-Memory mapped I/O-Interfacing Input
devices-Interfacing output devices.

UNIT - IV
Interfacing peripherals: The 8255A Programmable Peripheral Interface- The 8254 Programmable
Interval timer-The 8259A Programmable Interrupt controller- Direct memory Access(DMA) and the
8237 DMA Controller.-8279 keyboard/display interfacing.

UNIT - V
Microprocessor Example Applications: Delay subroutine-Delay using one register-register pair-
Temperature measurement and control-Water level indicator-Microprocessor based traffic light control
system.
TEXT BOOKS:
1. MICROPROCESSOR ARCHITECTURE,PROGRAMMING, AND APPLICATIONS WITH THE
8085. RAMESH S.GAONKAR, FOURTH EDITION-2000, PENRAM INTERNATIONAL
PUBLISHING,
ISBN 81-90828-7-6.
UNIT – I (CHAPTER 3) UNIT –II (CHAPTER 6,9)
UNIT – III (CHAPTER 3,4) UNIT – IV (CHAPTER 14,15)
2. FUNDAMENTALS OF MICROPROCESSORS AND MICROCOMPUTERS - B.RAM,
FOURTH EDITION, DHANPAT RAI PUBLICATIONS.
UNIT – V (CHAPTER 9)

REFERENCE BOOKS
1. DOUGLAS V.HALL “ MICRO PROCESSOR AND INTERFACING PROGRAMMING
AND HARD WARE” TATA McGRAW HILL .

2. ADITYA P. MATHUR , THIRD EDITION “INTRODUCTION OF MICROPROCESSOR”

TATA McGRAW HILL.
BCA 2015-2018

SEMESTER - III
PART – III
JAVA PROGRAMMING

Number of Instruction Hours: 4 Course Code: 15CA301

Subject Description: This subject deals with Java Programming concepts like Classes, Packages
Multithreading ,Managing Exceptions, Applet Programming
Goal: Knowledge on Java Programming concepts.
Objective: To inculcate knowledge on Java Programming.

UNIT-I
Introduction to JAVA: JAVA Evolution: Java History, Java Features, How Java Differs from C and
C++, Overview of JAVA Language: Introduction, Simple Java Program, Java Program structure, Java
Tokens, Java Statements, Java Virtual Machine, Command Line Arguments.Constants, Variables,
and Data Types: Introduction, Constants, Variables, Data Types, Declaration of Variables, Giving
Values to Variables, Scope of variables, Symbolic Constants, Type Casting, Getting Values of
Variables, Standard Default Values.

UNIT-II
Operators and Expressions: Introduction, Arithmetic Expressions, Evaluation of Expressions,
Precedence of Arithmetic Operators, Type conversion and Associativity, Mathematical Functions.
Decision Making and Branching: Introduction, Decision Making with if Statement, Simple if
Statement, The if else Statement, Nesting of if else Statements, The else if Ladder, The Switch
Statement, The ?: Operator. Decision Making and Looping: Introduction, The while Statement, The
do Statement, The for Statement, Jumps in Loops, Labeled Loops.
Classes, Objects and Methods: Introduction, Defining a Class, Adding Variables, Adding Methods,
Creating Objects, Accessing Class Members.

UNIT-III
Classes, Arrays, Strings and Vectors: Constructors, Methods Overloading, Static Members, Nesting
of Methods, Inheritance: Extending a Class, Overriding Methods, Final Variables and Methods,
Finalizer methods, Abstract Methods and Classes, Visibility Control. Arrays, Strings and Vectors:
Arrays, One – dimensional Arrays, Creating an Array, Two – dimensional Arrays, Strings, Vectors,
Wrapper Classes
Interfaces: Introduction, Defining Interfaces, Extending Interfaces, Implementing Interfaces,
Accessing Interface Variables.

UNIT-IV
Packages, and Multithreaded Programming: Packages: Putting Classes together: Introduction,
Java API Packages, Using System Packages, Naming Conventions, Creating Packages, Accessing a
Package, Using a Package, Adding a Class to a Package, Hiding Classes. Multithreaded
Programming: Introduction, Creating Threads, Extending the Thread Class, Stopping and Blocking a
thread, Life Cycle of a thread, Using Thread Methods, Thread Exceptions, Thread Priority,
Synchronization, Implementing the ‘Runnable’ Interface.
BCA 2015-2018

UNIT-V
Managing Exceptions, Applet Programming:
Introduction, Types of Errors, Exceptions, Syntax of Exception Handling Code, Multiple Catch
Statements, Using Finally Statement, Throwing Our Own Exceptions, Using Exceptions for
Debugging.
Applet Programming: Introduction, How Applets Differ from Applications, Preparing to Write
Applets, Building Applet Code, Applet Life Cycle, Creating an Executable applet, Designing a Web
Page, Applet Tag, Adding Applet to HTML File, running the Applet, More about Applet Tag, Passing
Parameters to Applets.

TEXT BOOK:

1. E. BALAGURUSWAMY, PROGRAMMING WITH JAVA, A PRIMER, 4th EDITION., TMH

(2013), (CHAPTER 2 – 14)

REFERENCE BOOKS
1. “JAVA HAND BOOK” BY PATRICK NAUGHTON, TATA MCGRAW-HILL,2008.
BCA 2015-2018
BCA 2015-2018

ALLIED - III

OPERATIONS RESEARCH

Number of Instruction Hours: 4 Course Code: 15CA303

Subject Description:
This subject deals with various optimization techniques for linear programming ,
Transportation and assignment problems , Game theory ,PERT and CPM.

Goal:
To learn about the managerial concepts like decision making , optimization etc.

Objective:
On successful completion of this subject the students should have :
 Understanding various mathematical applications in industries.
 Decision making for real time environment

UNIT I LINEAR PROGRAMMING

Introduction – Mathematical Formulation of the Problem – Graphical Solution –Standard forms of the
LPP – Simplex Method of ≤ constraints only.
Chapter – 2 &3 (2.1 -2.3) (3.1, 3.2, 3.4, 3.5, 3.6 )

UNIT II TRANSPORATION AND ASSIGNMENT PROBLEM

The Transportation Problem : Mathematical Formulation – Initial Basic Feasible Solution [North –
West Corner Rule method, Least Cost method, VAM ] - Unbalanced Transportation problem –
Optimal solution [ MODI Method ] (Non-degeneracy problems only). Assignment Problem :
Mathematical Formulation – Hungarian Assignment method – Unbalanced Assignment problem .
Chapter – 10 &11 (10.1 -10.3, 10.8 – 10.13) (11.1- 11.4 )

UNIT III GAME THEORY AND INVENTORY CONTROL

Game Theory : Concept of Pure and Mixed Strategies – Solving 2x2 matrix with and without saddle
point- Graphical method of solving 2xm and nx2 games – Dominance property. Inventory Control :
Introduction – Various costs involved in the Inventory - EOQ models with and without shortages.
Chapter – 17 &19 (17.1 - 17. 7) (19.1 – 19.11 )

UNIT IV REPLACEMENT PROBLEMS AND WAITING LINE THEORY

Elementary replacement models – Individual and Group Replacement.
Definition of waiting line models – Problems from single server infinite population models .
Chapter –18 &21 (18.1 - 18.3) (21.1- 21.4, 21.7 – 21.9 model I only )
BCA 2015-2018

UNIT V CPM AND PERT

Network representation – forward and backward pass computation - Critical path - Total, free and
independent floats

PERT Calculations –Time scale analysis – Critical path –Probability factor.

Chapter – 25 (25.1 -25.8) (except 25.5)

* No Derivations. Only applications

TEXT BOOK

1. KANTISWARUP, P.K.GUPTA AND MAN MOHAN , “OPERATIONS RESEARCH”, TATA

MCGRAW HILL, 15TH EDITION

REFERENCE BOOKS
1. P.K. GUPTA, D.S. HIRA , “INTRODUCTION TO OPERATIONS RESEARCH”, S. CHAND
& COMPANY
LTD. 2012.
2. SUNDERESAN, GANESAN AND GANAPATHY SUBRAMANIAN “RESOURCE
MANAGEMENT
TECHNIQUES”, AR PUBLISHERS, 9TH EDITION
3. P.K. GUPTA, D.S. HIRA, “PROBLEMS IN OPERATIONS RESEARCH”, S. CHAND
PUBLISHING 1991.
BCA 2015-2018

SEMESTER - III

PART – IV

SEMESTER-III

PERSONALITY DEVELOPMENT

EFFECTIVE FORM 2008-09 AND ONWARDS (NON-MAJOR-I)

Number of Instruction Hours: 2 Course Code: 15NM01

Subject Description: This subject deals with personality improvement and development
communication skills improvement.right dressing for specific occasions

Goal: To improve confidence and personality of the students.

Objectives
1.To understand the concept, process and importance of personality.
2.To gain a knowledge on the dynamics and techniques of personality DEVELOPPMENT.
3.To have an insight into self development and environment and environment factors affecting
personality development.
4.To help the students to acquaint with the application of communication skills in the world of
Business.
5.To know the importance of right dressing for the right occasion.
6.To get an idea about and have a mock drill on interviews and other selection techniques.

UNIT-I
PERSONALITY-Definition –Social and Self concepts of personality-can personality be
developed?-Traits and patterns of personality –Social classifications of personality. Factors affecting
personality-Environment factors-Physical factors-Intellectual factors-Emotional factors-Values-Group
skills. Dynamics of personality formation –prenatal Stage-Nursery stage-Adolescent stage-Adult stage-
Old age

UNIT-II
SUCCESSFUL PERSONALITY-Meaning –Acquisition and Qualities of a successful
personality-Barriers to successful personality-Removing barriers to personality development .Scope,
Techniques and Principles of personality development-Personality development Strategy.

UNIT-III
SELF DEVELOPMENT-Approach-Aims and Objectives –Self. Appraisal-Analysis of social
environment-Selection ,Formulation and Execution of a plan of plan for self development.

COMMUNICATION-Importance –objectives –Methods-Principles and Application of

communication of personality development.
BCA 2015-2018

UNIT-IV

INTRICACIES OF DRESSING UP-Purpose and factors to consider while dressing up-Forms

and codes of dress-Approach to dressing up for personality projection.

SOCIAL ETIQUETTES-Participation in social event-Interpersonal etiquettes-Meal service

and Eating manners-Social graces and customs

UNIT –V

Interviews – Classification – Self projection in a selection board for Interview, Group

discussion, Group task, Telecommunication , Video conferences and Public addresses.

TEXT BOOKS:

1.THE DYNAMICS OF PERSONALITY DEVELOPMENT AND PROJECTION BY J.R.BHATTI –

PEARSON EDUCATION 2009

REFERENCE BOOKS:

1. PERSONALITY DEVELOPMENT AND CAREER MANAGEMENT – A PRAGMATIC

PROSPECTIVE BY R.M .OMKAR – SULTAN CHAND 2008.
2. DEVELOPING SOFT SKILLS BY ROBERT.M.SHERFIELD, RHONDA.J.MONTGOMERY
AND PATRICIA.G.MOODY – PEARSON EDUCATION 2009.
3. HOW TO SUCCEED IN GROUP DISCUSSION AND PERSONAL INTERVIEWS BY
DR.S.K.MANDAL – JAICO PUBLISHING HOUSE 2005
4. PERSONALITY DEVELOPMENT BY DR.T.BHARATHI – NEELKAMAL PUBLICATIONS
PVT LTD 2008.
BCA 2015-2018

PRACTICAL – VI

WEB PROGRAMMING LAB

Number of Instruction Hours: 3 Course Code: 15CA305

1. Design a timetable and display it in tabular format.

2. Create a static HTML web page to display the college details.
3. HTML Program to implement ROWSPAN COLSPAN concepts.
4. Create HTML program to implement FRAMESET.
5. Create a HTML program to implement the image and its properties and image map concept
6. Create a HTML program to implement Order List and Unordered List Concepts.
7. Create a simple style sheet and link that style sheet in HTML form.
8. Write a program to implement Background and Border styles in css.
9. Write a Java script program to find the Grade from the Students Mark details.
10. Write a Java script program to validate username and password.
11. Create a Registration Form for e-mail information using HTML.
12. Write a program to implement the concept of Math Object.
BCA 2015-2018

SKILL BASED COURSE - 1

WEB TECHNOLOGY

Number of Instruction Hours: 4 Course Code: 15CA306

Subject Description: This subject deals TCP/IP, FTP, WWW and Web technologies like ASP,
JVM, DCOM, XML and WAP.

Goal: Knowledge on various Web technologies.

Objective: To inculcate knowledge web technological concepts and functioning internet

UNIT - I
Introduction to XHTML: Introduction – Editing XHTML-First XHTML Example-W3C XHTML
Validation Service-Headers-Linking-Images-Special Characters and More Line Breaks-Unordered
List-Nested and Ordered Lists
XHTML Tables-Tables and Formatting-Forms-Complex Forms-Internal Linking-Creating & Using
Image Maps-Meta Elements-Frameset-Nested Frameset

UNIT-II
Cascading Style Sheets:- Inline Styles-Embedded Styles Sheets-Conflicting Styles Sheets-W3C CSS
Validation Service-Positioning Element-Backgrounds-Element Dimension-Text Flow and Box Model-
User Style Sheets

UNIT-III
Introduction–User Input & prompt Dialogs-Memory Concepts-Arithmetic-Relational Operators-
Logical Operators-Control Structures-If, Else, While, Do-While, For, Break, Continue-Programmer-
Defined Functions-Scope rules-Global Function-Recursion-Arrays-Passing Arrays to Function-
Multidimensional Arrays.

UNIT- IV
JavaScript-Object-Math- Object-String- Object-Date- Object.Boolean and Number- Objects.Document
Object.Window- Object-Using Cookies

UNIT – V
DHTML Object Model and Collections: Object Referencing-Collections all and Children-Dynamic
Styles-Dynamic Positioning-Frames Collection-Navigator Object
DHTML Event Model:-Event Onclick-Onload-Onerror-Onmousemove-Onmouseout-Onfocus-Onblur-
Onsubmit-Onreset-Event Bubbling-DHTML Events
BCA 2015-2018

TEXT BOOK
1. INTERNET & WORLD WIDE WEB – HOW TO PROGRAM – 3RD EDITION – DEITEL &
DEITEL, GOLDBERG – PEARSON EDUCATION,2004.
UNIT - I CHAPTER 4, 5 UNIT – II CHAPTER 6
UNIT – III CHAPTER 7,8,9,10,12 UNIT – IV CHAPTER 12
UNIT – V CHAPTER 13,14

REFERENCE BOOKS
1. HTML COMPLETE REFERENCE , “THOMAS POWELL”, TATA-MCGRAW HILL PUB.,2004
2. JAVA SCRIPT COMPLETE REFERENCE . “THOMAS POWELL” & FRITZ SCHNEIDER,
TATA-MCGRAW HILL PUB.,2004
BCA 2015-2018

ELECTIVE -I
COMPILER DESIGN
Number of Instruction Hours: 5 Course Code: 15CA302

Subject Description: This subject deals with Grammer, Lexical and Syntax analysis, Code generation
and Optimization.
Goal: To gain Knowledge on different phases of compiler design.
Objective: To make the student to understand the concepts of Compilers and their Designing.

UNIT-I
Complier: Introduction-complier-analysis of source program-types of grammar-context free
grammar-writing a grammar-phases of a complier-cousins of complier- grouping of phases-complier
construction tools.
Lexical analysis: role of a lexical analyzer – input buffering – specification of tokens – recognition of
tokens – finite automata.

UNIT - II
Syntax analysis: role of the parser – top down parsing – bottom up parsing – operator precedence
parsing – SLR parser.

UNIT – III
Syntax directed translation: syntax directed definition – construction of syntax trees.
Type checking: Type systems – specification of a simple type checker – type conversions – symbol
table organization.

UNIT - IV
Source language issues – storage organization – storage allocation strategies – parameter passing.
Intermediate code generation: intermediate languages – declarations – assignment statement – case
statements.

UNIT - V
Code generation: issues in the design of a code generator – target machine – run time storage
management – basic blocks & flow graphs – simple code generator.
Code optimization: the principal sources of optimization – optimization of basic blocks – loops in flow
graph.
TEXT BOOK:
1. COMPILERS PRINCIPLES, TECHNIQUES AND TOOLS - ALFRED V. AHO, RAVI SETHI,
JEFFREY D. ULLMAN, PUBLISHED BY PEARSON EDUCATION PVT.LTD., INDIAN BRANCH
482 F.I.E PATPARGANI, DELHI 120 092, INDIA.
UNIT – I (CHAPTER 1,3) UNIT – II (CHAPTER 4)
UNIT – III (CHAPTER 5,6) UNIT – IV (CHAPTER 7,8)
UNIT – V (CHAPTER 9,10)
REFERENCE BOOK
1. ALFRED V. AHO, RAVI SETHI, JEFFREY D. ULLMAN, “PRINCIPLES OF COMPILER
DESIGN”, NAROSA PUBLISHING HOUSE.
BCA 2015-2018

ELECTIVE - I

SOFTWARE ENGINEERING

Number of Instruction Hours: 5 Course Code: 15CA302

Subject Description: This subject deals with Software Engineering concepts like Analysis,
Design, Implementation, Testing and Maintenance.

Goal: Knowledge on how to do a software project with in-depth analysis.

Objective: To inculcate knowledge on Software engineering concepts in turn gives a roadmap to

design a new software project

UNIT - I
Introduction: Program Vs Software Products-Emergence Of Software Engineering-Changes In
Software Development – Software Life Cycle Models.

Software Project Management: Project Planning- Project Size Estimation Metrics - Project
Estimation Techniques – Empirical Estimation Techniques – COCOMO – Organization & Team
Structures – Staffing – Risk Management – Software Configuration Management.

UNIT – II
Requirements Analysis and Specification: Requirements Analysis – Software Requirements
Specification – Formal System Specification.

Software Design: What Is A Good Software Design – Cohesion & Coupling – Layered Arrangement
of Modules- Approaches to Software Design- Function Oriented Design – Object Oriented Design.

UNIT – III
Function Oriented Software Design – Overview of SA/SD Methodology – Structured
Analysis – Data Flow Diagrams – Extending DFD Ttechnique to Make it Applicable to Real – Time
Systems – Structured Design.

Object Oriented Software Design: Overview of Basic Object Orientation Concepts – Basic
Mechanisms- Key Concepts – Related Technical Terms – Advantages of OOAD- Object Oriented Vs
Function Oriented.

UNIT – IV
User Interface Design : Characteristics of a Good User Interface Design – Basic Concepts –
Command language based Interface – Menu based Interface – Direct Manipulation Interfaces
– Windowing Systems – Types of Widgets – An Overview of X window/ MOTIF .
BCA 2015-2018

Coding and Testing : Coding – Unit Testing – Black Box testing – White Box Testing –
Debugging – Program Analysis Tools – Integration Testing – System Testing – General Issues
Associated With Testing.

UNIT – V
Software Reliability And Quality Assurance: Software Reliability – Software Quality – Software
Quality Management Systems – ISO 9000 – SEI Capability Maturity Model.
Computer Aided Software Engineering: CASE And Its Scope – CASE Support In Software Life
Cycle – Other Characteristics Of CASE Tools – Second Generation CASE Tools – Architecture Of a
CASE Environment.
Software Maintenance: Software Reverse Engineering – Software Maintenance Process Models –
Estimation Of Maintenance Costs.

TEXT BOOK
1.RAJIB MALL, “FUNDAMENTALS OF SOFTWARE ENGINEERING”, Third Edition, PHI, 2009.
UNIT-I (CHAPTER – 1, 2 & 3) UNIT – II (CHAPTER – 4 & 5)
UNIT – III (CHAPTER - 6 & 7)
UNIT – IV (CHAPTER – 9 & 10) UNIT – V (CHAPTER – 11, 12 & 13)

REFERENCE BOOKS
1. RAJIB MALL, “FUNDAMENTALS OF SOFTWARE ENGINEERING”, SECOND EDITION,
PHI, 2002.
2. R.S.PRESSMAN “SOFTWARE ENGINEERING”, FOURTH EDITION, TATA MCGRAW HILL,
1997.
3. RICHARD FAIRLY “ SOFTWARE ENGINEERING CONCEPTS”, TATA
MCGRAW-HILL, 1985.
BCA 2015-2018

ELECTIVE – I
SYSTEM ANALYSIS AND DESIGN

Number of Instruction Hours: 5 Course Code: 15CA302

Subject Description: This subject deals with a step wise approach to system analysis and design.

Goal: To gain Knowledge on software system, software design, testing and quality assurance
Objective: To help the students to develop the software in a systematic way with quality.
UNIT – I
The systems concept – characteristics of a system – elements of a system – types of a system –
the system development life cycle – the role of the system analyst.

UNIT – II
System analysis – system planning and the initial investigation – needs identification –
determining the user requirements – background analysis – fact finding techniques and analysis –
information gathering – review of literature – procedures – forms – on line observation – interviews
and questionnaires and types.

UNIT – III
Tools of structured analysis – data flow diagram – data dictionary – decision tree – Decision
table – feasibility study – system performance – feasibility considerations – steps in feasibility analysis
– feasibility report – oral presentation – cost benefit analysis.

UNIT – IV
System design – process and stages of system design – methodologies – structured and form
driven methodology – process control – data validation – I/O and form design – data base design –
objective of data base – logical and physical views of data.

UNIT - V
System implementation – system testing and quality assurance – nature of test data – test plan –
levels of quality assurance – implementation and software maintenance – hardware / software selection
– system security

TEXT BOOK
1.ELIAS M.AWAD – SYSTEM ANALYSIS AND DESIGN , SECOND EDITION, GALGOTIA
PUBLICATIONS , PVT. LTD,1997
UNIT-I (CHAPTER 1,2,3) UNIT-II (CHAPTER 4,5) UNIT-III (CHAPTER 6,7,8)
UNIT-IV (CHAPTER 9,10,12) UNIT-V (CHAPTER 12,13,14,16)

REFERENCE BOOKS
1. LEE, “INTRODUCTION TO SYSTEM ANALYSIS AND DESIGN”, FIRST EDITION,
GALGOTIA PUBLICATIONS, 1991.
BCA 2015-2018

PRACTICAL – V

JAVA PROGRAMMING LAB

Number of Instruction Hours: 3 Course Code: 15CA304

1. Write a program to print the following triangle of numbers

1
4
6 9
8 12 16
10 15 20 25.
2. Write a Java Program to define a class, describe its constructor, overload the Constructors and
instantiate its object
3. Write a program for sorting an array.
4. Write a program for matrix multiplication.
5. Write a program for method overloading.
6. Write a program for method overriding
7. Write a Java program to practice using String class and its methods.
8. Write a program to demonstrate inheritance concept.
9. Write a program to prepare Student Mark List using Interfaces concept.
10. Write a Java program to implement the concept of importing classes from user defined package.
11. Write a program to explain the multithreading and thread priority with the use of multiplication
tables. Three threads must be defined, with each creating one multiplication table( They are
6 table, 7 table and 13 table).
12. Write a program to display all shapes with available built in functions using applets.
BCA 2015-2018

SUPPORTIVE COURSE - II

INTERNET AND E-COMMERCE

Number of Instruction Hours: 4

Subject Description: This subject deals with internet addressing, commercial applications using
world wide web, E-Commerce, E-Business and E-Marketing.

Goal: To gain Knowledge on E-commerce using internet.

Objective: To make the students aware of E-Commerce and its issues.

UNIT - I
Internet connection concepts: Internet communication protocol – types of internet connections-Internet
service providers(ISPs) –security issues on the internet. How the domain name system works?: How
domains are organized –registering a domain system. E-Mail concepts: How do you get your E-Mail –
E-Mail addressing-message headers-Downloading E-Mail –using abbreviations-emoticons and smileys
– formatted E-Mail- Attaching files to messages- Web based E-Mail- Mail away from home-Avoiding
viruses.

UNIT - II
World Wide Concepts: The web languages and protocols-Special kinds of web sites and pages. Voice
and Video conferencing: What are internet phone ,voice conferencing and Video conferencing?-Voice
and video conferencing using instant messenger programs-Voice and video conferencing with windows
messenger , yahoo messenger and MSN messenger . Web commerce: Purposes of commercial web
sires –Selecting a web hosting service-Selling via secure service-Shopping cart systems-accepting
payments from customers –Auction sites-Consignment sites.

UNIT - III
History of E-Commerce: Early business information exchange efforts- Emergence of Internet-
Advantages of E-Commerce-Disadvantages of E-Commerce-extension of BAM model-transition to E-
Commerce in India. Business model for E-Commerce: E-Business model based on relationship for E-
Commerce- E-Business model based on relationship for transaction types. E-Security: Security on the
net- E-Business risk management issues.

UNIT - IV
E-Marketing: Traditional marketing- Identifying web presence goals – The browsing behavior model –
On line marketing –E-Advertising- Internet marketing-target Markets- E-Branding- Marketing
strategies. E-Payment systems: Digital payment requirements- Digital token based E-Payment systems-
Classification of new payment systems-Properties of E-Cash –Cheque payment system on the internet-
Risk and E-Payment system-Designing e-payment system-Digital Signature.
BCA 2015-2018

UNIT - V
E-Customer relationship management : Customer relationship management-Typical business touch
points. E-Supply chain management: E-supply chain – E-supply chain components-E-Supply chain
architecture. Mobile commerce: Growth of mobile commerce- wireless applications-Technologies for
mobile commerce-origins of WAP-WAP programming model-Wireless technologies-mobile
commerce.

TEXT BOOK
1. THE COMPLETE REFERENCE – INTERNET ,SECOND EDITION, MARGARET LEVINE
YOUNG.
UNIT-I (CHAPTER1,2,5) UNIT-II (CHAPTER -16,17,32)
2. E-COMMERCE - A MANAGEMENT PERSPECTIVE , P.T. JOSEPH, EASTERN ECONOMY
EDITION.
UNIT –III ( CHAPTER-1,2,5) , UNIT –IV (CHAPTER -4,6) , UNIT- V (CHAPTER -7,8,10)

REFERENCE BOOKS
1. JEFFERY F.RAYPORT, BERNARD J.JAWORSKI, “ E-COMMERCE”. TMCH, 2002.

2. RAVI KALAKOTA & ANDREW, B.WHINSTON, PEARSON EDUCATION.ASIA 2004.

BCA 2015-2018

SUPPORTIVE COURSE - II
SOFTWARE TESTING

Number of Instruction Hours: 4

Subject Description: This subject deals Software Testing concepts like phases of software project,
different types of testing.

Goal: Knowledge on how to do a software Testing.

Objective: To inculcate knowledge on Software Testing concepts.design a new software project

UNIT – I
Software Development Life Cycle Models – Phases of Software Project – Quality, Quality Assurance
and Quality Control – Testing, Verification and Validation- Process Models to represent different
phases- Life Cycle Models.

UNIT – II
Types of Testing-White Box Testing- What is White Box Testing?- Static Testing- Structural Testing-
Challenges in White Box Testing
Black Box Testing- What is Black Box Testing? – Why Black Box Testing? – When to do Black Box
Testing?- How to do Black Box Testing?
Integration Testing- What is Integration Testing? - Integration Testing as a type of testing.

UNIT - III
System and Acceptance Testing- System Testing Overview- Why System testing is done? – Functional
versus Non-Functional testing – Acceptance Testing.
Performance Testing- Introduction- Factors governing Performance Testing- Methodology for
Performance Testing.
Regression Testing- What is Regression Testing? – Types of Regression Testing- When to do
Regression Testing? – How to do Regression Testing?

UNIT – IV
People and Organizational issues in Testing-Common people issues- Perception and Misconception
about testing-Organization Structures for Testing Teams- Dimensions of Organization Structures-
Structures in Single Project Companies- Structures for Multi-Project Companies- Effects of
Globalization and Geographically Distributed Teams on product Testing - Success Factors for Testing
Organizations.

UNIT – V
Testing Management and Automation-Software Testing Automation – Test Planning – Software Test
Automation-What is Testing Automation?- Terms used in Testing Automation- Skills needed for
Automation- What to Automate, Scope of Automation- Design and Architecture for Automation.
Test Metrics and Measurements- What are Metrics and Measurements? - Why Metrics in Testing?-
Types of Metrics- Project Metrics- Progress Metrics- Progressive Metrics- Release Metrics.
BCA 2015-2018

TEXT BOOK
1.SRINIVASAN DESIKAN, GOPALASAMY RAMESH,”SOFTWARE TESTING PRINCIPLES
AND PRACTICES” PEARSON EDUCATION, 2011
REFERENCE :
1. BORIS BEIZER, “SOFTWARE TESTING TECHNIQUES” , DREAMTECH
2. LOUISE TAMRES, “INTRODUCING SOFTWARE TESTING”, PEARSON EDUCATION.
BCA 2015-2018

SUPPORTIVE COURSE - II

SYSTEM SOFTWARE

Number of Instruction Hours: 4

Subject Description: It deals Fundamentals of System Software

Goal: Knowledge on various System Software like Assemblers, Compilers, Operating systems, Macro
processor etc
Objective: Enable the student to get sufficient knowledge on various system resources

UNIT- I
System programming - Language processors - language Processing Activities - Fundamentals
of Language specification - language processor development tools - Data structures for language
processing - Search Data Structures - Allocation data structures.

UNIT - II
Scanning and Parsing - Scanning - Parsing - Assemblers Elements of assembly
Language programming - Assembly scheme - Pass structure of assemblers - Design of a two pass
assembler - A single pass assembler for IBM PC.

UNIT - III
Macro definition and call - Macro expansion - Nested macro calls - Advanced Macro Facilities
- Design of a macro preprocessor.

UNIT - IV
Compilers and Interpreters - Aspects of compilation - memory allocation - Compilation of
expressions - Compilation of control structures - code optimization - Interpreters.

UNIT - V
Linkers-Relocation and linking concepts - Design of a linker - Self Relocating programs - A
linker for MSDOS - linking for overlays - loaders - Software Tools - Tools for program development -
Editors - Debug monitors - Programming environments - user interfaces.

TEXT BOOK
1. D.M DHAMDHERE , " SYSTEM PROGRAMMING AND OPERATING SYSTEMS",TATA
MCGRAW
HILL PUBLISHERS,SECOND EDITION,1993.
UNIT - I (CHAPTER 1,2,3) UNIT - II (CHAPTER 4,5,6)
UNIT - III (CHAPTER 7,8,9) UNIT – IV (CHAPTER 10,12,12)
UNIT – V (CHAPTER 13,14,15)

REFERENCE BOOK
L.BECK, SYSTEM SOFTWARE , TATA MC GRAW – HILL PUBLISHERS, SECOND EDITION
BCA 2015-2018

PRACTICAL –VII

VB.NET LAB

Number of Instruction Hours: 3 Course Code: 15CA403

1. Develop a Windows application to sort the given numbers using looping statements.
2. Develop a Windows application to print grade of a student using Conditional Statement.
3. Develop a Windows application to add and remove items in a list view control.
4. Develop a Windows application to create a menu for performing cut, copy and paste.
5. Develop a Windows application for calculating the total marks of a student using User control.
6. Develop a Console application for String Manipulation.
7. Develop an application to design a Calculator.
8. Develop an application to display employee details using ADO.Net.
9. Develop an application to display Stock details using ADO.Net.
10. Develop an application for Bank details and generate a Crystal Reports.
BCA 2015-2018

SEMESTER - IV

PART – III
VB.NET

Number of Instruction Hours: 4 Course Code: 15CA401

Subject Description: This subject deals with VB.NET concepts.

Goal: To enable the students to learn the basic functions, principals and concept of VB.NET.

Objective: On successful completion of the course the students should have understood the
programming in VB.NET

UNIT – I
Introduction .NET-VB.NET Framework overview-Common type system- Common language
specification-Common immediate language- Just in Time Compiler-Virtual Execution System-.NET
Framework-Class Library-Namespace-Languages in .NET-Why VB.NET? – Features – Objects –
Encapsulation, Overloading, Inheritance, Polymorphism, Constructors and Destructors, Interfaces, Free
threading, delegates- Console applications -Assemblies- Our first VB.NET Program.

UNIT – II
Data Types and Operators- Literals, Variables, Data types- Declaration of variables- Constants –
Statements- Operators- Keywords- Comments – Scope of Variables- Console application in VB.NET-
Control Statements – If Statement- Types of If Statements- Looping Statements.

UNIT- III
Form Control- Events- Label- Text Box- Group Box Control- Check Box Control- Radio Button-
Visual Basic code for Radio button and Text box Control- Scroll bar Control- C Type- Track Bar-
Timer- Picture Box- Working with Mouse Input- Link Label- Date Time Picker- Month Calendar-
Arrays- One dimensional array- Array Initialization- Reading Statements- Multidimensional array-
Implementation of 2D arrays- Arrays of Array.

UNIT - IV
Procedures and Structures- Functions- Calling a function- Call by reference- Functions with arrays-
Function with param arrays-Function Overloading- Sub procedure- Message Box function- Input Box
function- Creating Menus and Using dialog boxes- MDI forms- Content menu- Rich Text Box- Color
Dialog Control- Font dialog Control- Object Oriented Concepts in VB.NET- Class- Adding methods to
classes- Classes with Constructor- Inheritance- Overriding Properties and methods- Polymorphism-
Exception- Try, Catch, finally, End Try, Try-Catch, Multiple Catch, Nested Try statements, Try-
finally.
BCA 2015-2018

UNIT - V
Data access with ADO.Net- What is Database- What is Relational Database- Special features of
ADO.Net- Difference between ADO and ADO.Net- Connection- Commands- Dataset using a data
grid- Using data adapter configuration wizard- Complex data binding- ADO.Net and Data Binding-
Creating a user control in VB.Net- Adding user control to a form- Making Reports in VB.Net.

TEXT BOOK:
1.VB.NET – P.Radnaganesan,Scitech publications India Pvt Ltd, 2008

REFERENCE BOOKS:
1 Alex Homer ,”VB.Net programming “ , WROX Publications.
2. Matt J. Crouch, “ASP .Net and VB .Net Web Programming”, Pearson Education
BCA 2015-2018

PART – IV

SEMESTER –IV

GENERAL AWARENESS
(Effective from 2009-10 and onwards -Non-major II)

Number of Instruction Hours: 2 Course Code : 15NM02

(To be taught during the Second year study of every undergraduate course 2 hours every
week)

Course Content:

Important events/ Dates in the history of the world in general and in Indian in particular
importance is also given to the local history (History of Tamilnadu)

World Personalities :

Great authors and their important works; inventions and discoveries; honors and awards.

Sports, education, general science, geography, important technologies, Indian constitution,

national movements.

Skills in the following Areas:

Logical Reasoning
Mental Ability
Numerical Ability and General Awareness

TEXT BOOK:

Foundation Course – A: GENERAL AWARENESS BHARATHIATR UNIVERSITY.

REFERENCE BOOK:

OBJRECTIVE ARITHMETIC - RAVI COPRA

OBJRECTIVE GENERAL KNOWLEDGE - BRIGHT & PHULL
BINN’Y GENERAL MENTAL ABILITY
REASONING & LOGIC - KAUSHAL GOYAL
MANORAMA YEAR BOOK
COMPETITION SUCCESS REVIEW & - MONTHLIES.
GENERAL KNOWLEDGE
BCA 2015-2018
BCA 2015-2018

ALLIED – IV

MARKETING MANAGEMENT

Number of Instruction Hours: 4 Course Code: 15CA402

Subject Description: This subject deals with marketing management concepts.

Goal: To gain Knowledge on

Marketing environment and segmentation.
Pricing factors and policies.
Promotion Mix.

Objectives
To help students to understand the concept of marketing and its applications. Also to
expose the students to the latest trends in marketing

UNIT - I
Marketing-Definition- -objectives of Marketing-its importance -Marketing functions: Buying-
assembling- selling-transportation and facilitating functions.
UNIT - II
Consumer behavior- - Market segmentation- meaning- its bases. Marketing Mix- meaning-
Product- - Product Mix- Product Life Cycle.

UNIT - III
Pricing-meaning- its objectives- factors affecting pricing decision- Channels of Distribution-
meaning-types-factors governing the choice of channels-types of intermediaries.

UNIT - IV
Sales Promotion-Meaning-Objectives and Importance- sales promotion tools-Personal
Selling- Advertising- types- Choice of media.

UNIT - V
Social responsibility of Marketing- BIS-AGMARK-ISO- concept of E-Marketing

TEXT BOOK

1. MODERN MARKETING PRINCIPLES AND PRACTICES”-R.S.N. PILLAI &

BAGAVATHI-S.CHAND AND COMPANY, 4TH EDITION-2014
BCA 2015-2018

REFERENCE BOOK

1. PRINCIPLES OF MARKETING”-PHILIP KOTLER-PRENTICE HALL OF INDIA, 13 TH

EDITION-2013
BCA 2015-2018

PRACTICAL –VIII

ORACLE LAB

Number of Instruction Hours: 3 Course Code: 15CA404

SIMPLE QUERIES
1. Create a table and write simple queries for modifications of the data base
i) UPDATE & ALTER Table ii) DELETE iii) RENAME a table & Attributes
2. Create a table and write simple queries using
i) Relational & Logical Operators ii) Ordering & Grouping records.
3. Create a table and write simple queries by using
i) Set operators ii) Aggregate functions.
4. Create a table and write simple queries by using
i) Numerical functions ii) Date functions
5. Create a table and write simple queries using string operations (Pattern Matching LIKE) &
functions.

PL/SQL

6. Creation of student information table and write PL/SQL block to find the total, average
marks and results of the students.
7. Write a PL/SQL block to generate electricity bill for customers.
8. Write a PL/SQL block to split the table into two, one with the passed details and other with
the failed details.
9. Write a PL/SQL block to join two tables, first table contains roll number, name, total. Second
table contains the roll number and address.

TRIGGERS

10. Create a database trigger to check the validity of the record.

FUNCTIONS

11. Write a recursive function to find the factorial of a given number.

12. Write a recursive function to generate the Fibonacci series with ‘n’ terms.
BCA 2015-2018
BCA 2015-2018

SKILL BASED COURSE: 2

RDBMS & ORACLE

Number of Instruction Hours: 4 Course Code: 15CA405

Subject Description: This subject deals with RDBMS concepts using Oracle SQL and PL/SQL.

Goal: Knowledge on RDBMS-Oracle Programming techniques.

Objective: To inculcate knowledge on RDBMS concepts and Programming with Oracle

UNIT - I
Introduction: Database System Applications - Purpose Of Database Systems-View Of Data-Data
Models- Other Data Models - Database Languages- Database Users and Database Administrator -
Transaction Management- Database System Structure.
UNIT - II
Entity Relationship Model: Basic Concepts-Mapping Constraints – Keys- ER Diagram-Weak Entity
Sets. Relational Model: Structure of Relational Databases. Relational Algebra: Fundamental
Operations, Additional Operations – Extended Relational Algebra Operations.
UNIT - III
SQL: Basic Structure – Set Operations – Aggregate Functions - Null Values – Views -Modifications of
The Databases –Joined Relations – Data Definition Languages - Embedded SQL.

UNIT - IV
Integrity Constraints: Domain Constraints-Referential Integrity Constraints -Triggers.
Relational Database Design: Pitfalls In Relational Database Design- Functional Dependencies-
Decomposition - Normalization (1NF, 2NF, 3NF, BCNF).

UNIT -V
Oracle PL/SQL Basics: Introduction :- PL/SQL Basics-PL/SQL Structure- PL/SQL And Oracle.
Function and Procedure: Introduction – Subprograms – Functions - Procedures.

TEXT BOOK
1. DATABASE SYSTEM CONCEPTS – ABRAHAM SILBERSCHATZ, HENRY F KORTH,
S. SUDARSHAN, Fourth Edition, McGraw-Hill Publications - INTERNATIONAL EDITION.
UNIT I (CHAPTER 1) UNIT-II (CHAPTER 2 & 3)
UNIT-III (CHAPTER 4) UNIT-IV (CHAPTER 6 ,7)
2. DATABASE MANAGEMENT SYSTEM-Oracle SQL and PL/SQL-PRANAD KUMAR DAS
GUPTA (UNIT V-7, 8.1-8.4)

REFERENCE
1. DATABASE SYSTEM CONCEPTS – ABRAHAM SILBERSCHATZ, HENRY F KORTH,
S. SUDARSHAN, SIXTH EDITION.
2. DESH PANDE, “SQL & PL SQL FOR ORACLE 10G”, DREAM TECH.
3. ALLEN, “ORACLE DATABASE PL/SQL” , TMH (TATA MCGRAW HILL).
BCA 2013-16 Page 1 of 17
SEMESTER - V
PART – III
VISUAL BASIC PROGRAMMING
Number of Instruction Hours: 4 Course Code : 13CA501

Subject Description : This subject deals Visual Basic Programming concepts.

Goal : Knowledge on Visual Programming and how to develop a Project using VB.
Objective : To inculcate knowledge on Programming and Project Development using Visual
Basic.
UNIT-I:
Visual Basic Overview: Creating a project in Visual Basic- The parts of Visual Basic Project- Project
Scope- Project Scope on Disk- Using Visual Basic Application Wizard.
The Visual Basic Development Environment: Overview of the Integrated Development Environment.
The Visual Basic Language: How does Visual Basic code look?- Declaring constants- Declaring
Variables- Selecting Variables Types- Converting between Data types- Setting Variables Scope- Declaring
Arrays and Dynamic Arrays- Declaring subroutines- Declaring Functions- Handling Strings- Converting
Strings to Numbers- Handling operators- Operator Precedence- If-Else statements- Using Select case-
Making Selections with switch( ) & choose( )- Looping- Using Collections- Handling Math, Date & Times-
Ending a Program.

UNIT- II:
Managing Forms in Visual Basic: The parts of a Form- The parts of an MDI form- Setting Title bars text-
Adding toolbars and status bars to forms- Working with Multiple Forms- Creating Forms in Code- Using
the Multiple Document Interface- Arrays of Forms- Creating Dialog boxes- Passing Forms to Procedures.
Visual Basic Menus: Menu Design Considerations- Adding a Menu to a Form- Modifying and Deleting
Menu items- Creating Submenus-Creating Immediate Menus(“Bang”)-Disabling Menu items-Handling
MDI Form and MDI Child Menus- Making menus and menu items Visible or Invisible- Creating and
displaying Pop-Up Menus-Adding and deleting Menu items at Runtime.\

UNIT-III:
Creating an Application Using Controls: Text boxes and Rich Text Boxes- Command buttons,
Checkboxes, and Option Buttons- List Boxes and Combo Boxes- Scroll Bars- Sliders- Picture Boxes and
Image Controls- Windows Common dialog Box- the Chart and Grid Controls- the Timer- Frames, Label,
Shape and Line controls- Toolbars, Status Bars.

UNIT-IV:
File Handling and File Controls: Sequential Access Files- Binary Files- The File System Object-Creating
a File- Getting File length- Opening File- Writing to a Sequential file- Writing to a Random Access file-
Writing to a Binary file- Reading from sequential file- Reading from Random Access files-Reading from
Binary files- Accessing any record in Random Access file- Closing a File- Using the Drive list box control,
Directory list box control, the File list box control- Copying, Moving and deleting files- When was a File
created? Last Modified? Last Accessed? OLE: Linking Vs Embedding- Immediate Solutions- Deploying
your Program: Creating your Application’s EXE File-Using the Package and Deployment Wizards
UNIT-V:
Databases: Using DAO, RDO and ADO: What are Databases?- DAO- RDO- ADO- The Data-Bound
Controls- Creating and Managing Databases with the Visual Data Manager- Creating a Table with the
Visual Data Manager- Creating a field with the Visual Data Manager- Entering Data in a Database- Adding
a data control to a program- Opening a Database with the Data control- Connecting a Data Control to a
Bound control- Registering an ODBC Source- Opening a Database with a Remote Data control- Connecting
a Remote data control to bound control- Opening a Database with an ADO Data control- Connecting an
ADO data control to a Bound Control- Creating a Data Form- Adding, Deleting and modifying records-
Moving Records- The ADO Data-Bound Controls- Working with the Visual Basic Report Designer.
TEXT BOOKS:
1. “Visual Basic 6 Programming Black Book”, Steven Holzner, Dreamtech Press.
2. “The Complete Reference Visual Basic 6” By Noel Jerke, Tata McGraw-Hill.

REFERENCE BOOKS:

1. “Step by Step Microsoft Visual Basic 6.0 Professional”, Michael Halvorson, PHI.
2. “Visual basic 6 Complete”, BPB Publications.
3. “Mastering Visual Basic 6”, Evangelos Petroutsos. , BPB Publications.
BCA 2013-16 Page 3 of 17

PRACTICAL – IX

VISUAL BASIC PROGRAMMING LAB

Number of Instruction Hours: 3 Course Code : 13CA503

1) Write a Visual Basic Program to compute simple and compound interest.

2) Create a Visual basic program to perform Numerical operations using menu.
3) Write a Visual Basic Program to calculate the Employee salary.
4) Write a Visual Basic program to calculate Electricity Bill.
5) Develop a program to Mini Calculator function
6) Develop a VB program to check user name and password given by the user.
7) Write a simple VB program to accept a number as input and convert them into
A. Binary
B. Octal
C. Hexa-decimal
8) Develop a VB program to add and remove item from a list box and combo box.
9) Develop a VB program to scroll the text left to right and display data and time by using timer
control.
10) Develop a VB program display monthly Calendar using flex grid.
11) Write a Visual basic program to find the Factorial of a given number.
12) Write a VB program to check the given number is prime number or not.
13) Write a VB program to explain working with Databases without using Data control.
14) Write a Visual Basic program to create an address book database and access through DAO.
15) Write a Visual Basic program to create an address book database and access through ADO.
BCA 2013-16 Page 4 of 17
PRACTICAL –X

ORACLE LAB
Number of Instruction Hours: 3 Course Code: 13CA504

SIMPLE QUERIES
1. Create a table and write simple queries for modifications of the data base
i) INSERT ii) DELETE iii) UPDATE
2. Create a table and write simple queries using
i) Comparison & Relational Operators ii) Logical Operators
3. Create a table and write simple queries for
i) PATTERN MATCHING Operator “like” ii) RENAME a table & Attributes iii) ALTER Table
4. Create a table and write simple queries by using Set operators
5. Create a table and write simple queries by using Ordering & grouping records.
6. Create a table and write simple queries using Date functions.
7. Create a table and write simple queries using Numerical functions.
8. Create a table and write simple queries using Aggregate functions.

PL/SQL
9. Creation of student information table and write PL/SQL block to find the total, average marks and
results of the students.
10. Write a PL/SQL block to generate electricity bill for customers.
11. Write a PL/SQL block to split the table into two, one with the passed details and other with the failed
details.
12. Write a PL/SQL block to join two tables, first table contains roll number, name, total. Second table
contains the roll number and address.

TRIGGERS
13. Create a database trigger to check the validity of the record.

FUNCTIONS
14. Write a recursive function to find the factorial of a given number.
15. Write a recursive function to generate the Fibonacci series with ‘n’ terms.
BCA 2013-16 Page 5 of 17
PART IV
SKILL BASED COURSE: 3

RDBMS AND ORACLE

Number of Instruction Hours: 4 Course Code: 13CA505

Subject Description: This subject deals with RDBMS concepts using Oracle SQL and PL/SQL.

Goal: Knowledge on RDBMS-Oracle Programming techniques.

Objective: To inculcate knowledge on RDBMS concepts and Programming with Oracle

UNIT - I
Introduction : Purpose of Database Systems-view of data-data models- Database languages-Transaction
management- Storage management- DBA- database users-over all system structure.

UNIT - II
ER –Model : Basic concepts-mapping constraints –keys-ER diagram-Weak entity set. Relational model:
Structure of relational database, relational algebra, Extended relational algebra operations.

UNIT - III
SQL : Basic structure –set operations – aggregate functions-null values – views-modifications to the
databases –join relation-DDL-Embedded SQL.

UNIT - IV
Integrity constraints: Domain constraints-referential integrity constraints-Triggers-functional dependencies.
Relational database design: Pitfalls in relational database design-Decomposition-Normalization
(1NF,2NF,3NF,BCNF).

UNIT -V
Oracle PL/SQL Basics:
Introduction:-PL/SQL Basics-PL/SQL Structure- PL/SQL and oracle. Function Procedure: Introduction-
Subprograms-Functions-Procedures.

TEXT BOOK
1. DATABASE SYSTEM CONCEPTS – ABRAHAM SILBERSCHATZ , HENRY F KORTH , S.
SUDARSHAN.
UNIT I (CHAPTER 1) UNIT-II (CHAPTER 2 , 3)
UNIT-III (CHAPTER 4 ) UNIT-IV (CHAPTER 6 ,7 )
2. DATABASE MANAGEMENT SYSTEM-Oracle SQL and PL/SQL-PRANAD KUMAR DAS
GUPTA (UNIT V-7,8.1-8.4)

REFERENCE
1. DESH PANDE, “SQL & PL SQL FOR ORACLE 10G, DREAM TECH.

2. ALLEN, “ORACLE DATABASE PL/SQL” , TMH (TATA MCGRAW HILL).

BCA 2013-16 Page 6 of 17
SEMESTER - VI
PART – III
COMPUTER NETWORKS
Number of Instruction Hours: 5 Course Code: 13CA601

Subject Description: This subject deals with different Network concepts like Layers, Wireless
Concepts, Transmission and Security.

Goal: Knowledge on Computer Networks and technologies like broadband and Bluetooth.

Objective: To inculcate knowledge on Networking concepts and technologies like wireless,

broadband and Bluetooth

UNIT - I
Introduction: Uses of Computer networks - Network hardware - Reference models
The Physical Layer: Guided transmission media-Communication satellites - The public
Switched telephone network: Structure of telephone system-the local loop: modems,
wireless local loops-switching.
UNIT - II
The Data link layer: Data link layer design issues-Error detection and correction-The medium
access Control sub layer: the channel allocation problem- Multiple Access Protocols: Carrier Sense
Multiple Access Protocols, Collision free Limited Contention Protocols-Bluetooth: Bluetooth Architecture -
Bluetooth Applications. Data Link Layer Switching: Repeaters, Hubs, Bridges, Switches, Routers and
Gateways.
UNIT - III
The Network layer: Network layer design issues – Routing algorithms: The optimality Principle, Shortest
path routing: Flooding, Distance vector routing, Routing for mobile hosts.

UNIT - IV
The transport layer: Transport layer service, Service provided to the upper layer-transport service
primitives, Berkeley Sockets-Elements of transport protocols.

UNIT - V
The application layer: DNS- the domain Name System-Electronic Mail: Architecture and Service,
The user agent, network Security, Cryptography – Symmetric key algorithm-DES – Public key Algorithm –
Digital Signature: Symmetric key Signatures-Algorithm, Public key Signatures.
TEXT BOOK
1. ANDREW S TANENBAUM, “COMPUTER NETWORKS”, 4TH EDITION, PEARSON EDITION
PUBLICATIONS.
UNIT – I (CHAPTER 1,2) UNIT – II (CHAPTER 3,4)
UNIT – III (CHAPTER 5) UNIT – IV (CHAPTER 6)
UNIT – V (CHAPTER 7,8)
REFERENCE BOOKS
1. MILLER “ DATA AND COMMUNICATION”, VIKAS PUBLICATION, 2001
2. WILLIAM A SHAY, “UNDERSTANDING DATA COMMUNICATION AND NETWORK” ,2ND
EDITION
 BCA 2013-16 Page 7 of 17

Practical – XI

NETWORK & OPERATING SYSTEM LAB

Number of Instruction Hours: 3 Course Code: 13CA602

NETWORK :

1. Write a program to implement the Shortest Path Routing using Dijkstra Algorithm.
2. Implement Bellman and Ford’s algorithm
3. Implement any one flooding algorithm
4. Program for machine to machine chatting for TCP sockets.
5. Write a Socket Program to Perform file transfer from Server to the Client.

OPERATING SYSTEM :

1. Write a Program to Question paper simulation

2. Write a Program to Dos command simulation
3. Write a Program to Calendar manipulation
4. Write a Program to Number of words , lines and characters in a file
5. Write a Program to Generation of pay slip
6. Write a Program to Arrange files in a directory
7. Write a program to count the number of characters in a given string.
8. Write a menu driven shell script to implement the following UNIX commands.
9. Write program to Compresses a file using gzip and pack commands
10. Write a program to find a given pattern in a list of files of current directory using grep and
fgrep commands.
BCA 2013-16 Page 8 of 17
Practical – XII
SOFTWARE DESIGN LAB
Number of Instruction Hours: 3 Course Code: 13CA603
1. Information System
2. Gas Agency Management System
3. Inventory Management System
4. Payroll Processing System
5. Hospital Management System
6. Library Management System
7. Railway Reservation System
8. Supermarket Management System
9. Sales Order Processing System
10. Hostel Management System
11. Student Information System
12. Mark List Preparation System
13. Software for game
14. Automating Bank system
15. Restaurant System

For the above list of titles students has to do System study. Based on the study students has to draw
DFD diagrams, ER diagrams, Create table structure, Design the necessary forms, Generate necessary
reports.
NOTE: 1. DFD and ER diagrams are to be drawn using any flowchart drawing tool.
(Smartdraw, Visio, etc.)
2. Tables to be created in any RDBMS package. (ORACLE, MS-ACCESS, etc.)
3. Forms and Reports are to be designed using any Front-end tool.
BCA 2013-16 Page 9 of 17
OPERATING SYSTEMS

Number of Instruction Hours: 5 Course Code: 13CA604

Subject Description: This subject deals Operating Systems concepts like Information, Process
and Memory Managements. Also it deals with advanced topics like Distributed processing,
Remote Procedure call and Clusters.

Goal: Knowledge on Operating system and how it controls the information and hardware.

Objective: To inculcate knowledge on OS concepts and functioning of modern OS

UNIT – I
Operating System-Early History of OS-Hardware - Software-Firmware – Process- Process States- Process
State Transitions - Process Control Block - Suspend and Resume - Interrupt Processing
Mutual Exclusion- Critical Sections-Semaphores - Deadlock- Necessary Conditions for Deadlock -
Deadlock Prevention - Deadlock Avoidance - Deadlock Detection - Deadlock Recovery.

UNIT – II
Storage Management - Storage Hierarchy - Contiguous Vs Noncontiguous Storage Allocation - Partition
Multiprogramming - Variable Partition -Virtual Storage - Block Mapping - Paging And Segmentation.

UNIT – III
Virtual Storage Management Strategies - Page Replacement Strategies - Page Replacement Strategies
Locality - Work Set - Demand Page. Job and Processor Scheduling - Scheduling Levels - Preemptive Vs
Non Preemptive Scheduling Priorities - Scheduling Techniques.

UNIT – IV
Disk Performance Optimization - Moving Head Disk Storage - Disk Scheduling- Characteristics of Disk
Scheduling Policies - Seek Optimization
File System-File Organization - Allocating and Freeing Space - File Descriptor.

UNIT – V
Case Studies : Linux Operating System- History of Linux- Linux Types - Linux File Structures.
Shell Variable-Pipe and Filters, Redirection- Searching files- grep and fgrep and Shell Programming.

TEXT BOOK
1. OPERATING SYSTEM, HM DEITAL, ADDISON WESLY PUBLICATION, 2 ND EDITION
UNIT – I (CHAPTER 1,3,4,6) UNIT –II (CHAPTER 7,8,9)
UNIT – III (CHAPTER 10) UNIT – IV (CHAPTER 12,13)
2. THE COMPLETE REFERENCE LINUX , RICHARD PETERSEN, TATA MCGRAW HILL,
FOURTH EDITION UNIT – V (Chapter 1, 8, 11)

REFERENCE BOOK
1. OPERATING SYSTEM, ANDREW S TENENBAUM & ALBERTS WOODHULL, PHI, 2 ND EDITION
BCA 2013-16 Page 10 of 17
ELELCTIVE -II
INTRODUCTION TO OPEN SOURCE TOOLS

Number of Instruction Hours : 5 Course Code : 13CA502

Object Description :This subject deals with PHP Operators ,FTP, Cookies, HTML, WebPages

Goal: To gain Knowledge in PHP and also able to design static and dynamic WebPages.

Objective : To make the student to understand the concepts of PHP and DREAMWEAVER.

UNIT: I
Introduction :Essential PHP: Entering, Getting, Creating ,Printing the PHP, Command-Line PHP, Creating
, Storing ,Working with variables and constants – Operators and Flow Control: Strings and Arrays:
String Functions, Converting to and from Strings, Formatting Strings ,Arrays ,Handling Arrays with Loop ,
PHP Array Functions.

UNIT-II
Crating Functions: Creating , passing functions in PHP , Using Default Arguments , Returning Data from
functions , Returning Arrays ,Lists , References ,PHP conditional and variable functions. Reading Data in
Web Pages.

UNIT-III
PHP Browser –Handling Power : File Handling Working with Database : Sessions , Cookies and FTP.

UNIT-IV
Introduction to Dream WeaverCS3 interface: Working with webpages .Working with HTML Tables and
Frames.

UNIT-V
Adding Graphics , Introduction to Cascading style sheets, working with active contents and Html forms,
Finalizing site.

TEXTBOOK:
1.The Complete Reference PHP-Steven Holzner published by TATA MCGRAW- HILL.
Unit-I (Chapter 1,2,3) Unit-II (Chapter 4,5) Unit-III (Chapter 5,6,9,10,11)

2.Dream WeaverCS3 in Simple Steps – Kogent Solutions Inc. Published by dreamtech press.
Unit-IV (Chapter 1,3,4) Unit-V (Chapter 5,6,8,9)

REFERENCE BOOK
1.Adobe Dream WeaverCS3 in 24 hours –Bruce by Sams Publications
BCA 2013-16 Page 11 of 17
ELELCTIVE -II

UNIFIED MODELLING LANGUAGE

Number of Instruction Hours: 5 Course Code: 13CA502

Subject Description: This subject deals with unified modeling concepts..

Goal: To gain Knowledge on UML use case diagrams, Sequence diagrams.

Objective: To make students to design use case diagram for their own project.

UNIT - I (Chapter 2, 5 -8 )
Introducing the UML: An overview of the UML- A Conceptual model of the UML.
Basic Structural Modeling: Classes - Terms and Concepts _ Common Modeling Techniques. Terms and
Concepts of Relationships, Common Mechanisms, Diagrams and Class Diagrams.

UNIT – II (Chapter 10 – 15)

Advanced Structural Modeling: Terms and concepts of Advanced Relationships, Interfaces, Types
and Roles, Packages, Instances, Object Diagrams and Components.

UNIT – III(Chapter 16 – 20)

Basic Behavioral Modeling: Terms and concepts of Interactions, Use Cases, Use Case Diagrams,
Interaction Diagrams and Activity Diagrams.

UNIT - IV (Chapter 12 – 25)

Advanced Behavioral Modeling: Terms and Concepts of Events and Signals, State Machines,
Processes and Threads, Time and Space, State Diagrams.

UNIT - V(Chapter 26– 32)

Architectural Modeling: Terms and Concepts of Artifacts, Deployment, Collaborations, Patterns
and Frameworks, Artifact Diagrams, Deployment Diagrams, System and Models.

Text Book

1. “The Unified Modeling Language User Guide” – Grady Booch, James Rumbaugh,
Ivar Jacobson – Pearson Education, Second Edition.

Reference Book

1. “UML Distilled” –Martin Fowler - Pearson Education, Third Edition.

BCA 2013-16 Page 12 of 17

ELELCTIVE -II

CLIENT/SERVER TECHNOLOGY

Number of Instruction Hours: 5 Course Code: 13CA502

Subject Description:
This course presents the overview of client/server computing, client/server hardware and
software requirements, application development and production environments.

Goal:
To enable the students to learn the concept of client/server computing

Objectives:
On successful completion of the course the students should have:
Understood the client/server computing techniques
Understood the client/server application development and production environments

UNIT - I
Client Server Computing - What is Client/server - File servers, Database servers, Transaction
servers, Group ware servers, Object servers, Web servers - FAT servers or client/server - Client/server
Building blocks.

UNIT - II
Client/Servers and operating systems - the Anatomy of a server program - Needs of Client/server
from an OS - server scalability - Client Anatomy - Client and server OS trends – client OS and Server OS.
NOS : Creating the single system image -Remote procedure calls(RPC) – Messaging and Queuing :
The MOM Middleware.

UNIT - III
SQL Database Servers : What does SQL do ? – The ISO standards- What does a database server
do ? – Stored procedures, Triggers and rules.
Data warehouses - OLTP (OnLine Transaction Processing) - Decision Support systems (DSS) -
Executive Information System(EIS) - comparing Decision Support and OLTP Systems - Production Vs
Information Databases - The Dataware house.

UNIT - IV
Client/Server Transaction Processing - the ACID properties - Transaction Models - TP monitors -
Client/server groupware - Importance of groupware - What is Groupware- The components of Groupware.
Distributed Objects, CORBA style - Object management Architecture-compound documents - The
compound document frame work.
UNIT - V
Web client/server - What is URL? - Shortest HTML tutorial - HTTP – 3 tier client/server, web style
- HTML Web based forms - CGI : The server slide of the Web - Web security - The Internet and the
Intranets - Compound Documents and the object Web - The DCOM/OLE
Object Web - The CORBA object web.

TEXT BOOK
1. ROBERT ORFALI, DAN HARKEY & JERI EDWARDS, “THE ESSENTIAL CLIENT/SERVER
SURVIVAL GUIDE” – SECOND EDITION 2002, GALGOTIA PUBLICATION PRIVATE
LIMITED.
UNIT I – CHAPTER 2-3 UNIT II – CHAPTER 5-8
UNIT III – CHAPTER 10,12 UNIT IV – CHAPTER 16,17,20,23,24
UNIT V – CHAPTER 27,28,30)

REFERENCE BOOK
1. PATRICK SMITH, STEVE GUENGERICH, “CLIENT/SERVER CMPUTING”, SECOND
EDITION, A PRENTICE HALL COMPUTER PUBLISHING REPRINT.
BCA 2013-16 Page 14 of 17
Supportive Course [ III YEAR]
ARTIFICIAL INTELLIGENCE
Number of Instruction Hours: 5 Course Code: 13CB313

Subject Description: This subject deals with various AI Concepts and Methodologies.

Goal: To Acquire Knowledge on various AI Techniques and Expert Systems.

Objective: To have enriched knowledge regarding heuristic search, Knowledge representation

and Expert systems

UNIT - I
Introduction : AI Problems – Physical symbol system hypothesis- AI techniques – The level of the model -
Criteria for success.
Problems, Problem spaces and Search : State space search -Production Systems - Problem Characteristics –
Production system characteristics - Issues in design of Search programs.

UNIT - II
Heuristic Search Techniques : Generate and Test - Hill Climbing – Best First search, Problem Reduction,
Constraint Satisfaction, Means - end analysis.

UNIT - III
Knowledge representation issues: Representations and mapping – Approaches to knowledge representations
– Issues in Knowledge representations - Semantic Nets- Frames- Conceptual Dependency- Scripts.

UNIT - IV
Using Predicate logic : Representing simple facts in logic - Representing Instance and ISA relations -
Computable functions and predicates - Resolution-Natural deduction.
Representing knowledge using rules: Procedural Vs Declarative knowledge - Logic programming - Forward
Vs Backward reasoning - Matching-Control knowledge.

UNIT – V
Introduction to expert systems – Definition- characteristics- Architecture
Knowledge engineering: Knowledge Engineering- Expert system life cycle- Expert system tools. Expert
systems: DENDRAL- MYCIN.

TEXT BOOKS
1. ELAINE RICH AND KEVIN KNIGHT,"ARTIFICIAL INTELLIGENCE",TATA
MCGRAW HILL PUBLISHERS COMPANY PVT LTD,SECOND EDITION, 1991.
UNIT I : CHAPTER 1, 2 UNIT II : CHAPTER 3
UNIT III: CHAPTER 4, 9, 10 UNIT IV : CHAPTER 5, 6

2. V.S.JANAKIRAMAN, K.SARUKESI AND P.GOPALAKRISHNAN, “FOUNDATIONS OF

ARTIFICIAL INTELLIGENCE AND EXPERT SYSTEMS”, MACMILLAN SERIES .
UNIT V : CHAPTER 11, 12, 13
REFERENCE BOOK
1. DAN W. PATTERSON, “ARTIFICIAL INTELLIGENCE AND EXPERT SYSTEMS”, PHI PUB.,
BCA 2013-16 Page 15 of 17
Supportive Course [ III YEAR]
EMBEDDED SYSTEMS

Number of Instruction Hours: 5 Course Code: 13CB313

Subject Description:
This course presents the introduction to embedded systems, Devices and Buses for
Device Networks, Program modeling concepts, Inter – process communication &
Synchronization of processes, Tasks and threads.

Goal:
To enable the students learns the embedded systems concepts and fundamentals.

Objectives:
On Successful completion of the course the students should have:
Understood the RTOS concepts.
Understood the Embedded software Development

UNIT – I
Hardware Fundamentals: Terminology, Gates, Timing diagram, Memory Advanced hardware
fundamentals: Microprocessor, busses, DMA, Interrupts, built ins on microprocessor

UNIT – II
Interrupts: Microprocessor Architecture, Interrupt basics, the shared data problem-interrupt latency
Software architectures: Round robin- round robin with Interrupts – Function – Queue scheduling
architecture – real time Operating system architecture.

UNIT – III
Introduction to real time OS: Task and task states-tasks and data, semaphores and shared data
More OS Services: Message queries, mail boxes and pipes-timer functions- Events- Memory Management-
Interrupt Routines in an RTOS Environment.

UNIT – IV
Basic Design Using Real Time Operating System: Overview- Principles – Encapsulating Semaphores and
Queues-Hard real time Scheduling
Embedded Software Development Tools: Host and Target Machines-Linked Locators for embedded
software-getting embedded software into target system.

UNIT – V
Debugging techniques: Testing on your host machine- Instruction set simulators- The asset Macro – Using
laboratory Tools
Case Studies: An example of Program Structure, Screen Display, Library Functions, Source Code.
TEXT BOOK
1. AN EMBEDDED SOFTWARE PRIMER, DAVID E SIMON, PEARSON EDUCATION, LOW
PRICE EDITION.
UNIT – I (CHAPTER 2,3) UNIT – II (CHAPTER 4,5)
UNIT – III (CHAPTER 6,7) UNIT – IV (CHAPTER 8,9)
UNIT – V (CHAPTER 10)

REFERENCE BOOK
1. EMBEDDED SYSTEM- ARCHITECTURE, PROGRAMMING AND DESIGN, RAJ KAMAL,
TATA MCGRAW HILL PUBLISHERS, SECOND REPRINT 2004.
BCA 2013-16 Page 17 of 17

SUPPORTIVE COURSE [ III YEAR]

MOBILE COMMUNICATION

Number of Instruction Hours: 5 Course Code: 13CB313

Subject Description - This Course presents the Wireless Mobile Communications.

Goals - To enable the students to learn the fundamentals of Wireless Transmission.

Objective
On successful completion of the course the students should have:
Understood the wireless communication principles, wireless networking and wireless
standards.

UNIT I :

Introduction : Application – a short history of wireless communication. Wireless transmission :

Frequencies for radio transmission – signals – antennas – signal propagation – multiplexing.

UNIT II :

Medium access control : Motivation for a specialized MAC – SDMA – FDMA – TDMA – CDMA .
Telecommunications systems : GSM .

UNIT III :

Satellite systems : History - applications – basics. Broadcast systems: overview - cyclical repetition of
data – digital audio broadcasting – digital video broadcasting – convergence of broadcasting and mobile
communications.

UNIT IV :

Wireless LAN – infrared vs radio transmission infrastructure and ad-hoc network - HIPERLAN – blue
tooth.

UNIT V :

Mobile network layer – mobile IP – dynamic host configuration protocol – mobile transport layer –
traditional TCP.

TEXT BOOK :
JOHEN H. SCHILLER “ MOBILE COMMUNICATIONS” second edition, pearson education – 2004.

REFERENCE:
LING, “MOBILE COMPUTING”, SPRINGER VERLAG

Dr.G.BOOPATHI
Chairman,
Board of Studies - Computer Applications (UG),
S N R Sons College (Autonomous),
Coimbatore-6.