SRI VENKATESWARA UNIVERSITY :: TIRUPATI

BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

Semester Part Subject Hrs. Credits IA ES Total

FIRST YEAR

SEMESTER Fundamentals of Computers 4 4 25 75 100

PART II
I PC Software & Hardware Lab 3 2 25 75 100

SEMESTER Office Automation Tool 4 4 25 75 100

PART II
II MS Office Lab 3 2 25 75 100

SECOND YEAR

SEMESTER C -Programming 4 4 25 75 100

PART II
III C -Programming Lab 3 2 25 75 100
Computer Accounting With
4 4 25 75 100
SEMESTER Tally
PART II
IV Tally Lab 3 2 25 75 100

THIRD YEAR

Java Programming 4 4 25 75 100

SEMESTER Database fundamentals 4 4 25 75 100

PART II
V Oracle Lab &
Java Programming Lab 3 2 25 75 100

Web Technologies
4 4 25 75 100
VB.Net /
4 4 25 75 100
SEMESTER Programming PHP
PART II
VI Web Technologies
&
3 2 25 75 100
VB.Net Lab/
Programming PHP LAB
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

FUNDAMENTALS OF COMPUTERS
UNIT I
Introduction to computer:
What is Computer, Characteristics of Computers, Generations of
Computers, Classification of Computers, Basic Computer Organization,
Applications of Computers
Input and Output Devices:
Input Devices, Output Devices, Soft Copy Devices, Hard Copy Devices

UNIT II
Computer Memory and Processors:
Introduction, Memory Hierarchy, Processor Registers, Cache Memory,
Primary Memory, Secondary Storage Devices, Magnetic Tapes, Floppy
Disks, Hard Disks, Optical Disks, USB Flash Devices, Memory Cards,
Mass Storage Devices, Basic Processor Architecture

UNIT III
Computer Software
Introduction to Computer Software, Classification of Computer Software
System Software, Application Software, Firmware, Middleware, Acquiring
Computer Software, Design and Implementations of Correct, Efficient
and Maintainable Programs
Operating Systems
Introduction, Evolution of Operating Systems, Process Management,
Memory Management, File Management, Device Management, Security
Management, Command Interpreter, Popular Operating Systems
UNIT IV
Introduction to Algorithms and Programming Languages
Algorithm, Control Structures Used in Algorithms, Some More
Algorithms, Flowcharts, Pseudo code, Programming Languages,
Generations of Programming Languages, Categorization of High-Level
Languages, Some Popular High-Level Languages, Factors Affecting
Selection of Programming Language

UNIT V
The Internet
Internet, Internet Services, Types of Internet Connections, Internet
Security
Emerging Computer Technologies
Distributed Networking, Peer-to-peer computing

TEXT BOOKS :
1. Fundamentals Of Computers By Reema Thareja from Oxford
University Press
REFERENCE BOOKS :
1. Peter Norton, Introduction to Computers, 6th Edition , Tata McGraw –
Hill , 2008 .
2. Jacob Beckerman, How to Build a Computer 2014-15: Learn, Select
Parts, Assemble, and Install: A Step by Step Guide to Your First
Homebuilt.
3. Leon A and Leon M, Computers for Everyone, Leon Vikas , 2001 .
4. Turban E, Rainer R K , and Potter R E , Introduction to Information
Technology , John Wiley & Sons , 2000.
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

OFFICE AUTOMATION TOOL

UNIT I
Getting Started: Working with Microsoft Office 2007

UNIT II
Microsoft Word: Understanding Word Basics, Editing and Formatting
Text. Formatting Documents, Working with Graphic Objects.

UNIT III
Microsoft Excel: Understanding Excel Basics. Formatting and Editing
the Worksheet, Using Formulas and Functions, Working with Charts.

UNIT IV
Microsoft PowerPoint: Understanding PowerPoint Basics, Formatting
and Modifying Presentations, Delivering the Presentation.

UNIT V
Microsoft Access: Understanding Access Basics, Creating Forms and
Reports, Querying a Database.

Text book:
Microsoft Office 2007 Fundamentals By Laura Story, Dawna Walls

C - PROGRAMMING
UNIT – I
Introduction to C
Introduction, Structure of a C program, Writing the First C Program,Files
used in a C Program, Compiling and Executing C Programs, Using
Comments, Keywords, Identifiers, Basic Data Types in C, Variables,
Constants, Input/Output Statement in C, Operators in C
UNIT – II
Decision Control and Looping Statements
Introduction to Decision Control Statements, Conditional Branching
Statements, Iterative Statements, Nested Loops, Break and Continue
Statements, Goto Statement,
Functions
Introduction, Using Functions, Function Declaration / Function
Prototype, Function Definition, Function Call, Return Statement, Passing
Parameters to the Function, Scope of Variables, Storage Classes,
Recursive Functions, Types of Recursion, Recursion Versus Iteration
UNIT – III
Arrays
Introduction, Declaration of Arrays, Accessing Elements of the Array,
Storing Values in Arrays, Calculating the Length of the Array, Operations
that can be performed on Arrays, One-dimensional Arrays for Inter-
function Communication, Two-dimensional Arrays,
Strings
Introduction, String Operations
UNIT – IV
Pointers
Introduction to Pointers, Declaring Pointer Variables, Null Pointers,
Generic Pointers, Passing Arguments to Functions using Pointers,
Pointers and Arrays, Passing an Array to a Function.
Structure, Union, and Enumerated Data Types
Introduction, Structures and Functions, Union.
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

UNIT – V
Files
Introduction to Files, Using Files in C, Reading Data from Files, Writing
Data to Files, Detecting the End-of-file, Error Handling during File
Operations, Accepting Command Line Arguments.

TEXT BOOK:
1. “Computer Fundamentals and Programming in C” by REEMA THAREJA
from OXFORD UNIVERSITY PRESS

REFERENCE BOOK:
1. E Balagurusamy: ―COMPUTING FUNDAMENTALS & C PROGRAMMING‖
– Tata McGraw-Hill, Second Reprint 2008, ISBN 978-0-07-066909-3.
2. 1. Ashok N Kamthane: Programming with ANSI and Turbo C, Pearson
Edition Publ, 2002.
3. 2. Henry Mullish & Huubert L.Cooper: The Sprit of C, Jaico Pub.
House,1996.

COMPUTER ACCOUNTING WITH TALLY

UNIT I
1. Introduction; 2. Accounting System; 3. Inventory Control System; 4.
Payroll System

UNIT II
1. Starting with Tally 7.2; 2.Creating Accounts Masters; 3. Creating
Inventory Masters; 4. Entering Accounts Vouchers;

UNIT III
5. Entering Inventory Vouchers; 6. Introduction to VAT (Value Added
Tax); 7. Ledgers and VAT; 8. More on VAT;

UNIT IV
9. VAT Documents and Reports; 10. Introduction to TDS; 11.
Display/Reports in Tally; 12. The Collaborative Tally;

UNIT V
13. The Administrative Tally A. Fundamentals of Accounting; B.
Fundamentals of Inventory

TEXT BOOKS:
1. Computer Accounting With Tally 7.2 ,Firewall, Firewall Media, , Laxmi
Publications

REFERENCE BOOKS:
1. Comdex Tally 9 Course Kit by Namrata Agrawal, Dream Tech Press
2. Tally 9 by Dinesh Maidarsani By Firewall Media
3. Tally 9.0 English Edition Google EBook By Computer World

JAVA PROGRAMMING

UNIT-I:
Object Oriented Programming: Introduction to OOP, Objects and
Classes, Characteristics of OOP, Difference between OOP and Procedure
Oriented Programming, Summary
Introduction to Java Programming: Introduction, Features of Java,
Comparing Java and other languages, Applications and Applets, Java
Development Kit, More Complex Programs, Java Source file structure,
Prerequisites for Compiling and Running Java Programs.
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

UNIT-II:
Java Language Fundamentals: The building Blocks of Java, Data types,
variable declarations, wrapper classes, Operators and Assignment,
Control structures, Arrays, Strings, The String Buffer Class.
Java as an OOP Language: Defining classes, Modifiers, Packages,
Interfaces.

UNIT-III:
Exception Handling : Introduction , Basics of Exception Handling in
Java, Exception Hierarchy , Constructors and Methods in Throwable
class, Unchecked and checked exceptions , Handling exceptions in Java
,Exception and Inheritance, Throwing User defined Exceptions ,
Redirecting and Rethrowing Exceptions , Advantages of Exception
,Handling Mechanism.
Multithreading: Introduction: An Overview of Threads, Creating
Threads, Thread Life, cycle, Thread priorities and Thread scheduling,
Thread synchronization, Thread groups, Communication of Threads.

UNIT-IV:
Files and I/O Streams : An Overview of I/O streams , Java I/O , File
streams , File Input stream and File output stream , Filter streams ,
Random Access File, Serialization.
Applets: Introduction, Java applications versus Java Applets, Applet Life
cycle, working with Applets, The HTML Applet Tag.

UNIT-V:
Database Handling using JDBC: an Overview of DBMS, JDBC
Architecture, working with JDBC, Processing Queries, The Transactions
commit and Rollback, Hanling Exceptions, Mapping Database types to
java, Accessing Metadata, Sample Programs to Handle Database.
The Abstract window Toolkit: Introduction, Drawing with crystals
class, class Hierarchy of AWT, Event Handling, AWT controls, Layout
Managers, The Java2D, Java2d Shapes.

TEXT BOOK:
1. P. Radha Krishna, “Object Oriented Programming Through Java”,
Universities Press (2008)
2. Programming In Java By Sachin Malhotra And Saurabh
Choudhary From Oxford University Press

REFERENCE BOOKS:
1. E.Balagurusamy, “Programming with Java”, 3e, TMH,2007
2. H.M.Deitel, P.J.Deitel, “Java How to Program”, Sixth Edition, Pearson
Education,2007
3. ISRD Group, “Introduction to Object Oriented Programming through
Java”, TMH ,2007.
4. Timothy Budd, “Understanding Object-Oriented Programming with
Java”, Pearson Education,2007
5. Patrick Naughton & Herbet Schildt,” The complete reference java
2”,fourth edition,TMH,2007

DATABASE FUNDAMENTALS
UNIT I

Overview of Database Management System:

Introduction, Data and Information, Database, Database Management System,
Objectives of DBMS, Evolution of Database Management Systems,
Classification of Database Management System,
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

UNIT II

File-Based System, Drawbacks of File-Based System , DBMS Approach,

Advantages of DBMS, Data Models , Components of Database System,
Database Architecture, DBMS Vendors and their Products

UNIT III

Entity–Relationship Model:
Introduction, The Building Blocks of an Entity–Relationship, Classification of
Entity Sets , Attribute Classification, Relationship Degree, Relationship
Classification, Generalization and Specialization, aggregation and composition,
CODD’S Rules, Relational Data Model , Concept of ,Relational Integrity

UNIT IV

Structured Query Language :

Introduction, History of SQL Standard ,Commands in SQL, Datatypes in SQL,
Data Definition Language (DDL) ,Selection Operation Projection Operation
,Aggregate Functions ,Data Manipulation Language ,Table Modification ,Table
Truncation ,Imposition of Constraints , Set Operations

UNIT V

PL/SQL :
Introduction, Structure of PL/SQL, PL/SQL Language Elements ,Data Types,
Control Structure,, Steps to Create a PL/SQL Program, Iterative Control
,Cursors , Steps to Create a Cursor , Procedure, Function ,Packages
,Exceptions Handling, Database Triggers ,Types of Triggers

TEXT BOOK:
1. Fundamentals of Relational Database Management Systems , by S.
Sumathi, S. Esakkirajan

WEB TECHNOLOGIES

Unit I
Basic Web Concepts:
Introduction – URL – MIME – CGI – Introduction to SGML.

Unit II
HTML Common Tags: Introduction – HTML Basics – Forms – Frames – Tables –
Web Page Design.

Unit III
Java Scripts : Introduction – Basics of Java Script – Control Structures – Pop
Up Boxes – Functions – Arrays – Events – Objects – Simple Web Applications.

UNIT IV
Dynamic HTML: Introduction – Cascading Style Sheets – Object Model and
Collections – Event Model – Filters and Transition – Data Binding – Data
Control, ActiveX Control.

UNIT V
XML: Introduction – Document Type Definition – XML Schemas – Document
Object Model – Using XML Processors: DOM and SAX.

Text Books:
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

1. Web Technologies by A.A.Puntambekar from Technical Publications,

Pune

Visual Basic .NET

Unit – I
Introduction to Visual Basic .NET Creating a Windows Application – Creating
Web Application – Creating a Console Application – New in VB .NET – The .NET
Framework and the Common Language Runtime – Building VB .NET
Applications – The VB IDE. The VB .NET Language Constants – Enumerations
– Variables – Data Types – Type Conversion – Arrays – Strings – Operators –
Control Statements – Procedures – Functions – Properties – Scope – Exception
Handling.

Unit – II
Windows Forms Form Properties – MsgBox – InputBox – Multiple Forms – MDI
Applications – Dialog Boxes – Mouse Events – Keyboard Events. Controls Text
Boxes – Rich Text Boxes – Labels – Link Labels – Buttons – Checkboxes – Radio
Buttons – Panels – Group Boxes.

Unit – III
Other Controls &Advanced controls List Boxes – Checked List Boxes – Combo
Boxes – Picture Boxes – Scroll Bars – Splitters – Track Bars – Pickers – Notify
Icons – Tool Tips – Timers – Menus – Built- In Dialog Boxes – Printing -Image
Lists – Tree Views – List Views – Toolbars – Status Bars – Progress Bars – Tab
Controls.

Unit - IV
Object-Oriented Programming Classes – Objects – Structures – Modules –
Constructors – Data Members – Methods – Properties – Events – Overloading –
Class Libraries – Namespaces – Destructors – Inheritance – Interfaces –
Shadowing – Polymorphism.

Unit – V
Data Access with ADO.NET Server Explorer – Data Adapters and Datasets –
ADO.NET Objects – New Data Connection – Dataset – Data Provider – Data
Adapter Controls – MS Jet Database – Relational Databases – Data Views –
Data Binding – Binding Controls to Databases- Handling Databases in Code.

Text Book:
Title : Visual Basic .NET Programming Black Book Author : Steven Holzner
Publisher : DreamTech Press Edition : Year : 2005
Chapters: (Relevant Topics Only) Unit I : 1, 2, 3 Unit II : 4, 5, 6 Unit III : 7, 8, 9
Unit IV : 10, 11, 12 Unit V : 21, 22, 23

Reference Book:
Title : Programming Visual Basic .NET Author : Jesse Liberty, Dave
Grundgeiger Publisher : O’Reilly Edition : 2nd Year : 2003
Title : Visual Basic Programming Black Book Author : Steven Holzner Publisher
: DreamTech Press

PROGRAMMING PHP
UNIT I
Introduction to PHP
What Does PHP Do, A Brief History of PHP , The Evolution of PHP ,The
Widespread Use of PHP ,Installing PHP , A Walk Through PHP ,
Configuration Page ,Forms , Databases Graphics
Language Basics
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

Lexical Structure, Case Sensitivity, Statements and Semicolons,

Whitespace and Line Breaks,Comments, Literals, Identifiers, Keywords,
Data Types, Integers, Floating-Point Numbers, Strings , Booleans ,
Arrays ,Objects ,Resources , Callbacks , NULL , Variables , Variable
,Variables , Variable References ,Variable Scope , Garbage Collection ,
Expressions and Operators, Number of Operands , Operator Precedence ,
Operator Associatively, Implicit Casting , Arithmetic Operators , String
Concatenation Operator , Auto-increment and Auto-decrement Operators
, Comparison Operators , Bitwise Operators , Logical Operators Casting
Operators , Assignment Operators, Miscellaneous Operators, Flow-
Control Statements , if ,switch , while , for , for each , try...catch , declare
, exit and return , goto Including Code, Embedding PHP in Web Pages,
Standard (XML) Style , SGML Style, ASP Style Script Style , Echoing
Content Directly

UNIT II
Functions
Calling a Function, Defining a Function, Variable Scope, Global
Variables, Static Variables,Function Parameters, Passing Parameters by
Value , Passing Parameters by Reference Default Parameters , Variable
Parameters ,Missing Parameters , Type Hinting Return Values , Variable
Functions, Anonymous Functions
Strings
Quoting String Constants , Variable Interpolation , Single-Quoted Strings
Double-Quoted Strings ,Here Documents , Printing Strings,echo 81
print() , printf() print_r() and var_dump(),Accessing Individual Characters
, Cleaning Strings , Removing Whitespace , Changing Case, Encoding
and Escaping , HTML ,URLs ,SQL
UNIT III
Arrays
Indexed Versus Associative Arrays , Identifying Elements of an Array ,
Storing Data in Arrays , Adding Values to the End of an Array , Assigning
a Range of Values ,Getting the Size of an Array, Padding an Array,
Multidimensional Arrays ,Extracting Multiple Values, Slicing an Array,
Splitting an Array into Chunks,Keys and Values, Checking Whether an
Element Exists , Removing and Inserting Elements in an Array ,Reducing
an Array , Searching for Values ,Sorting, Sorting One Array at a Time

UNIT IV
Web Techniques
HTTP Basics, Variables , Server Information, Processing Forms , Methods
,Parameters, Self-Processing Pages, Sticky Forms , Multivalued
Parameters , Sticky Multivalued Parameters, File Uploads, Form
Validation, Setting Response Headers, Different Content Types ,
Redirections , Expiration , Authentication , Maintaining State

Databases
Using PHP to Access a Database , Relational Databases and SQL , PHP
Data Objects MySQLi Object Interface, Retrieving Data for Display
SQLite , Direct File-Level Manipulation MongoDB , Retrieving Data
,Inserting More Complex Data

UNIT V
Graphics
Embedding an Image in a Page , Basic Graphics Concepts ,Creating and
Drawing Images The Structure of a Graphics Program, Changing the
Output Format ,Testing for Supported Image Formats , Reading an
Existing File Basic Drawing Functions , Images with Text , Fonts
 SRI VENKATESWARA UNIVERSITY :: TIRUPATI
BCom (CA) , BA (CA) & B.Sc (CA) Under CBCS With Effect From Academic Year 2015-2016

TEXT BOOK
1. PROGRAMMING PHP by Kevin Tatroe, Peter MacIntyre, Rasmus Lerdorf
FROM O'Reilly Media, Inc.
2. Beginning PHP and MySQL: From Novice to Professional by W. Jason
Gilmore FROM Apress

PROJECT WORK
The project will be one semester duration. The student will be advised to
approach different organizations involved in science communication activities
as per interest and specialization of students, mostly located in the place of the
study. They will have to carry out a project work related to the area of interest
and submit a project report at the end of the semester. The students shall
defend their dissertation in front of experts during viva-voce examinations.