SARDAR PATEL UNIVERSITY

machinebrainyΛογισμικό & κατασκευή λογ/κού

8 Ιουν 2012 (πριν από 5 χρόνια και 3 μήνες)

391 εμφανίσεις

SARDAR PATEL UNIVERSIT`Y
BCA
Proposed Syllabus under CBCS
(effective from June 2010)
S
EMESTER
-
IV
T
ITLE
N
O
.
OF
C
REDITS
Core Courses
US04CBCA01 :
Relational Database Management Systems
-
II
4
US04CBCA02 :
Object Oriented Programming Through Java
4
US04CBCA03 :
Operating Systems
4
US04CBCA04 :
Practicals
6
Founda
tion Courses
US04FBCA01 :
Computer Based Numerical and Statistical Methods
4
Elective
US04EBCA01 :
E
-
Commerce
US04EBCA02 :
Enterprise Resource Planning
2
Total Credits
24
Course : US04CBCA01
(Relational Database Management Systems
-
II)
Credits
: 4
Lectures per week
: 4
All units carry equal weightage.
Theory Units:
1.
Relational Database Design

Consequences of poor database design

The pr
ocess of database normalization

Functional dependencies

Lossless joins and dependency preservation

1
st
Normal Form, 2
nd
Normal Form, 3
rd
Normal Form, Boyce
-
Codd Normal Form

Examples of normalization
2.
Basics of PL/SQL

PL/SQL
-
Introduction and advantages

Und
erstanding PL/SQL Block structure

Fundamentals of PL/SQL Language
-
data types (BOOLEAN, CHAR, NUMBER,
DATE, VARCHAR2), variables, constants and expressions (CASE expression)

Operators
3.
Control Flow Constructs and Cursors

Conditional statement

IF and CAS
E statements

Controlling loop iterations

LOOP, EXIT, EXITWHEN, WHILE, FOR

Sequential control statement

GOTO and NULL

SELECT..INTO statement

Working with cursor : introduction, types, attributes and processing (i.e.
declaring, opening, fetching and clos
ing), using parameterized cursor, using
cursor FOR loop
4.
Exception Handling

Error Handling : introduction, advantages of exceptions, types of exceptions

Working with user
-
defined exceptions

declaration,
RAISE_APPLICATION_ERROR, Pragma EXCEPTION_INIT, SQLC
ODE and
SQLERRM
5.
Stored Procedures and Functions

Stored procedures

introduction, creating, modifying, executing and dropping
procedures

Stored functions

introduction, creating, modifying, executing and dropping
functions
6.
Database Triggers and Packages

Database triggers

introduction, creating, modifying and dropping triggers, types
of triggers

Packages

meaning, advantages, creating, modifying and dropping
MAIN REFERENCE BOOKS :
1.
An introduction to Database Systems : Bipin C. Desai, Galgotia Poblic
ations Pvt.
Ltd.
2.
Ivan Bayross : SQL, PL/SQL The programming language of Oracle, 3
rd
revised
edition, BPB Publications
3.
Kevin Loney, George Koch, Orale9i The Complete Reference , Oracle Press
4.
Buluksu Lakshman : Oracle9i PL/SQL : A developer’s guide, Apress,
edition
2003
BOOKS FOR ADDITIONAL READING :
1.
Understanding Database Management Systesm : S. Parthsarthy and B.W.Khalkar,
First edition

2007, Master Academy
2.
P. S. Deshpande : SQL/PLSQL for Oracle9i, dreamtech press, reprint edition
2009
Course : US04CB
CA02
(Object Oriented Programming Through Java)
Credits
: 4
Lectures per week
: 4
All units carry equal weightage.
1.
Introduction

History of Java, features, the Java environment, the Java Virtual Machine (JVM)

Structure of a Java program, a simple Java
program, implementing a Java
program

Tokens, comments, constants, variables and data types

Scope of variables, type casting

Operators: arithmetic, relational, logical, assignment, increment/decrement,
conditional, ternary operator & special operators

Decis
ion making: if statement, if…else statement, nesting of if…else, the else if
ladder, switch statement

Looping: while, do…while, for, for each loop jumps in loops, labeled loops

Arrays: one, two dimensional arrays
2.
Classes, Objects, Interfaces and Inheritanc
e

Defining a class, members of a class: variables and methods, creating objects,
constructors, accessing class members

Static members v/s instance members

Introduction to inheritance,
super
keyword

Interfaces: introduction, definition, extending, implement
ing & accessing

Final variables, methods and classes, abstract methods and classes
3.
Method Overloading, Overriding and Exception Handling

Introduction to method overloading and overriding

Managing errors & exceptions: introduction, types of errors, exceptio
ns, syntax of
exception handling construct, multiple catch statements, the finally clause,
defining and throwing user
-
defined exceptions, the throw statement
4.
I/O Management and Packages

Introduction to the concept of package, Java API packages, using the S
ystem
class, user defined packages

Using java.lang (String, Math), java.util (Calendar, Date, ArrayList) packages

Managing I/O files : introduction, concept of streams, character stream classes
5.
Applet Programming

Applet architecture and skeleton

java.awt p
ackage (Button, CheckBox, CheckBoxGroup, Choice, Color, Label,
List, TextArea, TextField)

HTML applet tag, display techniques (DrawString, Lines, Rectangle, Ellipses,
Circles, Arcs, Polygons, Color)

Introduction to event handling
6.
JDBC

Introduction to I
DE, features of NetBeans, application development with
NetBeans

Introduction to JDBC, types of drivers

java.sql package

Retrieving, inserting, deleting and updating data though Java
MAIN REFERENCE BOOKS :
1.
Programming with Java
-
A Primer by E. Balaguruswa
mi, 3
rd
Edition, TMH
Publication
2.
The Complete Reference

Java 2 7
th
Edition Herbert Schildt. TMH Publication
BOOKS FOR ADDITIONAL READING :
1.
Saba Zame , Handbook of Object technology, CRC Press, Washington DC, 1999
2.
Mary Campion and Kathy Walrath, Java tut
orial, Second Edition, Addison Wesley
Pun. 1998.
3.
Java 2 Programming Black Book, Steven Holzner
Course : US04CBCA03
(Operating Systems)
Credits
: 4
Lectures per week
: 4
All units carry equal weightage.
1.
Introduction

Introduction to Operating System, Fu
nctions of OS

Different types of Operating Systems: Real time, Multi
-
user, Time sharing

OS Structure

Monolithic, Layered, Virtual Machine, Client
-
Server
2.
Scheduling

CPU Scheduling: Introduction to process, process control block, process
scheduling

FCFS Sc
heduling, SJF scheduling, Priority scheduling, Round Robin scheduling
3.
Memory Management

Memory Management: Concept, Basic memory management techniques:,
Swapping, Virtual Memory System, Demand Paging
a)
The Optimal Page Replacement Algorithm
b)
The NRU Page Repl
acement Algorithm
c)
The FIFO Page Replacement Algorithm
d)
The second change Page Replacement Algorithm
e)
The clock Page Replacement Algorithm
4.
Process Synchronization and Deadlocks
-
Introduction to Cooperating process

Process Synchronization,

Critical Secti
on Problem

Two process solution, Multiple process solution

Deadlock and characterization
5.
Introduction to Linux
-
I

Introduction to Linux System & History

Features of Linux

Introduction to File System & Memory Management

Basic Commands: login, logout, date,
man, pwd, who, whoami, dir, ls, cd, mkdir,
rmdir

Use of Wild card characters and introduction to vi editor
6.
Introduction to Linux
-
II

Introduction to environment variable like HOME, PATH, PS1

Types of FAP, use of chmod command

Basic commands like cp, mv,
rm, rev, file redirection,

grep, cut, paste, find sort commands with example

Introduction to shell script: execution of it, shell script variable, expr, test
commands

Control structure: if, if..else, case structure

Iteration: while, for construct, break,
continue, exit commands
MAIN REFERENCE BOOKS :
1.
Andrew S. Tanenbaum: Operating System deign & Implementation, Prentice Hall
International
2.
James Peterson and Abraham Silberschatz: Operating System Concept, Addition
Wesley
3.
Linux Commands Instant reference

Bryan Pfaffenberger, BPB Publication
4.
Advanced Linux Programming

Samuel, Techmedia Publications
Course : US04CBCA04
(Practicals)
Credits
: 6
No. of laboratory hours per week
: 12
University examination duration
: 4 Hours
Part
-
I : Weightage
-
50%

Practical based on
US04CBCA01 :
Relational Database Management Systems
-
II
(Questions based on cursors, database triggers, database object creations (e.g.
stored procedures, functions) may be asked.
Part
-
II : Weightage
-
50%

Practical based on
US04CBCA02
:
Object Oriented Programming using Java
(Questions based on Java programming concepts may be asked)
Course : US04FBCA01
(Computer Based Numerical and Statistical Methods)
Credits
: 4
Lectures per week
: 4
All units carry equal weightage.
1.
Compute
r Arithmetic & Iterative Methods

Absolute, Relative and Percentage error

The method of successive bisection, an algorithm of bisection method to find
a root and examples

The method of false position, algorithm of the method of iterative procedure, th
e
secant method, illustration and algorithm, the method of successive
approximations, illustrations and algorithm
2.
Differentiation

Definition, examples

Higher order derivative of standard functions up to second order.
3. Interpolation with Equal Interv
als

Interpolation with equal intervals
-
finite difference table, The Gregory
-
Newton
formula for forward and backward interpolation, corresponding algorithms and
examples
4. Interpolation with Unequal Intervals

Interpolation for unequal intervals, Newt
on's formula for divided differences,
Langrange interpolation, Central difference formulae, Extrapolation,
corresponding examples
5. Solution of Simultaneous Linear Equations

The Matrix inversion method, the Gauss
-
Seidel iterative method

Com
parison of direct and iterative methods
6. Time Series and Forecasting

Utility of Time Series Analysis

Components of Time Series
-
Secular trend, Seasonal variation,
Cyclical variation and Irregular variation
-
Methods on measuremen
t of
components
-
The moving average method
-
merits and limitations

Forecasting models and methods
MAIN REFERENCE BOOKS :
1.
Rajaraman V. : Computer Oriented Numerical Methods, Prentice Hall of India
Pvt. Ltd., 1983
2.
Sastry S. S. : Introductory Metho
ds of Numerical Analysis, Prentice Hall of
India Pvt. Ltd., 1986
3.
Salaria R S : Computer Oriented Numerical Methods, Khanna Book Publishing
Co. Ltd., 2000
4.
Murray R Spiegel : Theory and Problem of Statistics, McGraw
-
Hill Schaum's
Outline Series,1981.
5.
A tex
t book of Calculus with an introduction to differential Equation by Dr.
Dinesh J. karia, Mahendra L. Patel, Roopal Prakhashan Vallabh Vidyanagar.
Course : US04EBCA01
(E
-
Commerce)
Credits
: 2
Lectures per week
: 2
All units carry equal weightage.
1.
Intr
oduction To E
-
Commerce

Definition, communication perspective, business process perspective, service
perspective

Classification by nature of transaction : B2B, B2C, C2C, C2B, Non business EC,
Intra
-
business EC

Classification of EC Applications: electronic m
arket, inter organizational system,
customer services

Benefits to organizations, consumers, and society

Limitations of EC, framework of EC, future of EC
2.
E
-
Commerce Business Models

Introduction, eight key ingredients of a business model, major B2C and B2B
b
usiness models, Introduction to M
-
Commerce.
3.
Electronic Marketplaces

Marketspace components, types of electronic markets (electronic storefronts,
electronic malls, types of stores and malls)

Portals and their types, role of intermediaries in E
-
markets
, E
-
market success
factors, competitive factors, impact of E
-
Market on organizations (marketing, HR,
manufacturing, finance and accounting)
4.
Customer Relationship Management (CRM)

CRM : meaning, types of CRM, benefits and limitations of CRM, issues in CRM
implementation, classifications of CRM applications, one
-
to
-
one marketing
(personalization, collaborative filtering, customer loyalty, trust)
MAIN REFERENCE BOOKS :
1.
Electronic Commerce : A managerial Perspective Efraim Turban, Jae Lee, David
King, H Mich
ael Chung (Pearson Education.)
2.
E
-
Commerce

Business, Technology, Society Kenneth C Laudon, Carol Guercio
Traver (Pearson Education)
Course : US04EBCA02
(Enterprise Resource Planning)
Credits
: 2
Lectures per week
: 2
All units carry equal weightage
.
1.
Introduction

Enterprise Resource Planning (ERP) : introduction, history, advantages

Enterprise : introduction, business modeling, integrated data model, integrated
management information

Basic concepts of ERP

Risks and benefits of ERP
2.
ERP and Related T
echnologies

Introduction to MRP, MRP
-
II and ERP

Business Process Reengineering (BPR)

Data warehousing, data mining and Online Analytical Processing (OLAP)

Product Life Cycle Management (PLM), Supply Chain Management (SCM),
Customer Relationship Management
(CRM)
3.
ERP Marketplace and Functional Modules

Marketplace : overview, dynamics, changing ERP market

Indian ERP Scenario

Functional modules of ERP software

Integration of ERP, SCM and CRM
4.
ERP

Selection and Implementation

ERP package selection

ERP Implement
ation basics, ERP Implementation Life Cycle
MAIN REFERENCE BOOKS :
1.
Alexis Leon : Enterprise Resource Planning, Tata McGraw
-
Hill, New Delhi 1
st
and 2
nd
editions.
2.
Internet based resource.