Bachelor

achelor of Computer Applications

pplications
(BCA) Degree Programme
COURSE CURRICULUM & SYLLABUS
(Effective from the Academic Year 2017-2018)
2017

DEPARTMENT OF COMPUTER APPLICATIONS

GOVERNMENT
ERNMENT ARTS COLLEGE
(AUTONOMOUS)
SALEM-7

1
GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7
BACHELOR OF COMPUTER APPLICATIONS (BCA)

Course Structure under CBCS

(For Candidates admitted from the Academic Year 2017 – 2018 onwards)

SEMESTER SYSTEM WITH INTERNAL ASSESSMENT

REGULATIONS

1. CRITERIA FOR ADMISSION

A Candidate who has passed higher Secondary Examination with Mathematics or Business
mathematics or Computer Science as one of the subjects under Higher Secondary Board of
Examination, TamilNadu, or as per norms set by the Government of Tamil Nadu are
permitted to appear and qualify for the BCA degree examination of this autonomous college
offering a course of study of three academic years.

2. DURATION OF THE COURSE

The course for the degree of Bachelor of Computer Applications shall consist of three
academic years divided into six semesters. Each semester consist of 90 working days.

3. PROGRAMME OBJECTIVES
The objectives of BCA degree programme are as given below:
• To maintain high educational standards and quality through CBCS system
• To create interest in teaching-learning process and to improve thorough
understanding
• To enhance students skills, potential, multi-level talent and knowledge
• To train latest, up-to-date technologies for the industrial need
• To attain high academic quality and educational performance
• To increase the student’s productivity and to make the student employable

4. COURSE OF STUDY
The Course of Study shall comprise instruction in the following subjects according to the
syllabus and books prescribed from time to time.

2
 SEMESTER I

Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17FTL01 Language – I 6 - 3 25 75 100
2 17FEL01 English – I 6 - 3 25 75 100
3 17UCA01 Foundations of Computers 5 - 4 25 75 100
Practical – I: Office
4 17UCAP1 - 3 4 40 60 100
Automation Lab
Allied – I Paper – I:
5 17AMT01 6 - 4 25 75 100
Mathematics – I
Allied – I Paper – II:
6 17AMT02 Mathematics – II 3 - - - - -
(Extended to Semester - II )
7 17UVABE Value Based Education 1 - 2 25 75 100
TOTAL 27 3 20 165 435 600

SEMESTER II
Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17FTL02 Language – II 6 - 3 25 75 100
2 17FEL02 English – II 6 - 3 25 75 100
3 17UCA02 Programming in C 5 - 4 25 75 100
Practical – II: C Programming
4 17UCAP2 - 3 4 40 60 100
lab
Allied – I Paper – II:
5 17AMT02 Mathematics – II 3 - 3 25 75 100
(Extended from Semester - I )
Allied – I Paper – III:
6 17AMT03 6 - 3 25 75 100
Mathematics – III
7 17UENST Environmental Studies 1 - 2 25 75 100
TOTAL 27 3 22 190 510 700

3
 SEMESTER III
Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17UCA03 Data Structures 5 - 4 25 75 100
2 17UCA04 Computer Architecture 5 - 4 25 75 100
Object Oriented Programming
3 17UCA05 5 - 4 25 75 100
with C++
Allied – II Paper-I:
4 17AST03 6 - 3 25 75 100
Mathematical Statistics – I
Allied – II Practical(Extended
5 17ASTP2 - 3 - - - -
to IV Semester)
Practical – III: OOP & Data
6 17UCAP3 - 3 4 40 60 100
Structures using C++ Lab
7 17UCAN1 Non Major Elective Course – I 2 - 2 25 75 100
Skill Based Elective – I:
8 17UCAS1 Practical – Image Editing - 1 2 40 60 100
Packages
TOTAL 23 7 23 205 495 700

SEMESTER IV
Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17UCA06 Visual Basic 5 - 4 25 75 100
2 17UCA07 Operating Systems 5 - 4 25 75 100
Relational Database
3 17UCA08 5 - 4 25 75 100
Management Systems
Allied – II Paper – II:
4 17AST04 6 - 3 25 75 100
Mathematical Statistics – II
Allied – II Practical(Extended
5 17ASTP2 - 3 3 40 60 100
from III Semester)
Practical –IV : Visual Basic &
6 17UCAP4 - 3 4 40 60 100
Oracle Lab
Non Major Elective
7 17UCAN2 2 - 2 25 75 100
Course – II
Skill Based Elective – II:
8 17UCAS2 Practical – Animation and - 1 2 40 60 100
Video Editing Tools
TOTAL 23 7 26 245 555 800

1 17UEXAT Extension Activity - - 1 - - 100

4
 SEMESTER V

Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17UCA09 Software Engineering 5 - 4 25 75 100
2 17UCA10 Programming with Java 6 - 4 25 75 100
3 17UCA11 Computer Networks 6 - 4 25 75 100
4 17UCAM1 Major Based Elective – I 6 - 3 25 75 100
Practical – V: Java
5 17UCAP5 - 4 4 40 60 100
Programming Lab
Skill Based Elective – III:
6 17UCAS3 Practical –Web - 2 2 40 60 100
Programming Lab – I
Skill Based Elective – IV:
7 17UCAS4 Career Development - 1 2 40 60 100
Practical – I
TOTAL 23 7 23 220 480 700

SEMESTER VI

Hours
Marks
Course
S. Course Name Credits
Code
No. Lecture Lab
IA SE Max
1 17UCA12 Web Programming 5 - 4 25 75 100
2 17UCA13 C#.Net Programming 6 - 4 25 75 100
3 17UCAM2 Major Based Elective – II 5 - 3 25 75 100
4 17UCAM3 Major Based Elective – III 5 - 3 25 75 100
Practical – VI:
5 17UCAP6 Programming in C#.Net - 3 4 40 60 100
Lab
Practical – VII: Software
6 17UCAP7 - 3 3 40 60 100
Development
Skill Based Elective –
7 17UCAS5 V:Practical –Web - 2 2 40 60 100
Programming Lab – II
Skill Based Elective – VI:
8 17UCAS6 Career Development - 1 2 40 60 100
Practical – II
TOTAL 21 9 25 260 540 800
Total Credits = 140
Total Marks = 4400

5
 A. List of Major Based Elective (MBE) Subjects
Elective- I
Part Sem. Course Code Course Name
A. Client Server Technology
III V 17UCAM1 B. Multimedia Systems
C. Management Information Systems

Elective- II
Part Sem. Course Code Course Name
A. System Analysis and Design
III VI 17UCAM2 B. Big Data and Analytics
C. E-Commerce

Elective- III
Part Sem. Course Code Course Name
A. Unix
III VI 17UCAM3 B. Android Programming
C. Introduction to Data Mining & Warehousing

B. List of Skill Based Elective (SBE) Courses

Hours
Marks
Course
Part Sem. Course Name Credits
Code Lecture Lab IA SE Max

Skill Based Elective – I:

III 17UCAS1 Practical – Image Editing - 2 2 25 75 100
Packages
Skill Based Elective – II:
IV 17UCAS2 Practical – Animation and - 2 2 25 75 100
Video Editing Tools
Skill Based Elective – III:
V 17UCAS3 Practical –Web - 2 2 25 75 100
IV Programming Lab – I
Skill Based Elective – IV:
V 17UCAS4 Career Development - 1 2 25 75 100
Practical – I
Skill Based Elective – V:
VI 17UCAS5 Practical –Web - 2 2 25 75 100
Programming Lab – II
Skill Based Elective – VI:
VI 17UCAS6 Career Development - 1 2 25 75 100
Practical – II
6
C. List of Non Major Elective Course (NMEC) Subjects
Non Major Elective Course (NMEC) subjects are the extra disciplinary subjects offered
by one Department to other major department students in each Semester for the second year of
the programme. The following are the NMEC Subjects offered:

Marks
Course Lect.
Part Sem. Course Name Credit
Code Hours
IA SA Total

NMEC-I Fundamental Computer

III 17UCAN1 2 2 25 75 100
IV Applications

IV 17UCAN2 NMEC – II Principles of Internet 2 2 25 75 100

5. EXAMINATION SYSTEM
The Examination system consists of Internal Assessment (IA) and Semester Examination (SE).
IA Marks for Theory paper: Attendance (5) +Assignment (10) +IA Test (10) = 25 Marks

IA Marks for Practical Paper: Attendance (10) +Observation (15) +IA Test (15) = 40 Marks

Passing minimum for a UG Student in both IA and SE is 40%. If a student is failed in IA,
he/she has to attain a overall passing minimum through SE. At any cost of time, IA is not
assessed twice for a student.

a. IA Test for Theory Subjects

In order to award 10 marks for IA test component, two common internal assessment tests on
each subject will be conducted for every 2½ Units of the syllabus of which the average of best

two scores will be taken into account. If a candidate is absent for the IA Test, retest may be
conducted. If a student is failed in IA Test, he/she has to obtain the lost marks in IA Test
through semester examination. The cumulative total of IA and SE is taken into account for
getting pass mark.

b. Attendance for Theory Subjects

Percentage of
Below 75% 75%-79% 80%-84% 85%-89% 90%-94% 95%-100%
Attendance
Marks for
0 Mark 1 Mark 2 Marks 3 Marks 4 Marks 5 Marks
Theory

7
 Attendance for Practical Subjects
Percentage of 75.0%- 77.6%- 80.1%- 82.6%- 85.1%-
Below 75%
Attendance 77.5% 80.0% 82.5% 85.0% 87.5%
Marks for
0 Mark 1 Mark 2 Marks 3 Marks 4 Marks 5 Marks
Practical
87.6%- 90.1%- 92.6%- 95.1%- 97.6%-
Percentage of Attendance
90.0% 92.5% 95.0% 97.5% 100%
Marks for Practical 6 Mark 7 Marks 8 Marks 9 Marks 10 Marks

• If a student has attained 65-74% of attendance, he pays a condonation fee and he is allowed
to write the semester examination in the same semester itself.
• If a student has attained 50-64% of attendance, he is not allowed to write the examination in
the same semester. He can reappear in the next semester.
• If a student has attained Below 50% of attendance, he comes under REDO category. He has
to redo the semester for attaining attendance percentage and he can appear, if the attendance
% is satisfactory. Otherwise the same rules given above are again applicable. Without
writing one semester examination, a student in REDO category is not allowed to write for
the next semester examination as per the revised Periyar University Regulation for REDO
category.

c. Assignment for Theory Subjects

In order to award 5 marks for the assignment component, three assignments on each subject
will be given for the student of which the average of best two scores will be considered as IA.
Assignments are not given on Book based. Assignment includes not only writing but also
Brainstorming Activity, Interactive sessions, Questionaire/Quiz, Programming,
Calculations/drawing, and Surfing in the Net, etc. Atleast one assignment for each subject
should be composed apart from the syllabus.

d. Observation for Practical Subjects

During the regular practical hours, the student has to complete one exercise provided in the
Lab Cycle of the syllabus. Periodically the student was observed in the Lab and 10 marks are
awarded for each exercise. For Late completion, 5marks are awarded. Finally the cumulative
total is converted for 15 marks for the observation component of Practical Internal
Assessment.

8
e. Semester Examination for Theory and Practical Subjects
Semester theory examination shall be conducted for three hours duration to each paper for
75Marks at the end of each semester. The Semester practical examination shall also be
conducted for 60 Marks at the end of each semester by experimenting two Lab exercises from
the Lab Cycle to be solved. The passing minimum for theory and practical during semester
examination is 30 and 24 Marks respectively.

The candidate failing in any subject(s) will be permitted to appear for each failed subject(s) in
the subsequent examination. The semester exam question papers are 100% externally set by
the Question Paper Setters. The marks are also evaluated completely by 100% external
examiners to enforce high academic quality.

6. QUESTION PAPER PATTERN

a. For Theory Max. Marks: 75
Time: 3 Hours Passing Min: 30
PART – A: 10 X 2 = 20
(Answer all Questions)
(Two Questions from each unit)

PART- B: 5 X 5 = 25
(Answer all Questions)
(Two Questions from each unit with Internal Choice)

PART –C: 3X 10 = 30
(Answer any Three Questions)
(One Question from each unit, Answer any three Out of Five Questions)

b. For Practical
Time: 3 Hours Max. Marks : 60
Practical : 50
Record : 10
One / Two compulsory Problem(s) to be solved within 3 hours

9
c. Distribution of the Marks
Practical:
Flowchart/Algorithm/Procedure. - 20%
Writing the program in the main answer book - 30%
List, test and debug the program - 30%
Printing the correct output - 20%
(Marks may be proportionately reduced for the error committed in each of the above)

d. Passing Minimum
A candidate shall be declared to have passed the examination if the candidate secures not less
than 40% of the marks in semester examination in each course or practical. The candidate
should get a minimum of 40% marks in SE i.e., a minimum of 30 marks out of 75 in SE in
theory courses. No passing Minimum marks for IA. For practical courses, the distribution of
marks will be IA 40, Practical 60(Practical 50+ Record 10). The candidate should get a
minimum of 24 marks out of 60 marks in practical examinations.
The practical mark 50 and the record mark 10 will be taken together as 60 marks for Practical
examinations. No passing minimum for record note book. However submission of record note
books is a must in the practical examinations.

e. Classification Of Successful Candidates

The performance of the student is indicated by letter Grades and the corresponding Grade
Point (GP), Grade Point Average (GPA) and Cumulative Grade Point Average (CGPA).

Range of Marks * Grade Points Letter Grade Description

90-100 9.0-10.0 O Outstanding

80-89 8.0-8.9 D+ Excellent
75-79 7.5-7.9 D Distinction
70-74 7.0-7.4 A+ Very Good
60-69 6.0-6.9 A Good
50-59 5.0-5.9 B Average
40-49 4.0-4.9 C Satisfactory
0-39 0.0 U Re-Appear
ABSENT 0.0 AAA ABSENT

10
A student is deemed to have completed a course successfully and earned the appropriate credit,
only if, the candidate earned a grade of C and above. RA denotes the candidate should Re-
Appear the Course again.

Formula for GPA & CGPA

n n

∑ CiGPi ∑ CiGPi
i =1
i =1
GPA = n
CGPA = n

∑ Ci
i =1
∑ Ci
i =1
Where,
Ci - is the credits assigned to the course
GPi - is the point corresponding to the grade obtained for each course
n - is number of all courses successfully cleared during the particular
semester
in the case of GPA and during all the semesters in the case of CGPA

Sum of the Multiplication of Grade Points by the Credits of the Courses in a

Semester
GPA =
Sum of the credits of the courses in a Semester

Sum of the Multiplication of Grade Points by the Credits of the Courses

CGPA =
Sum of the credits of the courses

Classification
CGPA 9 and above 1 Class with Distinction

CGPA Between 7 and 8.9 I Class

CGPA Between 5 and 6.9 II Class

Note:
The above classification shall be given for
• Overall performance including Non –Major Electives and Skill based courses
• For Performance in the Part III only.

f. Maximum Duration for the Completion of the UG Programme

11
The maximum duration for completion of the UG Programme shall not exceed twelve
semesters i.e. 6years from the date of admission.

g. Commencement of this Regulation

These regulations shall take effect from the academic year 2017-2018 i.e., for students who are
admitted to the first year of the course during the academic year 2017-2018 and thereafter.

h. Transitory Provision
Candidates who were admitted to the UG course of study before 2017-2018 shall not be
permitted to appear for the examinations under these regulations. This syllabus is effective
from the Academic Year 2017-2018 to 2019-2020 (for 3 years). But if a student is failed to
clear all his papers for the degree programme within six semesters, then he can reappear for
another six semesters using the same syllabus. Otherwise If he is not able to complete his
papers within 12 semesters, then he has to reappear for a new syllabus put into effect at that
timing.

12
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – I

CORE COURSE - I : FOUNDATIONS OF COMPUTERS

COURSE CODE : 17UCA01

Course Objectives:
• To understand the basic concepts of computer organization.
• To impart the knowledge in the field of number system.
• To impart the knowledge about the various components of a computer.
• To understand the relationship between Hardware and Software.

UNIT-I
Introduction - Characteristics of computers - Classification of Computers - The Computer
Generations - Basic Computer organization.

UNIT-II
Number System: Binary, Octal, Hexadecimal, Conversions. Computer Codes: BCD code-
EBCDIC-ASCII. Computer Arithmetic: Binary-Binary arithmetic: Addition – Subtraction
– Multiplication - Division. Logic Gates: AND, OR, NOT, NAND, NOT - Logic Circuits -
Half Adder - Full Adder.

UNIT-III
Input-Output devices: Input devices: Keyboard - point and draw devices - data scanning
devices – digitizer - electronic card reader - voice recognition devices - vision I/P system.
Output Devices: Monitors – Printers-Screen Image Projector - Voice Response System -
primary storage - Secondary Storage devices – Sequential and direct access devices:
Magnetic tape, Magnetic disk, Optical disk

13
UNIT-IV
Computer Software: What is Software? - Relationship between Hardware and Software -
Types of software - Planning the computer Program: What is an Algorithm? - Flowcharts:
What is a Flowchart? – Uses - Symbols - Levels of flowcharts - Flowcharting Rules -
Advantages and Disadvantages of flowcharts -. Computer Languages: Machine Language -
Assembly Language - High level language – Compiler – Linker - Interpreter.

UNIT-V
Operating Systems: What is an Operating System? - Functions of OS - Some Popular OS -
Application Software packages: Word Processing package – Spreadsheet package -
Graphic Package. Internet: Definition – Services - Uses of internet. Multimedia: What is
Multimedia? - Multimedia Components - Multimedia Applications.

Course Outcomes:
Upon Completion of the course, the students will be able to
• Demonstrate the characteristics, evolution and classification of Computers.
• State typical provisions of computer codes and Computer Arithmetic.
• Explain the needs of hardware and software required for a computation task.
• Demonstrate the use of Operating system.

TEXT BOOK
1. Pradeep K.Sinha Priti Sinha, “Computer Fundamentals”, BPB Publications, Third
Edition, 2003.

REFERENCE BOOKS
1. Alexis Leon, Mathew’s Leon, “Fundamentals of Computer Science and Communication
Engineering”,Vikas Publishing House,New Delhi,1998.
2. MalavinoLeach , “Digital Principles & Applications”, TMH,Edition.1991.
3. J.P.Hayes, “Computer Organization and Architecture”, TMH, Second Edition , 1988.

14
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – I

COURSE PRACTICAL– I : OFFICE AUTOMATION LAB

COURSE CODE : 17UCAP1

MS-WORD
1. Text Manipulation:
• Write a paragraph about your Institution
• Change the font size and type
• Spell check
• Perform Alignment and justification of Text
2. Bio data Preparation:
• Prepare a Bio-data with name, age, gender, date of birth, address with pincode, email
id, mobile number, adhaar number.
• Add a photograph
• Add qualification details as a table
• Add skillset with numbering and highlight the important one.
3. Find and Replace:
• Create a News Paper format document.
• Write a passage with three paragraphs about any topic for about 200 words
• Find and Replace some text
• Convert some text to Numbered and Bulleted points
• Create Footers and Headers.
4. Tables and Manipulation:
• Create an Application form for college admission
• Create a table for entering student data
• Insert and Delete Data, Columns and Rows
• Create a mark sheet with text and table combination. Add photograph to the mark
sheet.
• Convert some table content to text and text to table in the mark sheet after mark sheet
preparation.
5. Mail Merge:
• Prepare an invitation to organize a technical symposium in your department.
15
 • Invite your friends from other colleges to participate in the event.
• Prepare at least five letters. Import data from excel sheet.
MS-EXCEL
6. Data sorting-Ascending and Descending (both numbers and alphabets)
Employee Pay Bill preparation.
7. Drawing Graphs for student performance class-wise for a department.
MS-POWERPOINT
8. Create 5 Slide presentation and do the following with different animation effects:
• Inserting Pictures
• Copying picture and text from previous slide
• Slide with two column content
• Slide with pictures and text
9. Create a PowerPoint presentation of college admission process with 4 slides. Slides are
with a background theme set. The slides are for the following content:
• Welcome slide
• Admission announcements
• Documents required for admission
• Steps of procedure for admission as a flowchart using flowchart shapes.
10. Create a slide show presentation to display percentage of marks in each semester for all
students.
• Use bar chart (X-axis: Semester, Y-axis: % marks).
• Use different presentation template different transition effect for each slide.
MS-ACCESS
11. Create a table and sort the records as follows :
• Ascending order of a field
• Descending order of a field
• Sort using more than one fields
• Set necessary keys to avoid repeated information in Access.
12. Create the following for the database with more than one tables:
• Two Reports and Two Queries

16
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – II

CORE COURSE - II : PROGRAMMING IN C

COURSE CODE : 17UCA02

Course Objectives:
• To understand computer programming design and its role in problem solving.
• To understand and develop well-structured programs using C language.
• To get exposed to the pre-processor directives and file processing techniques of C.
• To help students to understand the implementation of C language.
UNIT- I
Problem Solving: Design Strategy – Using the Algorithms – Simple Algorithms: Exchanging
the values of two variables – Counting – Sum of a set of integers – Factorial – Fibonacci
sequence - Flow chart – Flow chart Symbols. Overview of C: History of C – Basic structure of
C programs – Executing a ‘C’ program - Developing a C program: Program design – Program
coding – Common programming errors - Constants - Variables and Data types – Operators and
Expressions.

UNIT- II
Decision making and Branching: Introduction – Simple if statement - if-else statement -
nesting if - nesting of if-else statement, else-if ladder, Switch statement?: operator - go to
statement. Decision making and looping: Introduction – While statement – Do statement – For
statement – jumps in loops.

UNIT- III
Arrays: Introduction – One dimensional Arrays – Two dimensional Arrays – Multi-
dimensional Arrays – Dynamic Arrays. Character Arrays and Strings: Introduction –
Declaring and initializing string variables – String handling functions. User-defined functions:
Introduction – Elements of user-defined functions.

UNIT- IV

Managing input and output operations: Reading a character – Writing a character - Structures
and Unions - Pointers.

17
UNIT- V
File management in C: Defining and opening a file – closing a file – I/O operations on files –
Random access to files – Command line arguments. The preprocessor: Introduction – Macro
substitution – File inclusion – compiler control directive.
Course Outcomes:
At the end of the course students will be able to
• Write a C program that uses pointers, structures and files.
• Implement any problem using C language.
• Identify the output of a C program without actually executing it.

TEXT BOOK
1. E. Balagurusamy, “Programming in ANSI C”, McGraw Hill Education, New Delhi, 8th
edition 2017.

REFERENCE BOOKS
1. R.Rajarama, P.Chitra, “Problem Solving using C”, Scitech Publications, Chennai 2001.
2. Yeshvant P Kanitkar, “Let us C", BPB Publications, 10th edition, 2011.
3. S. Thamaraiselvi and R. Murugesh, “C for All”, Anuradha publications, Chennai 2011.
4. PVN. Varalakshmi, “Projects using C”, Scitech publications (India) pvt.Ltd., Chennai 2001.

18
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – II

COURSE PRACTICAL - II : C PROGRAMMING LAB

COURSE CODE : 17UCAP2

LIST OF LAB EXERCISES

1. Write a program to print the multiplication table.

2. Write a program to find the greatest among 3 numbers.
3. Write a program to print ‘n’ Fibonacci series.
4. Write a program to generate ‘n’ prime numbers.
5. Write a program to reverse the given five digit number.
6. Write a program to check whether the given word is palindrome or not palindrome.
7. Write a program to find the smallest and biggest number in an array using pointers.
8. Write a program that compares two given dates. To store date use a structure that
contains three members namely day, month and year.
9. Write a program to find the factorial value of the given number using recursive function.
10. Write a file program to read a list of words from a file. Sort the words in alphabetical
order and display the sorted list of words.

19
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

CORE COURSE - III : DATA STRUCTURES

COURSE CODE : 17UCA03

Course Objectives:
• To Strengthen the ability to identify and apply the suitable data structure for the given
real world problem.
• To teach efficient storage mechanisms of data for an easy access.
• To design and implement various basic data structures.
• To develop application using data structures.

UNIT - I
Data Structures: Definition – Concept of Data Structure - Overview of Data structure – Arrays
Definition – One Dimensional Array: Operations(Concepts only) – Two Dimension Array –
Row major & Column major order – Pointer Arrays – Linked Lists : Definition – Single Linked
List – Operation on a Single Linked List (Concepts Only) - Double linked list: operation on a
Doubly links list(Concepts Only) - Sparse Matrix.

UNIT-II
Stack: Definition - Representation of Stack – Operations of Stacks – Application of Stack -
Evaluation of Arithmetic Expressions – INFIX to POSTFIX conversion – Tower of Hanoi
Problem. Queue: Definition – Representation of Queue – Various Queue structures – Circular
Queue – DE Queue – Priority Queue – Application of Queue –Round Robin Algorithm.

UNIT - III
Trees: Basic Terminologies – Definition and Concepts – Binary Tree Representation –
Operations on Binary Trees – Binary Tree Traversal – Types of Binary Tree: Expression -
Binary Search Tree - Heap tree - Conversion of Forest tree to Binary tree.

UNIT - IV
Graphs : Definition & terminology representation of graphs – Graph Traversals- Depth First
Search – Breadth First Search – Applications of Graph Structures – Shortest Path Problems :
Dijkstra’s Algorithm.

20
UNIT - V
Sorting Techniques: Insertion – Selection-Bubble-Quick - Heap – Merge. Searching
Technique: Linear Search – Binary Search - Comparison of Linear & Binary Search.

Course Outcomes:
At the end of the course students will be able to
• Use appropriate linear and non-linear data structures like stacks, queues and linked list
for a problem.
• Handle operations like searching, insertion, deletion, traversing mechanism on various
data structures.
• Students will be able to apply concepts learnt in various domains like DBMS, Compiler
construction.

TEXT BOOK
1. D. Samanta, “Classic Data Structures”, PHI Learning, Second Edition, New Delhi, 2011.

REFERENCE BOOKS
1. Aprita Gopal, “Magnifying Data Structures”, First Edition , PHI Learning, New Delhi
2010.
2. Horowitz, S. Sahni, and S. Rajasekaran, Computer Algorithms, Galgotia Pub. Pvt. Ltd.,
1998.

21
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

CORE COURSE - IV : COMPUTER ARCHITECTURE

COURSE CODE : 17UCA04

Course Objectives:

• To understand the representation and operation of binary data inside the digital
computer.
• To introduce different algorithms used in the design of ALU
• To introduce different I/O organization mechanisms and modes of data transfer from
I/O subsystem to CPU.
• To introduce various parts of a system memory hierarchy.
UNIT - I
Data Representation: Data Types – Complements - Fixed point and Floating point
representation - other Binary Codes - Register transfer languages - Register Transfer - Bus
and Memory transfer.

UNIT - II
Arithmetic Unit: Introduction - Addition and subtraction of signed numbers –
Multiplication Algorithms – Division Algorithms - Floating point numbers and operations -
Decimal Arithmetic Unit - Decimal Arithmetic operations.

UNIT III
Basic Processing Unit: Fundamental concepts – Instruction Format – Addressing Modes –
Data transfer Manipulation – Program Control – RISC.

UNIT IV
Memory System: Basic concepts – Semiconductor RAMs - ROMs – Speed - size and cost –
Cache Memories - Performance consideration – Virtual memory - Memory Management
Requirements – Secondary storage.

22
 UNIT V
I/O Organization: I/O Interface - Asynchronous Data Transfer - Priority Interrupts – Direct
Memory Access - IOP - Serial communication.

Course Outcomes:
At the end of the course students will be able to
• Understand data representation at the machine level.
• Describe all components of computer system.
• Know the different ways of communicating with I/O devices and standard I/O interfaces.
• Describe the hierarchical memory system including cache memories and virtual memory.

TEXT BOOK
1. M. Morris Mano, “Computer System Architecture”, M. Morris Mano, Edition 3, Pearson
Publications, 2011.

REFERENCE BOOKS
1. Carl Hamacher, Zvonko Vranesic and Safwat Zaky, 5th Edition “Computer.
Organization”, McGraw-Hill, 2002.
2. William Stallings, “Computer Organization and Architecture – Designing for
Performance”, 6th Edition, Pearson Education, 2003.
3. David A.Patterson and John L.Hennessy, “Computer Organization and Design: The
hardware / software interface”, 2nd Edition, Morgan Kaufmann, 2002.
4. John P.Hayes, “Computer Architecture and Organization”, 3rd Edition, McGraw Hill,
1998.

23
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

CORE COURSE - V : OBJECT ORIENTED PROGRAMMING WITH C++

COURSE CODE : 17UCA05

Course Objectives:
• To get a clear understanding of object-oriented concepts.
• To study and implement class and object paradigm.
• To learn about function and operator overloading.
• To understand the different types of inheritance.

UNIT – I
Principles of Object-Oriented Programming: Object Oriented Paradigm – Basic Concepts of
Object Oriented Programming - Benefits of OOP – Applications of OOP – Object Oriented
Languages. Tokens, Expression and Control Structures: Tokens – Keywords – Identifiers and
Constants – Data types – Constants – Variables – Operators – Expressions – Control Structure.

UNIT – II
Functions : Prototyping – Call by Reference – Return by Reference – Inline Functions –
Default Arguments – const Arguments – Function Overloading – Friend and Virtual Functions.
Classes and Objects: Class – Member Functions – Arrays with in a Class – Memory
Allocation for Objects – Static data members – Static member functions.

UNIT – III
Constructors and Destructors: Constructors – Parameterized Constructors – Constructors with
default arguments. Operator Overloading: Definition - Overloading Unary Operators –
Overloading Binary Operators. Inheritance: Extending Classes – Derived Classes – Single
Inheritance – Multilevel Inheritance – Multiple Inheritance – Hierarchical Inheritance – Hybrid
Inheritance – Virtual Base Classes – Abstract Classes.

24
UNIT – IV
Virtual Functions and Polymorphism: Pointers – Pointers to Objects – this Pointer – Pointers
to Derived Classes – Virtual Functions – Pure Virtual Functions. Managing console I/O
Operations: C++ Streams – C++ Stream Classes – Unformatted I/O and Formatted I/O
Operations – Managing Output with Manipulators.

UNIT – V
Working with Files: Classes for File Stream Operations – Opening and Closing a File –
Detecting end-of-file – File Pointers and their Manipulators – Sequential I/O Operations –
Updating a File – Error Handling during - File Operations – Command Line Arguments

Course Outcomes:
At the end of the course students will be able to
• Gain the basic knowledge on Object Oriented concepts.
• Ability to develop applications using Object Oriented Programming Concepts.
• Ability to implement features of object oriented programming to solve real world
problems.

TEXT BOOK
1. E.Balagurusamy,“Object Oriented Programming with C++”, Sixth Edition, McGraw

Hill Publication , 2013.

REFERENCE BOOKS
1. Herbert Schildt, "C++ The Complete Reference", Tata McGraw Hill Edition, 2003.
2. Bjarne Stroustrup, "The C++ Programming Language", 3rd Edition, Addison Wesley,
2000 .
3. Ravichandran, Programming With C++,TMH, 1995.

25
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

COURSE PRACTICAL - III : OOP & DATA STRUCTURES USING C++ LAB

COURSE CODE : 17UCAP3

LIST OF LAB EXERCISES

1. Write a Program to implement Classes and Objects.

2. Write a Program to implement Function Overloading.
3. Write a Program to implement Inheritance.
4. Write a program to implement Polymorphism.
5. Write a program to implement Operator Overloading.
6. Write a Program to find the maximum and minimum element in an array.
7. Write a Program to Perform Stack Operations using Arrays.
8. Write a Program to perform Queue operations using Arrays.
9. Write a program to perform Polynomial addition using linked list.
10. Write a program to arrange the given list using Insertion sort.

26
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

SKILL BASED ELECTIVE-I : PRACTICAL -IMAGE EDITING PACKAGES

COURSE CODE : 17UCAS1

LIST OF LAB EXERCISES

1. Create a Text with Text effects.

2. Create a Passport Size Photo.

3. Create a Birthday Greeting Card and use Marquee tool for moving the text.

4. Import a image and apply Blending, Blurring options.

5. Create a text with Fire Effect.

6. Import an Image and Display the image using Glass Display.

7. Import a Plant Image and impose Water drop effect.

8. Create a Text, Image and use i. Reflection Effect ii. Rainbow Effect

27
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

CORE COURSE - VI : VISUAL BASIC

COURSE CODE : 17UCA06

Course Objectives:
• To design, develop and test application in Visual Basic.
• To understand Visual Basic’s mouse events and Dialog boxes.
• To study and implement multiple objects and control arrays.
• To learn the concepts of ODBC and OLE.
UNIT - I
Getting Started with VB6: Programming Environment - Working with Forms - Developing an
application – Variables - Data types and Modules - Procedures and Control structures – Arrays.
Working with Controls: Creating and using controls - Working with control arrays.

UNIT - II
Menus, Mouse events and Dialog boxes: Mouse events - Dialog boxes - MDI and Flex grid -
MDI - Using the Flex grid control.

UNIT - III
ODBC and Data Access Objects: Data Access Options – ODBC - Remote data objects.
ActiveX EXE and ActiveX DLL: Introduction - Creating an ActiveX EXE Component -
Creating ActiveX DLL Component.

UNIT - IV
Object Linking and Embedding: OLE fundamentals - Using OLE Container Control - Using
OLE Automation objects - OLE Drag and Drop. File and File System Control: File System
Controls - Accessing Files.

UNIT - V
Additional controls in VB: sstab control - Setting properties at runtime - Adding controls to tab
- List control - Tabstrip control - MSFlexgrid control - Why ADO? - Establishing a reference -
Crystal and Data reports .

28
Course Outcomes:
At the end of the course students will be able to
• Create a program using the VB development environment.
• Use sequential looping & control logic in programs.
• Develop program menus, dialog boxes.
• Program printed output with the graphics object.

TEXT BOOKS
1.”Visual Basic 6.0 Programming”, Content Development Group, TMH, 8th reprint, 2007.
(Unit I to Unit IV)
2. Mohammed Azam,”Programming with Visual Basic 6.0”, Vikas Publishing House,
Fourth Reprint, 2006. (Unit V)

REFERENCE BOOKS
1. Peter Norton’s & Michael Groh, “Guide to Visual Basic 6”, Techmedia,1998.
2. Evangelos Petroustsos,” Mastering Visual Basic6.0”, BPB Publication ,6th edition, 2009
3.” VISUAL BASIC 6 COMPLETE REFRENCE “,TMH, 2010.

29
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

CORE COURSE - VII : OPERATING SYSTEMS

COURSE CODE : 17UCA07

Course Objectives:
• To understand the basic concepts and functions of operating system.
• To understand the principles of OS and Deadlocks.
• To understand the various operating system components like process management, I/O
management.
• To learn the various memory and Information management schemes.
UNIT – I
Introduction – Operating System – History – process concepts: process states – process state
transitions – Process Control Block – operations – Interrupt processing – Asynchronous
concurrent processes.

UNIT – II
Deadlock and Indefinite postponement: - Introduction – Examples – Necessary conditions –
Major areas of deadlock research – Deadlock prevention – avoidance – deletion - recovery.

UNIT – III
Real storage:-Storage organization – Management - Hierarchy – Storage management
strategies – contiguous vs. noncontiguous storage allocation – Fixed variable partition -
Multiprogramming – virtual storage organization. Virtual storage management: Virtual
storage management strategies – page replacement strategies.

UNIT – IV
Job and processor scheduling:- Introduction – Scheduling objectives – preemptive vs. non-
preemptive scheduling – priorities – Deadline scheduling – FIFO – RR – Quantum size – SJF –
SRT – HRN – Multilevel Feedback Queues – fair share.

30
UNIT – V
File and database systems: Introduction – File system – File system functions – File
organization– File descriptor – Database systems – Database models. Case study: MS – DOS.

Course Outcomes:
At the end of the course, the student will be able to:
• Explain the operating system components and services.
• Design deadlock, prevention and avoidance algorithms.
• Able to demonstrate the mapping between the physical memory and virtual memory.
• Able to understand file handling concepts in OS perspective.
• Design various Scheduling algorithms.

TEXT BOOK:
1. H. M. Deital, “Operating Systems”, Pearson Edition, Third Edition,2009.

REFERENCE BOOKS:
1. William Stallings, “Operating Systems – Internals & Design Principles”, Prentice – Hall
of India P.Ltd, New Delhi. 5th Edition,,2006.
2. Silberschatz and Galvin, “Operating System Concepts”, 6th Edition, John Wiley & Sons,
Inc., 2004.

31
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

CORE COURSE - VIII : RELATIONAL DATABASE MANAGEMENT SYSTEMS

COURSE CODE : 17UCA08

Course Objectives:
• To understand the fundamentals of data models.
• To know the features and syntax of PL/SQL.
• To make the students to understand relational database design.
• To understand the concepts of Database Triggers in PL/SQL
UNIT I
Introduction: Database system Applications – Purpose of Database systems – View of Data –
Data Models – Database Languages – Database Users and Administrators – Transaction
Management – Database Architecture. E-R Model: Basic Concepts – Constraints – Keys – E-R
Diagram – Weak Entity Set.

UNIT II
Relational Model : Structure of Relations Databases – Modifications of the Database – Views –
The Tuple Relational Calculus - The Domain Relational Calculus. SQL: Basic Structure – Set
Operations – Aggregate Functions – Null Values – Views.

UNIT III
Relational Database Design: First Normal Form – Functional Dependencies – Decomposition –
Boyce – Codd Normal Form- Third Normal Form – Fourth Normal Form.

UNIT IV
PL/SQL: Introduction to PL/SQL– PL/SQL. Essentials: Block Structure – Data types –
Operators – Attributes – PL/SQL Expressions. PL/SQL Built-in Functions.

UNIT V
PL/SQL Control Structure– Implementing SQL Operations in PL/SQL – Cursors in PL/SQL –
Working with Database Triggers in PL/SQL

32
Course Outcomes:
At the end of the course, the student will be able to:
• Understand the basic concepts of the database and data models.
• Design a database using ER diagrams and map ER into Relations and normalize the
Relations
• Develop a simple database applications using normalization.
• Understand the basic features of PL/SQL triggers

TEXT BOOK:
1. Abraham SilberSchatz, Henry F.Korth, S.Sudarshan, “Database System Concepts “,
McGraw- Hill International Edition, 6TH Edition-2011.(Unit – I, II, III)
2.“Oracle PL/SQL Programming in Simple steps”, Kongent Solutions Inc, dreamtech
press,2008.(Unit – IV, V)

REFERENCE BOOKS:
1. Nilesh Shah, “Database Systems Using Oracle” 2nd edition, PHI,2005.
2. Alexis Leon, Mathews Leon, “Essentials of Database Managements Systems”, Vijay
Nicole imprints PVT LTD, 2006.

33
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

COURSE PRACTICAL - IV : VISUAL BASIC & ORACLE LAB

COURSE CODE : 17UCAP4

LIST OF LAB EXERCISES

Visual Basic Lab

1. Write a simple VB program to accept a number as input and convert them into
a) Binary b) Octal c) Hexadecimal
2. Write a simple VB program to add the items to list box with user input and move the
selected item to combo box one by one.
3. Write a simple VB program to develop a calculator with basic operation.
4. Write a simple program to prepare a Questionnaire.
5. Write a VB Program to develop a menu driven program. Add a MDI window in the form and
arrange them in the cascading/horizontal style using menus (Create a menu to add form,
arrange) (Menu Item 1). Also change the form color using the menu in another menu item
(Menu Item 2).
6. Develop a simple project for Student Database Management System using VB as front end
and MsAcces as back end and generate Data Report.
Oracle Lab

1. Simple Queries using DML Commands

2. Built-in Functions
3. Set operations
4. Nested Queries and Join Queries
5. Create a database Trigger Operation
6. PL/SQL program to find the total and average of 6 subjects and display the grade sheet

34
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

SKILL BASED ELECTIVE - II : PRACTICAL - ANIMATION AND VIDEO EDITING

TOOLS

COURSE CODE : 17UCAS2

LIST OF LAB EXERCISES

1. Create a Simple Animation for i. Sun rise ii. Cartoon face with eye blinking.
2. Create a Music Shape Animation.
3. Create an animation using Guided Motion Tween i.Butter fly flying ii. Ball Bouncing
4. Create an animation for Stick Man Walking.
5. Create a Birthday Cake with Candle Lighting.
6. Create an Animation using Masking i. Text ii. Image
7. Create an Animation with Action Script.

35
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

CORE COURSE –IX : SOFTWARE ENGINEERING

COURSE CODE : 17UCA09

Course Objectives:

• To understand the phases in a software project

• To understand the fundamental concept of requirements engineering an analysis
modeling
• To know the major consideration for enterprise integration and development
• To learn various testing and maintenance measures.

UNIT I

Introduction to Software Engineering: The Evolving role of software - Software process -

Software Process Models – The Prototyping Model – RAD Model. Evolutionary Software
Process Models: Incremental Model – Spiral Model – WINWIN Spiral Model – Concurrent
Development Model – Agile Software Development.

UNIT II
Analysis concepts and principles: Requirement Analysis – Requirements Elicitation for
software – Analysis Principles – Software Prototyping – Specification. Analysis Modeling:
Data Modeling – Mechanics of Structured Analysis – The Data Dictionary – Metrics for the
Analysis Model.

UNIT III
Software Design and Software Engineering - Design concepts and Principles - The Design
process – Design Principles –Design concepts – Effective Modular Design – The Design Model.
Architectural Design: Software Architecture – Data Design.

UNIT IV
Software Testing Techniques – Software Testing Fundamentals – White Box Testing – Basic
Path Testing – Control Structure Testing – Black Box Testing. Software Testing Strategies:
Strategic Issues – Unit Testing – Integration Testing – Validation Testing – System Testing.

36
UNIT V
Software Quality Assurance: Quality Concepts – The Quality Movement – Software Quality
Assurance – Software Reviews – Formal Technical Reviews – Formal Approaches to SQA –
Statistical Software Quality Assurance – Software Reliability – Mistake Proofing for Software –
The SQA Plan.
Course Outcomes:
Upon completion of this course, students will be able to:
• Identify the key activity in managing a software project
• Apply requirements engineering and analysis in modeling
• Apply statement procedure for software design and deployment
• Compare and contrast the various testing and maintenance

TEXT BOOK:

1. Roger S.Pressman, “Software Engineering”, 5th edition TMH Publishers,2001.

REFERENCE BOOKS:
1. Richard Fairly, “Software Engineering Concepts”, TMGH, 1997
2. Ian Sommerville, “Software Engineering”, Seventh Edition, Pearson Education, 2005.

37
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

CORE COURSE - X : PROGRAMMING WITH JAVA

COURSE CODE : 17UCA10

Course Objectives:
• Understood the concepts of Object-Oriented Programming.
• Differentiate C++ and Java.
• Learn about to use classes and objects.
• Know about Interfaces and Packages.
• Understood the file handling operations and database connectivity using JDBC.
UNIT I
Fundamentals of Object-Oriented Programming: Basic Concepts of Object-Oriented
Programming – Benefits of Object-Oriented Programming – Application of Object-Oriented
Programming. Java Evolution: History – Features – How Java differs from C and C++ – Java
and Internet – Java and www –Web Browsers. Overview of Java: simple Java program –
Structure – Java Tokens – Statements – Java Virtual Machine.
UNIT II
Constants, Variables, Data Types - Operators and Expressions – Decision Making and
Branching: if, if...else, nested if, switch, ? : Operator - Decision Making and Looping: while,
do, for – Jumps in Loops - Labeled Loops . Classes, Objects and Methods: Defining a class –
Adding variables, methods – Creating objects – Accessing Class Members– Constructors –
Methods overloading – static members – Nesting of Methods – Inheritance – Overriding
methods – final Variables and methods – Final classes – finalizer methods – Abstract methods
and classes – visibility control.
UNIT III
Arrays, Strings and Vectors: Arrays – One Dimensional Arrays – Creating an array – Two
Dimensional Arrays – Strings – Vectors – Wrapper Classes. Interfaces: Multiple Inheritance:
Defining interfaces – Extending interfaces – implementing interfaces – Accessing interface
variable. Packages: 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: Creating Threads – Extending the Thread Class
38
– Stopping and Blocking a Thread – Life Cycle of a Thread – Using Thread methods – Thread
Exceptions – Thread Priority – Synchronization – Implementing the ‘Runnable’ Interface.

UNIT IV
Managing Errors and Exceptions: 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: Applets and Application
programs Difference - 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 – Passing parameters to Applets – Displaying Numerical values –
Getting input from the user,
UNIT V
Managing Input / Output Files in Java : Concepts of Streams- Stream Classes – Byte Stream
classes – Character stream classes – Using streams – I/O Classes – File Class – I/O exceptions –
Creation of files – Reading / Writing characters, Byte-Handling Primitive data Types – Random
Access Files. Accessing Databases with JDBC: Introduction-Relational databases- A books
Database-SQL- Setting up a Java DB Database- Manipulating Databases
with JDBC- RowSet Interface -Prepared Statements- Stored procedure- Transaction processing.
.
Course Outcomes:
At the end of the successful course completion the students could be able to
• Develop applications using OOPs
• Handle Memory Management using Java.
• Create packages and handle exception during runtime.
• Develop web based programs using Java Applets.
• Accessing database in java using JDBC.
TEXT BOOK:
1. E. Balagurusamy, “Programming with JAVA – A Primer”, Fifth Edition, TATA
McGraw-Hill Education Private Limited, New Delhi, 2015.
2. H.M. Deitel, P.J.Deitel, “Java – How to Program”, Tenth Edition, Pearson Education
Pvt. Ltd, Delhi, 2015.

REFERENCE BOOKS:
1. Herbert Schildt ,“Java:The Complete Reference”, Ninth Edition, TATA Mc Graw Hill
Publishing Company Limited, New Delhi, 2014.
39
2. Ken Arnold, James Gosling, “The Java Programming Language”, Java Series Third
Edition, Pearson,2009
3. Bart Baesens, Aimée Backiel, Seppe vanden Broucke, ”Beginning Java Programming:
The Object-Oriented Approach”, Wrox, First edition,2015.

WEB REFERENCES:
1. https://www.youtube.com/playlist?list=PLS1QulWo1RIbfTjQvTdj8Y6yyq4R7g-Al
2. https://www.tutorialspoint.com/video_tutorials/java_programming/PIJ-T

40
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

CORE COURSE - XI : COMPUTER NETWORKS

COURSE CODE : 17UCA11

Course Objectives:

• To understand the terminology and concepts of the OSI reference model and the TCP‐IP
reference model.
• To understand wired and wireless networking concepts.
• To be familiar with Routing and Congestion control Algorithms.
• To understand the data link & Application layer protocols.
• To have a Knowledge on Computer Network security.
UNIT-I
Network Hardware: LAN – WAN – MAN – Wireless Networks. Network Software: Protocol
Hierarchies – Design Issues for the Layers – Connection-oriented and connectionless services –
Service Primitives – Reference Models: OSI Reference Model –TCP/IP reference Model
UNIT-II
PHYSICAL LAYER - Guided Transmission Media : Twisted Pair – Coaxial Cable – Fiber
Optics. Wireless Transmission: Electromagnetic Spectrum – Radio Transmission –Microwave
Transmission – Infrared and Millimeter Waves – Light Waves. Communication Satellites:
Geostationary, Medium-Earth Orbit, Low Earth-orbit Satellites

UNIT-III
DATA-LINK LAYER: Design Issues - Error Detection and correction – Elementary Data-link
Protocols: Stop and wait Protocol - Sliding Window Protocols -. MEDIUM-ACCESS
CONTROL SUB LAYER: Multiple Access Protocols:-ALOHA – Carrier Sense Multiple
Access Protocols – Wireless LANs : 802.11 Protocol stack – Services.- Bluetooth: Bluetooth
Architecture

UNIT-IV
NETWORK LAYER: Routing algorithms: The Optimality Principle – Shortest Path Routing –
Distance Vector Routing – Congestion Control Algorithms: General Principles of Congestion
Control – Congestion Prevention Policies – Congestion Control in Virtual-Circuit Subnets.

41
TRANSPORT LAYER: Elements of Transport Protocols :Addressing – Internet Transport
Protocols: TCP segment header – Introduction to UDP

UNIT-V
APPLICATION LAYER: DNS name space – E-mail.: Architecture and services- User Agent
NETWORK SECURITY: Cryptography - Introduction- Substitution ciphers-Transposition
Ciphers – Symmetric Key Algorithms: DES(The Data Encryption Standard) – Public Key
Algorithms: RSA – Digital Signatures: Symmetric Key Signatures – Public Key Signatures
Course Outcomes:
At the end of the course, the students will be able to:

• Know the terms and concepts used in Computer Networks.

• Familiar with the protocols used in various layers of Network.
• Describe the Algorithms used in Network layer.
• Aware of the importance of Network Security.
TEXT BOOKS:
1. Andrew S. Tanenbaum, “Computer Networks”, 4th edition, PHI, 2003 (UNIT-I:1.2-1.4
UNIT- II:2.2-2.4 UNIT-III:4.2-4.6 UNIT-IV:5.2,5.3,6.2,6.5 UNIT-V:7.1,7.2,8.1-8.4)

REFERENCE BOOKS:
1. Achyut Godbole, “Data Communication and Networks” TMH, 2007.
2. Uyless Black,“Computer Networks Protocols, Standards and Interfaces”, 2nd
edition, PHI,1993.

42
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

COURSE PRACTICAL – V : JAVA PROGRAMMING LAB

COURSE CODE : 17UCAP5

LIST OF LAB EXERCISES

1. Write a Java Applications to extract a portion of a character string and print the extracted
string.
2. Write a Java Program to implement the concept of multiple inheritance using Interfaces.
3. Write a Java Program to create an Exception called array index out of bounds and throw
the exception.
4. Write a Java Program to implement the concept of multithreading with the use of any
three multiplication tables and assign three different priorities to them.
5. Write a Java Program to draw several shapes in the created windows.
6. Write a Java Program to demonstrate the Multiple Selection List-box.
7. Write a Java Program to create Menu Bars and pull down menus.
8. Write a Java Program to create frames which respond to the mouse clicks. For each
events with mouse such as mouse up, mouse down, etc., the corresponding message to be
displayed.
9. Write a Java Program which open an existing file and append text to that file.
10. Write a java program that can create and access database using JDBC.

43
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

SKILL BASED ELECTIVE – III : PRACTICAL – WEB PROGRAMMING LAB - I

COURSE CODE : 17UCAS3

LIST OF LAB EXERCISES

1. Write HTML code to develop a web page for giving details of your name, age, address.
It contains the different background and foreground color with different attribute of Font
tags like italic, bold, underline etc. and give suitable heading style.
2. Write HTML code to create a WebPages that contains list of Images arranged in table at
its left hand side of the page when user clicks on the image; it should open another web
page that displays the zoomed image with details of that image.
3. Create a web Page using HREF tag having the attribute ALINK, VLINK etc. When user
clicks on the link, it should go to the bottom of the page.
4. Write a HTML code to create a web page of pink color and display moving message in
red color. It should show an ordered list of name of your five friends and unordered list
of any five your hobbies.
5. Create a HTML document containing a nested list in table showing the content page of
any book.
6. Write a HTML program to reload the page which contains an image that should reload
automatically for every 5 seconds.
7. Demonstrate a program for Image Mapping.
8. Create railway reservation form using all input types with submit button aligned inside a
table in HTML.
9. Create a web page which should divide a page into two equal frames & again it should
divide the right frame into 3 Frames.
10. Create a html program that import an External Cascading Style Sheet (CSS) whereas the
style for the html program is defined in CSS file.

44
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

SKILL BASED ELECTIVE – IV : CAREER DEVELOPMENT PRACTICAL - I

COURSE CODE : 17UCAS4

LIST OF LAB EXERCISES

1. Simple Math functions using R

2. Programs to read and getting data into R
3. Working with named objects in R
i) Viewing loaded all named objects.
ii) Viewing only matching named objects
iii) Removing named objects
4. i)Conversion of between number and text data
ii) Structure of data items
a) Vector
b) Data Frames
c) Matrix Objects
d) List Objects
5. Working with History Commands in R.
6. Create range of graphs to summarize your data and results

45
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

CORE COURSE - XII : WEB PROGRAMMING

COURSE CODE : 17UCA12

Course objectives:
• A course focusing on the development of dynamic content and applications to facilitate
information distribution.
• Significant time is spent on intermediate to advanced programming and scripting.
• Students are required to plan, design and implement a major project.
• Topics include intranets, networks, the World Wide Web, development languages .

UNIT- I
Introduction to Internet : Client Server model - Domain name-World Wide Web.
Introduction to HTML: History - HTML Tags - HTML Documents - Header section-Body
section-Headings-Link Documents using Anchor Tag- Formatting Characters –Font Tag-Images
and Pictures-Listing-Tables in HTML.

UNIT - II
Frames and Forms: Frameset Definition-Frame Definition-Nested Framesets-HTML forms-
Elements of a Form. Java Script: Data Types-Variables-Operators-Conditional Statements-
Array Objects-Date Objects-String Objects.

UNIT - III
Objects and Events: Document Object Model-The Document Object-Image Object-Forms and
Elements-Browser object-Submit event and Data Validation-ParseInt() Function-ParseFloat()
function-Recursive Functions.
UNIT - IV
PHP: Introduction to PHP-Static websites vs. Dynamic websites-Dynamic content from
Databases-Client-side scripting vs. Server-side scripting-PHP Scripting Fundamentals-Print
statement-Code Blocks-Primitive Data Types-Constants and Variables-Arrays-Functions.

46
UNIT -V
MySQL: Introduction to MySQL Database –SQL-Basic Elements of SQL-Data Types-
Variables and Literals. Working with Database and Tables: Creating Databases-Types of SQL
Statements (DDL,DML,DQL). Querying Tables in the Databases: Retrieving Rows from
Table-Overview of Clauses-Overview of Operators. Working with Databases and forms:
PHP’s Database APIs-Simple SQL Queries via PHP

Course Outcomes:
Upon completion of this course, students will be able to:
• Demonstrate understanding of (X)HTML programming.
• Create and compile advanced dynamic web projects using client - JQuery(Javascript) and
server – PHP technology.
• Demonstrate understanding of database applications with MySQL.
• Show understanding of the logic behind advanced web applications.
• Demonstrate an understanding of Content Management Systems Course contents .

TEXT BOOK:
1. C.Xavier, “Web Technology & Design”, First Edition, New Age International
Publishers,2007.
2. Steve Seuhring, Tim Converse, Joyce Park, “PHP6 and MySQL 6 Bible”, Wiley India

Pvt. Ltd, New Delhi,2009.

REFERENCE BOOKS:
1. Chris Bates ,”Web Programming, Building Internet Applications”, 2nd edition, Wiley
Dreamtech, 2006.
2. N.P.Gopalan,J.Akilandeswari,”Web Technology – A Developer’s Perspective,2nd
Edition, PHI, 2014.
WEB LINKS:
https://www.cs.uct.ac.za/mit_notes/web_programming.html
http://www.webstepbook.com/supplements/slides/ch01-internet.pdf
https://www.tutorialspoint.com/mysql/mysql_tutorial.pdf
https://downloads.mysql.com/docs/apis-php-en.pdf
https://www.tutorialspoint.com/mysql/mysql_pdf_version.htm

47
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

CORE COURSE – XIII : C#.NET PROGRAMMING

COURSE CODE : 17UCA13

Course Objectives:
• To understand .Net Framework fundamentals and basic concepts
• To learn C#.Net programming for console, window and web applications
• To know how to establish database connectivity using ADO.Net
UNIT I
Origin of .Net Technology - Features - .Net framework – Common Language Runtime –
C# : Introduction - Simple C# program-Namespaces - Program Structure - Program Coading
Style- Literals-Variables-Data Types-Scope of Variables-Boxing and Unboxing
UNIT II
Decision Making and Branching : Decision Making with if Statement-Simple if
Statement-The if-else Statement- Decision Making and Looping : While Statement- do
Statement - For Statement- Methods :Declaring Methods - Main method - Invoking Methods -
Pass by Value - Pass by Reference.
UNIT III
Arrays : One Dimensional Arrays - Two Dimensional Arrays - Manipulating Strings :
Creating Strings - String Methods - Structures and Enumerations: Structures - Enumerations -
Classes and Objects : Defining a Class - Adding Variables - Adding Methods - Constructors -
Inheritance and Polymorphism : Classical Inheritance - Multilevel Inheritance.
UNIT IV
Console I/O Operations : Console Class - Console Input - Console Output - Formatted
Output - Errors and Exceptions: What is Debugging - Types of Errors - Exceptions - Syntax of
Exception handling Code - Exception Hierarchy
UNIT V
Application Development on .Net - Building Windows Applications – Creating a simple
window form – Creating a window forms application using Tree view control- Accessing Data
with ADO.NET – Working with Data Bound Controls.

48
Course Outcomes:
Upon completion of this course, students will be able to:
• To develop and implement a simple application in C#.Net
• To develop a project in C#.Net for a real-time and live application
• To understand the concept of front end and back end using ADO.NET

TEXT BOOKS:
1. E. Balagurusamy, “Programming in C#”, Tata McGraw-Hill, 2004.
2. J. Liberty, “Programming C#”, 2nd ed., O’Reilly, 2002.
REFERENCE BOOKS:
1. Herbert Schildt, “The Complete Reference: C#”, Tata McGraw-Hill, 2004.
2. Robinson et al, “Professional C#”, 2nd ed., Wrox Press, 2002.
3. Andrew Troelsen, “C# and the .NET Platform”, A! Press, 2003.
4. Thamarai Selvi, R. Murugesan, “A Textbook on C#”, Pearson Education, 2003.

49
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

COURSE PRACTICAL – VI : PROGRAMMING IN C#.NET LAB

COURSE CODE : 17UCAP6

LIST OF LAB EXERCISES

1. Write a C# Program to Print a Binary Triangle.

2. Write a C# Program to Display the Date in Various Formats
3. Write a C# Program to Display the ATM Transaction
4. Write a C# Program to Display Cost of a Rectangle Plot Using Inheritance
5. Write a C# Program to Find the Average Values of all the Array Elements
6. Write a C# Program to Generate the Mark sheet of the Student
7. Write a C# Program to Reverse a String without using Reverse Function
8. Build a Simple Windows Forms Application in C#.
9. Build windows forms Application to list out games using tree view control
10. Build a windows forms Application to get employee Details also perform Insert, delete
and update operations using ADO.Net

50
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

COURSE PRACTICAL – VII : SOFTWARE DEVELOPMENT LAB

COURSE CODE : 17UCAP7

LIST OF LAB EXERCISES

1. Develop the changes suggested by the examiner(s) with the following standard stepwise
procedures:

I – Back End Design

1) Requirements Analysis
2) Conceptual Database Design
3) Logical Database Design
4) Schema Refinement
5) Physical Database Design
6) Security Design
II – Front End design
1) Requirements gathering
2) System Analysis
3) System Design
4) Testing
5) Implementation

2. Demonstration and presentation of the Project with atleast 5 queries to be asked to the
candidate related to the following subjects:
(a) Title of the proposed system with its self explanatory justification
(b) System study and feasibility study
(c) DFD/Class diagram and ER diagram
(d) Designing of tables, interface and modules
(d) System specification, development difficulties, and testing
(e) Advantages, limitations and future enhancements

Software Development Lab is introduced in the curriculum with motive of imparting

practical knowledge in the phases of software development and Software engineering.
Hence, the faculty In-charge for this practical continuously assesses the development
process of the software developed by each student. In the Semester Examinations the
External and Internal Examiners would assess the quality of the software with various
parameters like Problem definition, System study, System analysis, System specification,
System design, Coding, Testing, and Implementation, etc.

51
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

SKILL BASED ELECTIVE –V : PRACTICAL – WEB PROGRAMMING LAB - II

COURSE CODE : 17UCAS5

LIST OF LAB EXERCISES

1. Write a JavaScript program to display the current day and time in the following format.
Today is : Friday. Current time is : 4 PM : 50 : 22
2. Write a JavaScript program to print the contents of the current window.
3. Write a JavaScript to create a form for Student Information to find Total, Average and
Grade.
4. Write a JavaScript code block, which checks the contents entered in a form ‘s Text
element. If the text entered is in lower case then convert to Upper case.
5. Write a JavaScript program to rotate the string 'WELCOME' in right direction by
periodically removing one letter from the end of the string and attaching it to the front.
6. Write a JavaScript program to determine whether a given year is a leap year in the
Gregorian calendar.
7. Write a JavaScript program to find 1st January be a Sunday between 2014 and 2050.
8. Write a JavaScript program to design a simple arithmetic calculator.
9. Write a PHP Program using Arrays.
10. Write a PHP Program to create a Login form with MySQL.

52
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

SKILL BASED ELECTIVE– VI : CAREER DEVELOPMENT PRACTICAL - II

COURSE CODE : 17UCAS6

LIST OF LAB EXERCISES

I. Written Communication Skill Development

1. Evaluation 1: Official/Professional Letter writing
2. Evaluation 2: Curriculum Vitae Preparation
3. Evaluation 3: General Essay Writing
4. Evaluation 4: Preparation of PowerPoint for Technical Paper Presentation
II. Oral Communication Skill Development
1. Evaluation 1: Ice Breaking Sessions to eliminate stage-fear
(Singing/Dancing/Mimicry/Mono-Acting)
2. Evaluation 2: Interactive Sessions for checking verbal Communication
(Giving a text message in a paper and ask the student to reproduce it after
reading)
3. Evaluation 3: Interactive Sessions for Non verbal Communication/Body Language
(Acting a sequence of speechless events and ask the student to reproduce it after
listening)
4. Evaluation 4: Two minutes General Essay Discussion to improve communication
skill
5. Evaluation 5: Spontaneous Two Minutes Talk to improve self-confidence
6. Evaluation 6: Group Discussion to check Leadership, role play, flexibility,
politeness and team work
7. Evaluation 7: Introduce yourself (Stage presentation)
8. Evaluation 8: Make Technical Interview – Questions from all subjects to evaluate
Knowledge, Stress management, Self Confidence, and Positive Attitude
9. Evaluation 9: Make HR Interview – Personal and GK questions to evaluate
Adaptability, Self development, Personality and Creativity

53
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

MAJOR BASED ELECTIVE – I : A. CLIENT SERVER TECHNOLOGY

COURSE CODE : 17UCAM1

Course Objectives:

• To know the basic concepts of Client/Server and Operating System services.

• To understand the fundamentals of SQL and Relational Database.
• To impart knowledge about Data Warehouses and Client/Server Transaction Processing.
• To understand the relationship between a CORBA Business Object and a Client/Server
Business Object.
• To make a study of Hypertext Era , Interactive Era, Distributed object Era.

UNIT - I
Client/server computing: Basic concepts of Client/Server – Characteristics – File Servers –
Database Servers – Transaction Servers – Groupware Servers - Object Servers – Web Server –
Fat Server or Fat Client – 2-Tier vs. 3-Tier – Client/Server Building Block. Clients, Servers and
Operating Systems - Base Services – Extended Services – Client Anatomy.

UNIT - II
NOS: NOS Middleware – RPC – MOM Middleware – MOM versus RPC. SQL Database
Servers: The Fundamentals of SQL and Relational Database – Server Architectures – Stored
Procedures –Triggers and Rules.

UNIT - III
Data Warehouses: OLTP – DSS – OLTP versus DSS – Data Warehouses – Elements –
Hierarchies – The mechanics of Data Replication- EIS/DSS. Client/Server Transaction
Processing: ACID properties – Transaction Models – TP Monitors.

UNIT - IV
Client/Server Groupware: Groupware – Components – CORBA: From ORBs to Business
Objects: Distributed objects, CORBA-style – OMGs OMA – CORBA object services. CORBA
Business Objects: cooperating Business Objects - Anatomy of a CORBA Business Object-
Anatomy of a Client/Server Business Object.

UNIT – V
54
Web Client/Server: The Hypertext Era - Evolution of the web-client/server web style -URL-
HTTP. Interactive Era: 3-Tier client/server web-style. CGI: server side of the web.
Distributed object Era: JAVA - The Mobile code system.

Course Outcomes:
Upon completion of this course, students will be able to:
• Differentiate the functions of server types and its building blocks.
• Describe about the Server Architectures, Stored Procedures, Triggers and Rules.
• Explain the data warehouse elements and the ACID properties of transaction processing.
• Demonstrate the groupware components.
• State the functions of web client/Server.

TEXT BOOK:
1. Robert Orfali, Dan Harkey and Jeri Edwards ,“The Essential Client/Server Survival
Guide”, Galgotia publications, Third Edition, 2013.

REFERENCE BOOKS:
1. Dawna Travis Dewire, “Client/Server Computing”, TMGH, 2003.
2. Patrick Smith, Steve Guenferich , “Client/Server Computing”, 2nd edition,PHI,1994.

55
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

MAJOR BASED ELECTIVE – I : B. MULTIMEDIA SYSTEMS

COURSE CODE : 17UCAM1

Course Objectives:
• To understand Global structure of multimedia.
• To learn the basic concepts of Computer Image Processing.
• To describe different multimedia data in digital formats.
• To understand the design principles used in multimedia productions.

UNIT I
Introduction - Branch Overlapping Aspects of Multimedia Content – Global Structure
Multimedia Literature- Multimedia – Media and Data Streams – Medium

UNIT II
Sound/Audio: Basic Sound Concepts – Music –Speech. Images and Graphics: Basic Concepts
– Computer Image Processing. Video and Animation: Basic Concepts – Television– Computer
Based Animation.

UNIT III
Data Compression: Storage Space – Coding Requirements – JPEG – MPEG – DVI - Optical
Storage Media - Computer Technology – Multimedia Operating System.

UNIT IV
Networking System: Layers - Protocols and Services – Networks - Metropolitan Area
Networks – WAN - Multimedia Communication System.

UNIT V
User Interfaces, Synchronization, Abstraction for Programming - Abstraction Levels –Libraries
– System Software – Toolkit – Higher Programming Languages. Multimedia Application:
Introduction – Media Population – Media Composition – Media Communication– Trends.

56
Course Outcomes:
Upon completion of this course, students will be able to:
• Describe the basic concept of multimedia information representation.
• Compare text, audio, image and video data.
• Determine appropriate software application to use multimedia
• Apply design principles used in multimedia productions

TEXT BOOKS:
1. Ralf Steinmetz &KlaraNahrstedt, “Multimedia Computing, Communications and
Applications”, Pearson Education,2009.
REFERENCE BOOKS:
1. Amarendra N Sinha, Arun D Udai, “Computer Graphics”, TMH, 2007.
2. Tay Vaughan, “Multimedia: Making it Work”, 7th edition, TMH, 2008.

57
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – V

MAJOR BASED ELECTIVE – I : C. MANAGEMENT INFORMATION SYSTEMS

COURSE CODE : 17UCAM1

Course Objectives:

• Understand the MIS Concepts and Role of MIS.

• Acquire the Knowledge of Decision Making.
• Know the Requirement and Development of MIS.
• Understand the Client/Server Architecture and Business Process Reengineering.

UNIT I
Introduction – Definition - MIS concepts – Role of Management Information System –
Role and importance of management – Process of Management: Planning – organizing –
Staffing – Coordinating and Directing – Controlling.

UNIT II
Decision Making: Concepts – Methods, Tools and Procedures - organizational Decision
marking – Information.

UNIT III
Development of MIS: Ascertaining, Determine the information requirement – Development
and implementation of the MIS – Management of Quality in the MIS – MIS Factors of
success and failure.

UNIT- IV
Decision support system – Enterprise management system.

UNIT V
Object-Oriented Technology (OOT) – Client/Server Architecture - Business Process Re-
Engineering (BPR).

58
Course Outcomes:
Upon completion of this course, students will be able to:
• Describe the Concept of MIS.
• Perform Planning, Organizing, Staffing, Coordinating, Directing and Controlling
• Carry out Decision Making
• Formulate Decision Support System and Enterprise Management System.
• Analyze the Object-Oriented Technology, Client/Server Architecture, Business
Process Reengineering.

TEXT BOOK:
1. W.S.Jawadekar , “Management Information System”, TMH 1998.

REFERENCE BOOKS:
1. James A.O.Brien, “Management information system”, TMH,1999.
2. Gordeon B.Davis margre the H.Olson, “MIS Conceptual Foundations Structure and
Development”, MGH, second edition,1982.
3. Robert G.Murdick, Joel E.Ross, Jame R Clagett, “Management information
system”, PHI, 2005.

59
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE - II : A. SYSTEM ANALYSIS AND DESIGN

COURSE CODE : 17UCAM2

Course Objectives:

• Know the roles and responsibilities of System Analyst.

• Understand Information requirements analysis.
• Prescribe the planning and investigation fundamentals.
• Aware of analysis, design and implementation steps.
• Recognize and appreciate the need for documentation for future continuance of the system
with maintenance and reviews.
Unit-I
The System in the Organization: Systems Concepts – System and the System Analyst – The
Business as a System –Information Systems. The System Analyst: Systems Life cycle – The
Data processing Department - The Role of Systems Analyst. Communication Skills: Problems
of Communication – Written Reports – Oral Communication – Standard Documentation.

Unit-II
System Planning: Approaches to System Development – User Involvement – Feasibility
Assessment. System Investigation: Objectives of Investigation – Methods of Investigation –
Recording the Investigation.

Unit-III
Logical System Design: Analyzing User Requirements: Design Objectives - Outline of Design
Outputs and Inputs – Data Dictionary – Processing Requirements – User System Specification.

Unit-IV
Physical Design of Computer Subsystem: File Design – Database Design – Output and Input
Design – Computer Procedure Design – System Security.Physical Design of Manual
Subsystem: Form Design – Dialogue Design – Code Design – Designing User Procedures.

Unit-V
System Implementation: Preparation for Implementation – Changeover- Maintenance and
Review. Project Documentation and Management: Project Reports – Project Management.

60
Course Outcomes:

At the end of the course, the students will be able to:

• Solve a wide range of problems related to the analysis, design and construction of
information systems
• Perform Analysis and Design of systems of small sizes
• Carryout Plan and undertake a major individual project
• Prepare and deliver coherent and structured verbal and written document.
• Analyze small applications from definition of the problem to documentation,
maintenance and review.

TEXT BOOK:
1. Lee and Lee, “Introducing the System Analysis and Design”, National Informatics
Centre.1982.

REFERENCE BOOKS:
1. Elias W. Awad, “System Analysis and Design”, Galgotia Publications, Second
Edition,,2005..
2. Jame A.Senn, “Analysis and Design of Information System”, TMGH,1989.
3. V.Rajaraman, “Analysis and Design of Information Systems”, PHI, Third Edition, 2011..

Web Resources:

1. http://www.systemanalysisanddesigns.com/
2. https://www.safaribooksonline.com/library/view/systems-analysis-
and/9781118037423/05_chapter001.html#ch001-sec002

61
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE – II : B. BIG DATA AND ANALYTICS

COURSE CODE : 17UCAM2

Course Objectives:

• To learn the basics concepts of Big Data and analytics.

• To become competent in recognizing challenges faced by applications dealing with
very large volumes of data.
• To be able to understand how Big Data impacts business intelligence, scientific
discovery, and our day-to-day life
• To understand Big data Analytics principles and techniques.
• To explore tools and practices for working with big data giving emphasis to Hadoop,
MongoDB and MapReduce.

UNIT I
Types of Digital data: Introduction - Classification of Digital data-Structured Data – Semi
structured data – Unstructured data – Introduction to Big Data: Characteristics – Evolution –
Challenges – What is Big data ?- Why Big data? – Traditional Business Intelligence versus Big
Data – A typical Data ware House Environment – A typical Hadoop Environment –
Coexistence of Big Data and Data Warehouse

UNIT II
Big Data Analytics : What is Big Data Analytics? -- What Big Data Analytics Isn’t? - Why
this sudden Hype Around Big Data Analytics? - Classification of Analytics - Greatest
Challenges that Prevent Business from Capitalizing Big Data - Top Challenges Facing Big Data
- Why Big Data Analytics Important? - Data Science - Data Scientist - Terminologies used in
Big Data Environments - Basically Available Soft State Eventual Consistency (BASE) - Open
source Analytics Tools

UNIT III
Big Data Technology Landscape: NOSQL : Introduction – Types of NoSQL databases –
Advantages of NOSQL - Comparison of SQL,NoSQL and New SQL - Hadoop: Features –
Key Advantages – versions –History - Hadoop Ecosystems – Hadoop Distributions –Hadoop
62
Overvire – Hadoop high level Architecture - Hadoop Versus SQL – Cloud based Hadoop
Solutions

UNIT IV
Hadoop Distributed file system: HDFS Daemons – Anatomy of File Read – Anatomy of File
Write – Replica Placement Strategy – Processing data with Hadoop –Introduction to
MongoDB: What is MongoDB?- Why MongoDB? – Terms used in RDBMS and MongoDB –
MongoDB Query Language – Aggregate Functions - MapReduce function

UNIT V
Introduction to Map Reduce Programming : Introduction – MapReduce Daemon – How does
MapReduce Function? - Mapper – Reducer – Combiner – Partitioner – Searching - Sorting –
Compression-MapReduce Example

Course Outcomes:
Upon Completion of the course, the students will be able to
• Identify the need for big data analytics for a domain
• Use Hadoop, MongoDB and Map Reduce Framework
• Apply big data analytics for a given problem
TEXT BOOK:

1. Seema Acharya, Subhasinin Chellappan, ”BIG DATA and ANALYTICS, Wiley

Publication, .2017
REFERENCE BOOKS
1. BIG DATA, Black BookTM , DreamTech Press, 2015 .
2. Frank J Ohlhorst, “Big Data Analytics: Turning Big Data into Big Money”, Wiley and
SAS Business Series, 2012.
3. Anand Rajaraman and Jeffrey David Ullman, Mining of Massive Datasets, Cambridge
University Press, 2012.

63
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE - II : C. E-COMMERCE

COURSE CODE : 17UCAM2

Course Objectives:

• To know the different types of E-Commerce.

• To learn the Protocols used in E-commerce.

• To understand EDI and EDIFACT.

• To have a knowledge on electronic payment systems..

UNIT I
E-commerce - Electronic Commerce – E-Commerce types – E-Commerce and world at the
large. E-Commerce Case studies: Intel, Amazon.

UNIT II
Electronic Mail – The X.400 Message handling system – Internet Addresses – Multipurpose
Internet Mail Extension – X.500 Directory Services – E-mail user agent.

UNIT III
EDI - Costs and benefits – Components of EDI Systems – EDI implementation issues –
EDIFACT – EDIFACT Message Structure.

UNIT IV
Cyber Security – Cyber Attacks – Hacking- SSL - Authentication and assurance of data integrity
– Cryptographic based solutions – Digital Signatures – VPN.

UNIT V
Electronic Payment Systems – payment gateway – internet banking – The SET Protocol – E-
cash – E-Cheque – Elements of electronic payments
Course Outcomes:
At the end of the course the students could be able to
• Identify the E-Commerce types.
• Familiar with all security protocols used in E-Commerce.
• Make Electronic payments easily

64
Text book:
1. Kamalesh K Bajaj ,Debjani Nag, “E-Commerce The Cutting Edge Of Business” 2nd
Edition,TMH,2000.
Reference Book:
1. Ravi Kalakota and Andrew B. Whinston, “Frontiers of E-commerce“ Pearson Education.
2nd Edition ,1996.

65
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE - III : A. UNIX

COURSE CODE : 17UCAM3

Course Objectives:
• To understand UNIX Architecture.
• To learn the basic set of commands and utilities in Linux/UNIX systems.
• To learn the important Linux/UNIX library functions and system calls.
• To understand the inner workings of UNIX-like operating systems.

UNIT I
Introduction : The Unix Operating System - The UNIX Architecture and Command
Usage: The UNIX Architecture – Features of UNIX – Locating commands – Internal and
External Commands – Command Structure – Man Browsing the Manual pages On-Line

UNIT II
General Purpose Utilities: cal, date, echo, printf, bc, script, who, email
basics,mailx,passwd,uname,tty,stty - The File System: The file – The parent child relationship
– pwd,cd,mkdir,rmdir – Absolute Pathnames - relative Pathnames – ls – The Unix file system –
Handling Ordinary files: cat,cp,rm,mv,more,file,wc,od,cmp,comm., diff, dos2unix and
unix2dos.

UNIT III
Basic File Attributes: Listing File Attributes – Listing Directory Attributes – File ownerships
– File permissions – chmod – Directory Permissions – changing File ownership - The vi Editor

UNIT IV
The Shell: The shell Interpretive Cycle – Pattern Matching - Escaping and Quoting –
Redirection – Pipes – Tee – Command Substitution – Shell variables -The Process: Process
Basics – ps – Mechanism of Process creation – Process states and Zombies – Running jobs in
background

66
UNIT V
Customizing the environment: The Shells – Environment variables -More file attributes :
Hard Links – symbolic Links. Find Simple filters: pr,head,tail,cut,paste,sort. Filters using
regular expressions: grep,sed - Essential Shell Programming: Shell Scripts – read- Using
Command Line Arguments – exit – Conditional execution - if – case – expr – while – for -
Looping with a List

Course Outcomes:
At the end of the course students will be able to
• Use all Internal and External commands in Linux environment
• Write simple shell scripts.
• Know the basics of process creation.
• Obtain a foundation for an advanced course in operating systems.

TEXT BOOK
1. Sumitabha Das, “ UNIX – Concepts and Applications”, 4thEditionTata McGraw Hill,
2006.

REFERENCE BOOKS
1. Behrouz A. Forouzan and Richard F. Gilberg, “UNIX and Shell Programming”,
Cengage
Learning, 2005.
2. M.G. Venkateshmurthy, “UNIX & Shell Programming”, Pearson Education, 2005.
3. Yashavant P. Kanetkar, “UNIX Shell Programming”, BPB Publications, 2010.

67
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE - III : B. ANDROID PROGRAMMING

COURSE CODE : 17UCAM3

COURSE OBJECTIVES
• To be aware of latest mobile application development using Android Programming
• To design and to develop simple Android applications for mobile users
• To implement a mobile apps using Android SDK, Eclipse and Java
UNIT I
Getting Started with Android: The Android Software Development Kit – Eclipse – Java -
Getting Everything Installed – Installing Eclipse – Installing the Android SDK - Configuring
Eclipse – Adding Android Plug-ins to Eclipse – Locating SDK – Creating an Emulator –
Working with Android Phone – Creating a new Android Project – Running a New Project –
Troubleshooting the Emulator. Exploring the Application Basics: The Files – The Manifest –
The Activity class - Watching the activity in action – Data Retention Methods – The Intent class
– Manifest Registration – Adding an Intent – Listening for Intents at runtime – The Application
class – Customizing Application – Accessing Application.

UNIT II
Creating User Interfaces: The Viewclass – Creating a View – Altering the UI at runtime –
Handling a few common tasks – Creating custom Views – Resource Management – Resource
Folder Oveerview- Values folder – Layout Folder – Drawable Folder – Layout Management –
The ViewGroup – The AbsoluteLayout – The LinearLayout – The RelativeLayout. Acquiring
Data: The main thread – Watch dogs – The AsyncTask – How to make it work – A few
important caveats – The IntentService – Declaring a Service – Fetching Images.

UNIT III
Adapters, ListViews and Lists: Two Pieces to each list – ListView – Adapter – A Main Menu
– Creating Menu Data – Creating ListActivity – Defining a Layout for ListActivity – Making a
Menu List Item – Creating and populating the ArrayAdapter – Reacting to ClickEvents –
Creating the MainLayoutView – Creating the ListActivity – Getting Twitter Data - Making a
Custom Adapter – Building ListViews – How do these objects interact?

68
The Way of the Service: What is a Service? – The Service LifeCycle – Keeping Service
running – Communication – Intent Based Communication – Binder Service Communication.

UNIT IV
Many Devices, One Application: Uncovering the secrets of the res/Folder – Layout Folders –
The Full Screen Define – Limited Access - The <use> tag – SDK Version number –Shared
Preferences and apply – Reflecting troubles away – API Levels. Movies and Music: Movies –
Adding a VideoView – Setting up for VideoView-Getting Media to play – Loading and Playing
Media – Music – MediaPlayer and State – Playing a sound - Longer-running Music Playback –
Binding to the Music Service – Finding the most recent track – Playing the audio in the service -
Cleanup - interruptions.

UNIT V
Determining Locations and Using Maps: Location Basics – The Sneaky shortcuts – Show the
Map – Getting the Library – Adding to the Menifest – Creating the MapActivity – Creating a
MapView. Tables, Fragments, and Action Bars: Fragments – The Lifecycle of a Fragment –
Creating a Fragment – Showig a Fragment – Providing Backward Compatibility – The Action
Bar – Showing the Action Bar – Adding elements to the ActionBar. Publishing Application:
Packaging and Versioning – Setting a minimum SDK Value – Exporting a signed Build –
Backing up KeyStore File – Submit Build.

Course Outcomes:
• To learn a new Programming Paradigm using Android for Mobile Apps Development
• To improve Student’s Job Opportunity and Employability in a recent trend in IT
• To create an opportunity for self thinking, self development and self employment
TEXT BOOK

1. Chris Haseman, “Creating Android Applications: Develop and Design”, Pearson

Education, South Asia, Indian Edition: Dorling Kindersley India Pvt. Ltd, Noida and
NewDelhi, First Impression, 2012.

REFERENCES
1. Wei-Meng Lee, ”Beginning Android 4 Application Development”, Wrox publications,
2012
2. Mark L Murphy, “Beginning Android”, Wiley India Pvt Ltd, 2011.
3. Sayed Y. Hashimi and Satya Komatineni, “Pro Android”, Wiley India Pvt Ltd, 2013.
4. Lauren Dercey and Shane Conder, “Android Wireless Application Development”,
Pearson Education, 2nd Edition, 2011.

69
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – VI

MAJOR BASED ELECTIVE - III : C. INTRODUCTION TO DATA MINING AND

WAREHOUSING

COURSE CODE : 17UCAM3

Course Objectives:

• To understand the concept of data mining and data warehousing.

• To know the various data mining techniques such as association rule mining,
classification and clustering techniques.
• To understand the characteristics of web and web mining.
• To have a knowledge on multidimensional data and OLAP operations.
UNIT I
Introduction: Data Mining Definition – Application - Data Mining Techniques - Data Mining
Case Studies: Aviation, Astrology, Mail Order- Future of Data Mining - Data Mining Software.
Association Rule Mining: Introduction – Basics – Apriori Algorithm.

UNIT II
Classification: Introduction- Decision tree –Building a Decision Tree - The Tree Induction
Algorithm – Split Algorithm based on Information Theory – Overfitting and Pruning - Decision
Tree Rules - Naïve Bayes Method – Estimation of Predictive Accuracy of Classification
Methods – Other Evaluation Criteria for Classification Methods – Classification Software.

UNIT III
Cluster Analysis: Cluster Analysis – Desired Features of Cluster Analysis - Types of Data –
Computing Distance - Types of Cluster Analysis Methods – Partitional Methods: K-Means
Method – Hierarchical Methods : Distance between clusters – Agglomerative Method –
Divisive Hierarchical Method – Density based Methods – Dealing with Large Databases –
Quality and Validity of Cluster Analysis Methods – Cluster Analysis Software.

UNIT IV
Web Data Mining: Introduction – Web Terminology and Characteristics – Web Content
Mining – Web Usage Mining – Web Structure Mining – Search Engines: Search Engines
Functionality - Search Engines Architecture – Ranking of Web Pages.

70
UNIT V
Data Warehousing: Introduction – Data Warehouses – Data Warehousing Design – Guidelines
for Data Warehousing Implementation – Data Warehouse Metadata.
Online Analytical Processing (OLAP): Introduction – Characteristics of OLAP System –
Multidimensional View and Data Cube – Data Cube Operations.

Course Outcomes:
At the end of this course, the students will be able to:
• Demonstrate need for data mining.
• List and comprehend the various data mining techniques.
• Apply association rule mining, classification and clustering techniques.
• Create multidimensional data and apply OLAP operations.

TEXT BOOK:
1. G.K. Gupta, “Introduction to Data Mining with Case Studies”, PHI, 2012.

REFERENCE BOOKS:
1. Arun K. Pujari, “Data Mining Techniques”, University Press (India) Limited,
Hyderabad, 2006.
2. Jiawei Han, MichelineKamber, Jian Pei, “Data Mining Concepts and Techniques”,
Morgan Kaufmann Publishers, Third Edition, 2012.
3. Dunham, “Data Mining – Introducing and Advanced Topics”, Pearson Education, New
Delhi, 2003.
Web Resources:
1. https://sites.google.com/a/cmrit.ac.in/data-mining/homework
2. http://www.rdatamining.com/resources/tools
3. http://glaros.dtc.umn.edu/gkhome/cluto/cluto/overview

71
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – III

NON MAJOR ELECTIVE COURSE - I : FUNDAMENTAL COMPUTER

APPLICATIONS
COURSE CODE : 17UCAN1
Course Objectives:
• Understand the components and functions of computer.
• To know the steps in creating professional word documents.
• Understand the needs and ways of spreadsheets, power point presentations using
Microsoft Office suite.
• Be aware of database creation and writing simple queries.
• Familiarize the steps in preparation of documents and presentations with office
automation
UNIT I
Fundamentals of Computers : Block Diagram of a Computer System, Introduction to various
units. Hardware: CPU, Memory, Input and Output devices, Auxiliary storage devices.
Software: System and Application Software, Utility packages.
UNIT II
Microsoft Word : Introduction to Microsoft Word - Working with Documents and the
Keyboard - Navigating Through a Word Document - Basic Text Editing - Text Formatting -
Paragraph Formatting - More Ways to Format Text and Paragraphs - Style Formatting - Page
Formatting – Templates - Working With Graphics and Pictures - Tables - Mail Merge - Printing.
UNIT III
Microsoft Excel : Introduction to MS Excel - Navigating Excel - Worksheets and Workbooks -
Entering Information into MS Excel - Introduction to Working with Cells, Rows, and Columns -
Formatting Data and Cells - Formatting Rows and Columns - Editing Cells, Rows, Columns, and
Worksheets - Introduction to Formulas and Calculations - Working with Formulas and Functions
- Maintaining Worksheets - The What-If Analysis - Adding Images and Graphics - Charts and
Diagrams - Printing Worksheets and Workbooks.

72
UNIT IV
Microsoft Powerpoint : Introduction - The Basics of Creating Presentations - Applying Themes
and Layouts to Slides - Working with Objects - Entering, Editing, and Formatting Text -
Working in Outline View - Inserting Pictures, Graphics, Shapes, and Other Things - Inserting
Tables into Presentations - Charts and SmartArt - Adding Sound and Video - Adding Transitions
and Animation - Master Slides - Printing and Running Slide Shows - Saving, Sharing, and
Exporting Presentations.
UNIT V
Microsoft Access: Menus in Microsoft Access - Create a Database - Describe databases and
design - Identify database objects - Create a Table - Adding Data - Create a Form - Modify a
Form - Create a Query - Modify a Query.
Course Outcomes:
On completion of the course, the students can:
• Demonstrate the components of computers.
• Prepare documents, reports and show charts from data.
• Prepare presentation slides with effects and animation.
• Create database and tables objects with SQL queries.
• Generate reports using Report Wizard.

TEXT BOOKS:

1. Sanders, D.H., "Computer Today ", Mc-Graw Hill, 1988.

2. Suresh K. Basandra, ―Computers Today, Galgotia Publications Pvt. Ltd.,2010.

REFERENCE BOOKS:
1. Sanjay Saxena, “MS Office 2007 in A Nutshell” , Vikas Publishing, First Edition, 2011.
2. SANJAY SAXENA, “Introduction to Information Technology”, Vikas Publishing, First
Edition,2003.
3. Raja Raman V., "Fundamental of Computers" (4th edition.), Prentice Hall of India, New
Delhi,2003.
4. B. Ram, ―Computer Fundamentalsǁ, New Age International Pvt. Ltd.,2000.
WEB RESOURCES:
1. https://www.microsoft.com/en-in/learning/training.aspx
2. https://ptgmedia.pearsoncmg.com/images/9780735669413/samplepages/9780735669413.pdf
3. https://www.gcflearnfree.org/subjects/office

73
 GOVERNMENT ARTS COLLEGE (AUTONOMOUS), SALEM-7.

BACHELOR OF COMPUTER APPLICATIONS (BCA)

SEMESTER – IV

NON MAJOR ELECTIVE COURSE – II : PRINCIPLES OF INTERNET

COURSE CODE : 17UCAN2
Course Objectives:
• To provide an overview of working principles of Internet.
• To understand and apply the fundamental core java, packages, database connectivity for
Computing.
• To enhance the knowledge to server side programming.
• To provide knowledge on Web related Functionalities.
UNIT – I
Introduction to the Internet – Basics of Networks – Topologies of Networks – Types of
networks.

UNIT – II
Basics of Internet – Address and Names for the Internet – Web Objects and Sites – E-mail –
World Wide Web.

UNIT – III
File Transfer – The Telnet – The Usenet – Internet Chat.

UNIT – IV
The Web Server – Web Browser – Microsoft Internet Explorer – Firewalls – Data Security.

UNIT – V
Art of creating a website – Hypertext and HTML – HTML Document Features – Document
Structuring Tags in HTML – Special Tags in HTML.

Course Outcomes:
• Able to explain understand the internet standards and recent web technologies like
Conferencing, newsgroup etc.
• Able to implement, compile, test and run HTML program,
• Able to describe the components and patterns that constitute a suitable architecture for a
web application using java servlets

74
TEXT BOOK:
1. Raj Kamal , “Internet and Web Technologies”, Mc GrawHill Education,2007.

REFERENCE BOOKS:
1. Joe krayank & Joe Habraken, “Internet 6 in 1”, Prentice Hall of India Private Limited,
New Delhi, 1998.
2. “Internet Complete”, BPB publications, New Delhi, 1998.

75