HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN BCA (BECHELOR OF COMPUTER APPLICATION) CBCS Syllabus 2011

nullpitΔίκτυα και Επικοινωνίες

23 Οκτ 2013 (πριν από 4 χρόνια και 17 μέρες)

702 εμφανίσεις

1


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

BCA

(
BECHELOR OF COMPUTER APPLICATION
)

CBCS Syllabus
2011

Document code :

SYLLABUS
BCA
O
O
2011

Revision No:

00

Name of Faculty


MANAGEMENT

Faculty Code

MG

Programme Name :

BECHELOR OF COMPUTER
APPLICATION

Programme Code :

B
CAO
O

Effecti ve from:

JUNE
-
2011




2


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




1


BCA101

BCA
O
O101CC

CC

Fundamentals of
Programming
Language (FPL )

70


30


100

4


1


BCA102

BCA
O
O102CC

CC

Database
Management
System (DMS)

70


30


100

4


1


BCA103

BCAO
O
103CC

CC

Computer
Organization
(COC)

70


30


100

4


1


BCA104

BCAO
O
104CC

CC

Communication
Skills


I (CSI
)

70


30


100

4


1


BCA105

BCAO
O
101PR

PR

Fundamentals of
Programming
Language ‘C’
(FPL)


70


30

100

4


1


BCA106

BCAO
O
102PR

PR

Database
Management
System and MS
-
Office (DSM)


70


30

100

4





3


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




2


BCA201

BCAO
O
201CC

CC

Advanced
Programming
Language ‘C’
(APL)

70


30


100

4


2


BCA202

BCAO
O
202CC

CC

Internet & Web
Designing
(IWD)

70


30


100

4


2


BCA203

BCAO
O
203CC

CC

Discrete
Mathematics
(DMC)

70


30


100

4


2


BCA204

BCAO
O
204CC

CC

Communication
skills
-

II (CII
)

70


30


100

4


2


BCA205

BCAO
O
201PR

PR

Advanced
Programming
Language
‘C’(APL)


70


30

100

4


2


BCA206

BCAO
O
202PR

PR

Internet & Web
Designing
(IWD)


70


30

100

4





4


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




3


BCA301

BCAO
O
301CC

CC

Object
Oriented
Programming
c++ (OOC)

70


30


100

4


3


BCA302

BCAO
O
302CC

CC

Advance
database
Management
System
(AMS)

70


30


100

4


3


BCA303

BCAO
O
303CC

CC

Statistics and
Optimization
(SOC)

70


30


100

4


3


BCA304

BCAO
O
301ES

ES

Computer
Networks
(CNE)

70


30


100

4

Any One Paper From

BCAO
O301ES
-
BCAO
O
302ES

3


BCA304

BCAO
O
302ES

ES

Enterprise
Resource
Planning
(ERP)

70


30


100

4

Any One Paper From

BCAO
O301ES
-
BCAO
O
302ES

3


BCA305

BCAO
O
301PR

PR

Object
Oriented
Programming
c++ (OOP)


70


30

100

4


3


BCA306

BCAO
O
302PR

PR

Advance
database
Management
System
(AMP)


70


30






5


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




4


BCA401

BCAO
O
401CC

CC

Data
Structure
(DSC)

70


30


100

4


4


BCA402

BCAO
O
402CC

CC

GUI
Programming
using Visual
Basic (GUI)

70


30


100

4


4


BCA403

BCAO
O
403CC

CC

System
Analysis and
Desing
(SAD)

70


30


100

4


4


BCA404

BCAO
O
401ES

ES

Operating
System
(OSE)

70


30


100

4

Any One Paper From

BCAOO401ES
-
BCAO
O
402ES

4


BCA404

BCAO
O
402ES

ES

Computer
Graphics
(CGE)

70


30


100

4

Any One Paper From

BCAOO401ES
-
BCAO
O
402ES

4


BCA405

BCAO
O
401PR

PR

Data
Structure
(DSP)


70


30

100

4


4


BCA406

BCAO
O
402PR

PR

GUI
Programming
using Visual
Basic (GUP)


70


30







6


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




5


BCA5
01

BCAO
O
5
01CC

CC

JAVA
Programming
(CCJ)


70


30


100

4


5


BCA5
02

BCAO
O
5
02CC

CC

.NET Frame Work
Using C#
(NFC)

70


30


100

4


5


BCA5
03

BCAO
O
5
03CC

CC

Software
Engineering
(S
EG
)

70


30


100

4


5


BCA5
04

BCAOO5
01ES

ES

E
-
Commerce
(ESE)

70


30


100

4

Any One Paper
From

BCAOO5
01ES
-
BCAOO504
ES

5


BCA5
04

BCA0O5
02ES

ES

Management
Information

System
(MIS)

70


30


100

4

Any One

Paper
From

BCAOO5
01ES
-
BCAOO504
ES

5


BCA5
04

BCAOO503
ES

ES

Mobile
Computing
(ESM)


70


30


100

4

Any One Paper
From

BCAOO5
01ES
-
BCAOO504
ES

5


BCA5
04

BCAO
O
504
ES

ES

Geographic
Information

System
(GIS)

70


30


100

4

Any One Paper
From

BCAO
O
5
01ES
-
BCA
O
O504
ES

5


BCA5
05

BCAO
O
5
01PR

PR

JAVA
Programming
(PR
J
)


70


30

100

4


5


BCA5
06

BCAO
O
5
02PR

PR

.NET Frame Work
Using C#
(PRC)


70


30

100

4













7


Sem

CC

Old
paper
Code

New Paper
Code

Paper
Type

Paper Name

Marking scheme

Total

Credit

Remarks

External

Internal




The

Pra

The

Pra




6


BCA6
01

BCAO
O
6
01CC

CC

Building
Application
Using
PHP
(BAU)

70


30


100

4


6


BCA
6
02

BCAO
O
6
02CC

CC

Advance .NET
Frame Work
Using
C#
(A
NC
)

70


30


100

4


6


BCA
6
03

BCAO
O
6
03CC

CC

Data
Warehousing
&

Mining
(DWM)

70


30


100

4


6


BCA6
05

BCAO
O
6
01PR

PR

Building
Application
Using
PHP
(PR
B
)


70


30

100

4


6


BCA6
06

BCAO
O
6
0
1MP

M
P

System
Development

Project
(SDP)


15
0


50

20
0

8




























8


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme

code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO101CC

Semester :

1

Fundamentals of Programming Language (FPL )

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1.





4


1.1

Introduction to Programming:

Concepts of Algorithm and Flowcharts, problem
solving examples
using algorithm and

flowchart, Types of Programming languages,
Characteristics of higher level language,

Compiler and Interpreter


18



1.2

Overview of C:

Introduction, Importance of C, Sample C programs,
Basic structure of C programs,

Programming style,
executing of C program.





1.3

Constants, Variables and data Types:

Introduction, Character Set, C tokens, Keywords
and Identifiers, Constants, Variables, Data

types, Declaration of Variables, Defining symbolic
constants.




2




17



2.1

Operators and

Expression :

Introduction, Arithmetic of Operators, Relational
Operators, Logical Operators, Assignment

Operators, Increment and Decrement Operators,
Conditional Operators, Bit
-
wise Operators,

Special Operators, Arithmetic Expressions,
Evaluation of expre
ssions, Precedence of

arithmetic operators, Type conversions in
expressions, Operator precedence and associativity,

Mathematical functions.





2.2

Managing Input and Output Operators :

Introduction, reading a character, writing a
character, formatted
input, formatted output.




3




18



3.1

Decision making branching:

Introduction, Decision making with IF statement,
Simple IF statement, the IF ELSE statement,

Nesting of IF … ELSE statements, The ELSE IF
ladderI=The=switch=statementI=the=turnery=E?=WF
=
lperatorI=the=dlTl=statementK




9



3.2

Decision Making Looping:

Introduction, the WHILE statement, the DO
statement, The FOR statement, Jumps in loops




4




17



4.1

Array :

Introduction, One
-
dimensional, arrays, Two
-
dimensional arrays, Initialization of twodimensional

arrays, Concept of Multidimensional arrays





4.2

Handling of Character strings :

Introduction, Declaring and initializing string
variables, Reading strings
from terminal, Writing

strings to screen, Arithmetic operations on
characters, Putting string together, String

Operations: String Copy, String Compare, String
Concatenation And String Length, String

Handling functions, Table of strings.





References
Books

No

Book Name

1

Programming in ANSI C

Balagurusamy

Tata McGraw
-
Hill

2

Programming in C

Pradip Dey & Manas Ghosh

Oxford

3

The Complete Reference Fourth Edition

Herbert schildt

4

Let Us C

Yashwant Kanetkar

BPB

5

Programming in C

Reena thareja

Oxford


Question Paper Scheme:

University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(12 Marks)


A. Objective/ Short
Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(12 Marks)


A. Objective/ Short Questions.


B. Descriptive
/ Long questions.

Q.5
-

Programs






A. Unit I & II




(10 Marks)


B. Unit III & IV




(12 Marks)

Note: All Objective/ Short Questions are compulsory, no option will be given.








10


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO102CC

Semester :

1

Database Management System (DMS)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

Database Concepts:

Database and DBMS, Comparison between traditional file V/s DBMS,
Characteristics of data

in database, Components of database system
environment, Functions of DBMS, Advantages

and disadvantages of
the DBMS, DBMS users, Database administrator, Role of DBA




2







0.2

Database Design and Architecture

Essentials of
Database Design, Three level Architecture of Database
-

external, conceptual and

internal, Data Models concepts: Hierarchical,
Network and Relational, Operators, relations,

domains and attributes,
keys, traditional set operations, special relational operati
ons.


17


3




18



3.1

The E/R model

Entity, E
-
R Diagram, Attributes, Relationship & Types, Development
stages of E
-
R diagram &

Examples





3.2

Normalization

Normalization Process, 1st NF , 2nd NF, 3rd NF, demoralization.




4




17



0.4

MS
-
Access

Introduction of Database,

Data type
-

Text, Number, Auto number, Currency, Boolean,
Date/Time, Memo

Object

=
TableI=nueryI=cormsI=oeports
=
Controls=use=in=form=and=report





References Books

No

Book Name

1

Database Management System

A C Shah & A R
Patel

MacMillan

2

Introduction to Database System

C. J. Date

(7th edition) Low Price Edition

3

Database system concepts

Henry F. Korth

(3rd edition) TMH







11


Question Paper Scheme:

University Examination Duration : 3 Hours.

Q.1
-

Unit
-
I






(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III






(18 Marks)


A. Objective/ Short
Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.



12


HEMCHANDRACHARYA NORTH

GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO
103
CC

Semester :

1

Computer Organization (coc)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Topic

No.

Content

Hrs.

Marks

W + %

Credit

1



18

4

1.1

Computer basics

Digital & Analog systems, Logic levels and pulse wave forms, digital
computer, Major parts of

computer, Hardware, Software
-

Application and System Software




1.2

Computer generations

First generation, Second generation, Third generation, Forth generation,
Fifth generation





1.3

Classifications of Computers

Palmtop
PC, Laptop PC, Personal Computer, Workstations, Mainframe,
Supercomputer.




1.4

Operating system

Dos, Windows Family




2



17


2.1

Introduction to Computer Parts

Input devices (only principles
)

Keyboard, Mouse, Light pen, Joystick, Scanner, Voice
input system,
Touch screen




2.2

Output devices
(only principles)

Monitor
-

CRT terminals (Monitor / VDU)

Non


CRT terminals, LCD, Plasma display, LED

Printer
-

Dot matrix printer, Ink jet printer, Laser printer, Line printer,
Plotter




2.3

Storage devices
(only principles & types)

Magnetic memory
-

Magnetic disk, Hard disk, Floppy disk,

Semiconductor memory
-

RAM, ROM, Flash memory

Optical memory
-

CD, CD
-
ROM, CD
-
RAM, DVD, DVD
-
ROM, DVD
-
RAM

Cache memory, Physical & Virtual memory




2.4

Communication devices
-
Modem, NIC, Switch, Hub




3



18


3.1

Number system
-

Binary, decimal, octal, hexadecimal




3.2

Conversion
-

Binary to decimal, decimal to binary, octal to decimal ,
decimal to octal, octal to

binary, binary to octal,
hexadecimal to binary, binary to hexadecimal,
hexadecimal to

Decimal, decimal to hexadecimal, hexadecimal to octal, octal to
hexadecimal




13


3.3

Binary arithmetic


Addition, subtraction (simple method)




4



17


4.1

Logic gates
-

AND, OR, NOT, NAND,
NOR, Exclusive
-
OR, Exclusive
-
NOR




4.2

Combinational circuits
-

Half adder, Full adder, Half subtractor, Full
subtractor




4.3

Binary classification of codes




4.4

Data Processing circuit





References Books

No

Book Name

1

Fundamentals of
computers .

V. Rajaraman

PHI Publication

2


Fundamentals of computers

Anand Kumar

PHI Publication

3

Fundamentals of computers

. B. Ram

(Module
-

M1.1)

4

O
-
Level (Information Technology)
-

V.K.Jain

5

Computer Architecture

K M Hebbar

MacMillan
Publication



Question Paper Scheme:

University Examination Duration : 3 Hours.


Q.1
-

Unit
-
I







(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II






(17 Marks)


A. Objective/ Short

Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III






(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.



14


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO104CC

Semester :

1

Communication Skills


I (CSC)

Course
type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

Theory of Communication






What is communication
-

define and explain.






Types of communication.






Process of communication.






Feedback.






Barriers of communication.




2




17



0.2

Grammar






Articles.






Tenses.






Active
\

passive voice.






Auxiliaries and modals.




3


Business Communication


18



0.3

Format of the business letter.






Letter of inquiry and replies.







Quotation.







Placing of order.







Complaints and adjustment.




4




17



0.4

Vocabulary






Confusing words.






One word substitute.






Antonyms.






Synonyms





References Books

No

Book Name

1

English Online

Mohanraj & Mohanrah, Orient Longman.

Oxford.

2

The Good Grammar Book

Swan M & Catherine Walter

Oxford.

3

English Grammar Composition and Effective Business Communication

Pink and

Thomas, S Chand.

Oxford.

4

Business Communication

Meenakshi Raman & Sangeeta Sharma

Oxford.

5

Oxford Business English
Dictionary

Principles and Practice, Meenakshi Raman & Sangeeta

Sharma

Oxford.

6

Technical Communication

Oxford.

7

Developing Communication Skills

Krishna Mohan & Meera Benarji

MacMilan Pub

8

Personality development and soft skill

Baran Mitra

Oxford.

15



Question Paper Scheme:


University Examination Duration : 3 Hours
.


Q.1
-

Unit
-
I







(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III






(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All
Objective/ Short Questions are compulsory, no option will be given.



16


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO10
1PR

Semester :

1

Fundamentals of Programming Language ‘C’ (FPL)

Course type :

Practical

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)


4 X 15 = 60

30

70 (
Practical
of 3 hrs)

100


NO

Practical
List

1

Write a
C program to display "hello computer" on the screen.

2

Write a C program to print roll no, name and address.

3

Write a C program to find the area of circle using the formula Area=PI * r * r.

4


Write a C program to find the area of rectangle, cube and t
riangle.(Formula are:

Rectangle=l *b*h,
triangle = (I * b)* 0.5, cube = L*L*L

5

Write a C program to find the area and volume of sphere. Formulas are Area = 4*PI*R*R Volume =
4/3*PI*R*R*R.

6

Write a C program to evaluate simple interest I = P*R*N / 100.

7

Write a C program to enter a distance into K.M and convert it in to meter, feet, inches and Centimeter

8

Write a C program to interchange two numbers.

9

Write a C program to convert Fahrenheit into centigrade Formula: C= (F
-
32)/1.8.

10

Write a C
program for summation, subtraction, multiplication, division of two number using

Arithmetic
operator

11

Write a C program to enter days and convert into years, month and reminder days.

12

Write a C program to find out the largest value from given three
numbers using conditional Operator

13

Write a C program to find the maximum number from given three numbers.

14


Write a C program to find that the enter number is Negative, or Positive or Zero.

15

Write a C program to Checked whether entered char is
capital, small, digit or any special

Character

16

Write a C program to read number 1 to 7 and print relatively day Sunday to Saturday.

17

Write a C program to find out the max. and min. number from given 10 numbers.

18

Write a C program to find the sum
of digit of accepted number.

19

Write a C program to find the sum of first 100 odd numbers. And even numbers.

20

Write a C program to display first 25 Fibonacci nos.

21

Write a C program to check the accepted number is prime number or not.

22

Write a
C program to display first' 100 prime numbers.

23

Write a C program to find factorial of accepted numbers.

24

Write a C program to print accepted no and its reverse number.

25

Write a C program to find whether the accepted number is palindrome or not.

26

Write a C program to convert decimal numbers into equivalent binary number.

27

Write a C program to convert decimal numbers into equivalent to octal number.

28

Write a C program to convert decimal numbers into equivalent hexadecimal numbar.

29

Write
a C program to display first 5 Armstrong number.

30


Write a C program to arrange the accepted numbers in ascending order and descending

order.

31

Write a C program to find whether the accepted string is palindrome or not.

32

Write a C program to
convert given line into upper case or lower case.

17


33

Write a C program to count no of word, character, line and space from given text.

34


Write a C program to sort given string in ascending order.

35


Write a C program to prepare pay slip using following data.

Da = 10% of basic, Hra = 7.50% of basic, Ma = 300,

Pf = 12.50% of basic, Gross = basic + Da + Hra + Ma, Nt = Gross


Pf.

36

Write a C program to read marks and your program will display grade.

M
arks Grade

100


80 Dist

60


79 First

50


59 Second

35


49 Pass

0


34 Fail

37

Write a C program to find 1+1/2+1/3+1/4+....+1/n.

38

Write a C program to display following output on the screen.

1

12

123

1234

39

Write a C program to display following
output on the screen.

1

22

333

4444

40


Write a C program to display following output on the screen.

1

0 1

1 0 1

0 1 0 1

1 0 1 0 1

41

Write a C program to display following output on the screen.

1

2 2

3 3 3

4 4 4 4

5 5 5 5 5

42

Write a C program to
display following output on the screen.

1

2 3

4 5 6

7 8 9 10

43

Write a C program to display following output on the screen

*

* *

* * *

* * * *

* * * * *

44

Write a C program to display following output on the screen.

*

* *

18


* * *

* * * *

* * * * *

45

Write a C program to display following output on the screen.

1

2 3

4 5 6

7 8 9 10

11 12 13 14 15

46

Write a C program to display following output on the screen

C

CP

CPR

CPRO

:

CPROGRAMMING

:

CPRO

CPR

CP

C

47

Write a C program to find maximum & minimum
value from the given array.

48

Write a C program to find next minimum from the given array.

49

Write a c program to input N and find out the sum, average, max, min, total even no and

total odd no. [with out use of array]

50

Write a c program to input N
no and find out the sum, average, max, min, total even no and

total odd no. [using array]

51


Write a c program to display the two matrix on screen and perform the addition of two

matrix and print on screen.

52

52. Write a c program to display the two
matrix on screen and perform the multiplication of two matrix and
print on screen.


Practical Exam Scheme:

Program

Output

Viva

Journal

Total

25 Marks

15 Marks

20 Marks

10 Marks

70 Marks















19


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO10
2PR

Semester :

1

Database Management System and MS
-
Office (DSM)

Course type :

Practical

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60

70

30

70 (
Practical
of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit



MS
-
DOS and WI NDOWS


15

4



I. DOS Commands






II. Windows Operation System
(Windows XP)






MS
-
Offi ce 2007






MS
-
Word






MS
-
Excel


15




MS
-
Power Poi nt


15




MS
-
Access


15




-
Crate a table using wizard and
design view.






-
Create a form using wizard and
design view.






-
Create a report using wizard and
design view.






-
Create Query using wizard and
design view.






-
Create project on following system


-
Student Information System


-
Employee Information System






Practical Exam Scheme:

MS
-

Word/

PowerPoi nt

Practi cal

MS
-

Excel

Practi cal

MS
-

Access
Practi cal

Vi va DOS
Commands,
Wi ndows, MS
Offi ce

Journal

Total

15 Marks

15 Marks

15 Marks

15 Marks

10 Marks

70 Marks












20


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme
Name :

BCA

Course Code

BBCAO201CC

Semester :

2

Advanced Programming Language ‘C’ (APL)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

User
-
Defined Functions:

Introduction, Need for user
-
defined
functions, The form of C function, Return
values and their

types, Calling a
function, category of
functions, No arguments and no return
values, Argument

with no return values, Arguments with
return values, Handling of non
-
integer
functions,

Nesting of functions, Recursion, Functions
with arrays, The scope and Lifetime of
variables

in

functions




2




17



0.2

Structures and Unions:

Introduction, Structure definition, Giving
values to members, Structure initialization,

Comparison of structures variables, Arrays
of structures, Arrays within structures,
Structures

within

Structures, Structures and functions,
Unions, Size of structures, Bit fields.




3




18



0.3

Pointers:

Introduction, Understanding pointers,
Accessing the address of a variable,
Declaring and

initializing pointers, Accessing a variable
through its
pointer, Pointer expressions,
Pointer

increments and scale factor, Pointers and
arrays, Pointers and character strings,
Pointers and

Functions, Pointers and structures.




4




17


21



4.1

File Management in C:

Introduction, Defining and opening a file,
Closing a file, Input / Output operations on
files,

Error handling during I/O operations,
Random access files, Command line
arguments.





4.2

Dynamic Memory Allocation

Introduction, Dynamic Memory allocation,
Memory allocation functions





4.3

The
Preprocessors:

Introduction, Macro Substitution, File
inclusion, Compiler control directives





No

Book Name

1

Programming in ANSI C

Balagurusamy

Tata McGraw
-
Hill

2

Programming in C

Pradip Dey & Manas Ghosh, Oxford

3

The Complete Reference

Herbert
schildt

Fourth Edition

4


Let Us C

Yashwant Kanetkar,

BPB Publications


Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV







(12 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.5
-

Programs






A. Unit I & II




(10 Marks)


B. Unit III & IV



(12 Marks)

Note: All Objective/ Short Questions are compulsory, no option will be given.












22


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO202CC

Semester :

2

Internet & Web Designing (IWD)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination
Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

Concept of Internet

A brief Introduction to
the Internet: Computer Networks,
Internet, URL (Uniform Resource

Locator), Internet Service Provider, Intranet, Extranet, Virtual
Private Network.

Application of Internet: World Wide Web, Search Engines, News
groups, Electronic Mail,

Web Portal, Chat, Vide
o Conferencing, FTP, Remote Login, E
-
Commerce, E
-
Learning, EGovernance,

E
-
Banking.




2




17



0.2

Static Web Page Development

Basics of HTML:
What is Internet Language?, Understanding
HTML, Create a Web page,

Linking to other Web Pages, Publishing HTML

Pages, Text
Alignment and Lists, Text

Formatting Fonts Control, Email Links and link within a Page,
Creating a Table, Creating

HTML Forms, Creating Web Page Graphics, Putting Graphics
on a Web Page, Custom

Backgrounds and Colors, Creating Animated Graphic
s.




3




18



0.3

Dynamic Web page Development

Cascading Style Sheet:
CSS, Defining Style with HTML Tags,
Features of Style Sheet, Style

Properties, Style Classes, External Style Sheet




4




17



0.4

JavaScript

Introduction to JavaScript: Writing
First Java Script, External
JavaScript, Variables: Rules for

variable names, Declaring the variable, Assign a value to a
variable, Scope of variable, Using

Operators, Control Statements, JavaScript loops, JavaScript
Functions: Defining a Function,

Returnin
g value from function, User define function.







23


References


Books

No

Book Name

1

Internet and Web Design

Based on DOEACC III Revised syllabus ‘O’ Level

Mac Millan India Ltd.

2

Teach Yourself HTML 4 in 24 Hours

Dick Oliver

4th edition

3

The Complete

Reference JavaScript

Thomas Powell & Fritz Schneider

2nd Edition.

4

Introduction to Internet and HTML Scripting

Bhaumik Shroff

Books India Publ.

5

HTML and CSS

Dick Oliver and Michael Morrison

(Pearson Education) 7th Edition

6

HTML, DHTML JavaScript,
Perl CGI

Ivan Bayross

(BPB) 3rd Edition

7

CSS

Kynn Bartlett

(Pearson Education)2nd Edition

8

Introduction to Internet & HTML Scripting

Bhaumik Shroff

3rd Edition.

Books India Publication



Question Paper Scheme:


University Examination Duration: 3
Hours.

Q.1
-

Unit
-
I





(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III






(18

Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17

Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are
compulsory, no option will be given.











24


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO203CC

Semester :

2

Discrete Mathematics (DMC)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

Set
Theory:

Introduction, Definition and Concepts, Representation of Sets,
Finite Sets, Infinite Sets

(Definition), Set Operations : Union, Intersection, Addition
theorem, difference, Symmetric

difference, D’ Morgons Law, Subsets, Power Sets, Partitions
petsK




2




17



0.2

Functions:

Introduction: Definitions and Concepts, One to One, onto
functions, Invertible

Functions.

Mathematical Functions (Definition and Examples) : Floor and
ceiling functions, Integer and

Absolute value functions, Remainder
functions, Exponential
functions, logarithmic functions,

Recursive functions




3




18



0.3

Determinants and Matrices:

Determinants, Basic theorems of determinants,

Metrics
-
Definition and Concept, square Matrix, unit Matrix, null
Matrix, Matrix
Addition,

Multiplication, Scalar multiplication, Transpose of a Matrix,
Invertible Matrices, Inverse of a

Matrix.




4




17



0.4

Sequences and Series:

Sequences: Introduction, Types of sequence, Arithmetic
progression (A.P), Geometric

progression

(G.P).

Series : Introduction, Types of series, Arithmetic series (A.P)

Permutation, Combinations








25


References Books

No

Book Name

1

Discrete Mathematics

S.LIPSCHUTZ, M. LIPSON (TMH)

(Second Edition)

2


Elements of Discrete Mathematics

C.L. LIU
(TMH)

3

Discrete Mathematics

J K SHARMA

( Macmillan Publishers)


Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV







(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.



26


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme

Name :

BCA

Course Code

BBCAO204CC

Semester :

2

Communication skills
-

II (CSC)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1





4


0.1

Writing

Application for job.

Application for loan.

Application demanding original documents from office.

Application for leave.


18


2




17



0.2

Grammar

Prepositions.

Nouns and pronouns.

Questions and negatives.

Conjunctions.




3




18



0.3

Translation and Comprehension

Translation from English into Gujarati or Hindi.

Comprehension.




4




17













0.4

Listening and
Speaking.

Dialogues.

1. At the college.

2. On the campus.

3. Out side the campus.

4. At the post office.

5. At the hospital.

6. At the railway station.

Group discussion.

Presentations.

Interview.





References Books

No

Book Name

1

English Online

Mohanraj & Mohanrah

Orient Longman.

2

The Good Grammar Book

Swan M & Catherine Walter

Oxford.

3

English Grammar Composition and Effective Business Communication

Pink and

Thomas, S Chand

4

Business Communication

Meenakshi Raman & Sangeeta Sharma

Oxford.

5

Business English Dictionary

Oxford.

6

Technical Communication: Principles and Practice

Meenakshi Raman & Sangeeta Sharma,

Oxford

27




Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(18 Marks)


A.
Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(18 Marks)


A. Objective/ Short
Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.



28


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO201
PR

Semester :

2

Advanced Programming Language ‘C’(APL)

Course type :

Practical

Total Credit :

04

Teaching time (hours)

Examination
Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60

30


70 (
Practical
of 3 hrs)

100


Practical List

1

Write a program to check the no. is Palindrome or not using UDF.

2

Write a program to find
factorial of given no using UDF.

3

Write a program to find factorial of given no using recursion.

4


Write a program to display first 25 terms of Fibonacci series using recursion.

5

Write a program using a recursive function to find the GCD(Greatest Com
mon Divisor) of two

Positive integer
numbers.

6

Write a program to swap value of two integer number using UDF

7

Write a function prime that returns 1 if its argument is a prime and return zero Otherwise.

8


Write a program that will print the longest word written in a line using UDF.

9


Write a program that will scan a character string passed as an argument and convert all

Lowercase character
into their uppercase equivalents using UDF.

10

Write a program t
hat uses a UDF to sort an array of integer.

11


Write a program to search a number within an array using UDF.

12

Write a program which explains the use of nesting of functions.

13


Write a function
power
that computes x raised

to the power y for integers x and y and return

Double
-
type
value.

14

Define a structure type struct personal that would contain person name, date of joining and

salary using this
structure to read this information of 5 people and print the same on screen
.

15

Design a structure student_record to contain name, branch an
d total marks obtained. Develop
a program to
read data for 10 students in a class and print them.

16

Write a program using structure within structure.

17

Define a structure called cricket
that will des
cribe the following information
Player name, Team name, Runs


Using cricket, declare an array player with 10 elements and write a program to read the

information about all
10 players and print a team
-
wise list containing names of players

with
their runs.

18

In a program declare following structure member: name, cod
e, age, weight and height. Read
all members of
the structure for 10 persons and find list of persons with all related data

whose weight > 50 and height > 40
and print the same with
suitable format and title.

19

Write a program to print the value and address of the element.

20

Write a program to accept 10 numbers and display its sum using pointer.

21

Write a program to accept 10 numbers and sort them with use of pointer.

22

Write
a program to swap the two values using pointers and UDF.

23


Write a program with structure and pointer.

24


Write a program using pointer to determine the length of a character string.

25

Write a program using pointers to read an array of integers and
print its elements in reverse order.

26

Write a program using UDF and pointers to add two matrices and to return the resultant matrix to the calling
function.

27

Create one text file store some information into it and print the same information on Termin
al.

28


A file named data contains series of integer no. Write a c program to read that no. and then Write all odd no
into file named odd no. and write all even no into file named even no. Display all the contents of these file on
29


screen.

29

Write a c
program to read data from keyboard, write it to a file called input and Display data

of input file on the screen.

30

Write a program that counts the number of characters and number of lines in a file.

31


Write a c program to read mark data which contains roll no, name, sub1, sub2, sub3 file and

Generate the
annual examination results are tabulated as follows:


Result

-------------------------------------------------------------
------

Roll no Name Sub1 Sub2 Sub3 Total per% Class

--------------------------------------------------------------------

32

Write a c program to input employee no, employee name and basic and to

store output into empdata file in following format.

A/c Depa
rtment

------------------------------------------------------------------------------------------

Emp
-
No Name Basic DA HRA MA PF GROSS NET
-
PAY

------------------------------------------------------------------------------------------

1 xyz 5000 2500 500
100 500 8100 7600

2

3

-------------------------------------------------------------------------------------------

DA = 50% of Basic HRA =10% of Basic

MA = 100 PF = 10% of Basic

GROSS = BASIC + DA + HRA + MA NET
-
PAY = GROSS


PF

33

Write a c program to rea
d empin data file which contains empno, empname and basic. To

create empout data
file as per practical no 23 format.

34

Write a program using fseek and ftell functions.

35

Two files DATA1 and DATA2 contain sorted lists of integers. Write a program to
produce a

third file DATA
which holds a single sorted, merged list of these two lists. Use command

line arguments to specify the file
names.

36

Write a program to work as a dos copy con command using command line argument.

37

Write a C program to work as

a dos type command using command line argument.

38

Write a C program to work as a dos copy command using command line argument.

39

Write programs which explain the use of memory allocation functions.

40

Write a program which explains the use of macro.


Practical Exam Scheme:

Program

Output

Viva

Journal

Total

25 Marks

15 Marks

20 Marks

10 Marks

70 Marks













30


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO20
2
PR

Semester :

2

Internet & Web Designing (IWD)

Course type :

Practical

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60

30


70 (
Practical
of 3 hrs)

100


Practical List

1

Develop an HTML document for a web page of your favorite teacher. Design the page with an attractive
background color, text color and background image.

2

Develop an HTML document for a web page of your favorite National Leader. Design

the page with an attractive color combination, with suitable headings and horizontal rules.

3

Write an HTML document with an example of Ordered List and Unordered List.

4

Write an HTML document with an example of Table format to print your Bio
-
Data.

5

Write an HTML document with an example of Table format to print your Telephone Bill.

6

Write the Frameset tags and Frame tags for the following frameset.


Physics.html

Welcome.html

Maths.html

Chemistry.html

Computer.html

Biology.html

Heading.html


Zoology.html

Account.html


7

Develop a complete web page using Frames and Frameset which gives the Information

about Hospital.

8

Write an HTML code for designing the subscription form of mail account in the e
-
mail

website with appropriate fields.

9

Write an example of Style Sheet.

10

Describe yourself on a webpage and experiment with colors in bgcolor ,text, link, try out different and sizes
and also the other tags you studies so far, such as the rules tag as well as.

11

Design a single page web si
te for a university containing a description of the courses offered , it should also
contain some general information about the university such as its history, the campus and its unique features
the page should be colored and each section

should have
different color.

12

Write a HTML code to designate a section of text that is already formatted for display preformatted text is
usually used for compute output.

Solution

<BODY>

<P> C Programme</p>

<Pre>

#include<stdio.h>

Void main ()

{

printf(“Hello
world”);
=
}
=
<Lmre>
=
<LBlav>

13

Write a HTML code for specifying the heading BS or cities in the HTML document.

Solution

31


<h1>_ _ _ _ _ _</h1>

18. Write HTML code for following list

Full time program.

BCA

PGDCA

BBA

Euening program

MCA

MBA

Clash course.

Computer.

14

Write a HTML code using Nested list.

15

Write HTML code to devlop a web page having background in blue and title “Wel come

to my home page” in
red other color.

16

Create an HTML document of giving details of your name, age, telephone no,
address

and enrolment no,
aligned in proper order.

17

Write HTML code to create a web page of green color and display a mouing message in

yellow color.

18

Write HTML code for following list

Full time program.

BCA

PGDCA

BBA

Euening program

MCA

MBA

Clash
course.

Computer.

19

Calculate a web page that provides links to five different web page or to entirely different websites.

20

Design page that has 5 equal columns the table should look the same in all screen

resolution.

Solution

<table border
cellspacing = 3 border color “#00000”>

<TR> <td width =”20 %”>

<p>Column1</td>

<p>Column1</td>

<td width=”20 %”>

<p>Column1</td>

</TR>

</table>

<p></p></body>

</html>

21

Write a HTML code for making table to containing different option for different quest
ions.


Which is your favorite color

Who is your national leader

Who is the highest test centuries
person in India

Red

Sardar Patel

Sunil Gawskar

Green

Gandhiji

Kapil Dev

Yellow

Indiraji

Sachin tendulkar

Blue

Nehruji

Ajay Jadeja


22


Devlop

your academic time table in HTML using <table> Tag and use class to change the

background of
different allows of your time table.

23

Write a HTML code using a Frame concept

32


Solution

<body bgcolor= # effaced text = “dark red”>

<h1 align = “center”>

Inline

frame

</h1>

<iframe name = “inline Frame” src = “inline.html” width=”65%” height = “80 %”>

</frame>

</p>

</body>

24


Create form to fill information student.

25

Create a JavaScript code to display any message.

26

Create a JavaScript code using
Arithmetic Operator, Assignment Operator, Comparison Operator, Logical
Operator and String Operator.

27

Create a JavaScript code using Control Statements.

28

Create a JavaScript code to display

5 * 1 = 5

5 * 2 = 10

. .

5 * 10 = 50 using ‘for loop’.

29


Create a JavaScript code using User Defined Function which will calculate the area of circle.

30


Write a JavaScript code to change the background color of the Web Page.

31

Write a JavaScript code to display Factorial of the given number


Practical Exam Scheme:

Practical

HTML

Practical

JAVA Script

Viva

Journal

Total

25 Marks

15 Marks

20 Marks

10 Marks

70 Marks



33


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO301CC

Semester

:

3

Object Oriented Programming c++ (OOC)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1





4


0.1

Fundamentals of Programming

Concept of Procedural, structured and objects oriented
programming .Concept of

Encapsulation, Data hiding, Inheritance and Polymorphism.
Classes and objects. Data types,variable and constants,
Expression and operator. Simple I/O statements
-

reading
and writing.Reference variable. Control statements, Looping
statements, Array.


18


2







0.2

Functions, Class, Object, Constructor and Destructor

Functions:
Call by reference, call by value, return by
reference, inline function, constant

argument, function overloading, static member function,
static data member
. Classes:

Implementing
class, Classes and members, Accessing class
members, implements class

methods, array of object, friend function
. Constructor &
Distracters:
Parameterized

constructor, multiple constructor, constructor with default
argument, copy constructor,

destructor.


1
7


3







0.3

Operator Overloading & Type Casting

Operator overloading, unary operator overloading, binary
operator overloading, manipulates

string using operator
overloadi
ng. type conversions : basic to
class, class to
basic, class to

class.


18


4












0.4

Inheritance, Virtual Function

Inheritance:
single Inheritance, multilevel Inheritance,
multiple Inheritance, hybrid

Inheritance, hierarchical Inheritance, virtual base class,
abstract class.
Pointers:
pointer to

object, this pointer,
virtual
function and pure virtual function.


17





34


References Books

No

Book Name

1

E. Blagurusamy:
Object Oriented Programming with C++
, Tata McGraw Hill.

2

V. Rajaraman:
Object Oriented Programming with C++
, New age International

Publishers.



Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions
.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/

Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.





35


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO302CC

Semester :

3

Advance database
Management System (AMS)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1





4


0.1

Structured Query Language (SQL):
Introduction to SQL,
Constraints, DDL, DML, DCL,Create, Alter, Drop, Rename,
Grant, Revoke, Select Clause, Functions, Different Types of

Joins, set operators,
sub query


18


2







0.2

PL/SQL:
Index, View, Sequence, Cursor, Procedure,
Trigger, Exception Handling.


17


3







0.3

Decision Support:
Introduction, Aspects of decision
support, Database design for decision

support, Data
Warehouses and Data
marts, Online analytical processing,
Data mining


18


4











0.4

Transition Management:
Recovery, concurrency, security:
Introduction, Discretionary access

control, Mandatory
access control, Statistical databases, Data encryption,
Distributed

Databases:
Introduction, Some Preliminaries, The twelve
objectives, Problems of distributed systems.


17



References Books

No

Book Name

1

Introduction to Database System,
C. J. Date (7th edition) Low Price Edition

2

SQL, PL/SQL
, Evan Bayross

(2nd edition) BPB

3

Database system concepts
, Henry F. Korth (3rd edition) TMH












36


Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long
questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Questions are compulsory, no option will be given.





37


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme

code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO303CC

Semester :

3

Statistics and Optimization (SOC)

Course type :

Core Course

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1





4


0.1

FREQUENCY DISTRIBUTION

Collection of data, Classification of data, Class interval,
Types of Classes, Class
frequency,Class mark, Class
Boundaries, Width of a class, Frequency density, Relative
frequency,Percentage frequency, Cumulative frequency.

MEASURES OF CENTRAL TENDENCY

Introduction, Arithmetic Mean, Simple and weighted for raw
data, Discrete frequency,dis
tribution, Continuous frequency
distribution, Properties of A.M., Merits & Demerits of

A.M.
-

Median for raw data, Discrete frequency distribution,
Continuous frequency distribution

(C.F.S.), Merits and
demerits of Median, Mode for raw data and for C.F.S.,
Merits & demerits

of mode

MEASURES OF DISPERSION

Introduction, Range, coefficient of range, Quartiles, Quartiles
deviations, coefficient of quartile

deviations, Mean deviation
and coefficient of mean deviation, S.D and variance for all
types of

frequency d
istribution, Coefficient of Dispersion,
Coefficient of variation


18


2




17



0.2

CORRELATION AND REGRESSION

CORRELATION

Definition of Correlation, Types of Correlation, Scatter
Diagram Method, Karl Person’s ,Correlation Coefficients,
Rank Correlation
Coefficients, Correlation Coefficients for
Bi
-
variate

frequency d
istribution, Probable error for
Correlation Coefficients

REGRESSION

Definition of Regression, Regression lines, Regression
Coefficients, Properties of regression

Coefficients, Fitting of
regr
ession lines and esti
mation for Bi
-
variate frequency
distribution




3




18



0.3

LINEAR PROGRAMMING

Mathematical model, standard form of an LPP, Graphical

solution, Simplex method, Duality in

LPP, PERT & CPM




4




17


38










0.4

TRANSPORTATION &
ASSIGNMENT MODEL.

Introduction, Mathematical Formulation, Tabular
Presentation, Special Structure of

Transportation Problem,
Optimum solution of transportation problem, Optimality test,

Degeneracy transportation problem, Mat
hematical
formulation of the
assignment problem,

Hungarian method
for solving an assignment problem, Unbalanced assignment
problem,

Traveling Salesman Problem, Applications
.





References Books

No

Book Name

1

For Unit

I & II

1.
Statistical Methods,
S.P. Gupta

2.
Business Statistics,
R.S. Bhardwarj

3.
Fundamental of Statistics,
S.C. Gupta

2

For Unit
-
III and IV

1.
Sharma S.D.,
Operation Research Kedar Nath & Co. Meerut, 1988
-
89.



Question Paper Scheme:


University Examination Duration: 3 Hours.

Q.1
-

Unit
-
I





(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.2
-

Unit
-
II




(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.3
-

Unit
-
III




(18 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Q.4
-

Unit
-
IV






(17 Marks)


A. Objective/ Short Questions.


B. Descriptive/ Long questions.

Note: All Objective/ Short Question
s are compulsory, no option will be given.




39


HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN

Programme code :

BBCAO

Programme Name :

BCA

Course Code

BBCAO301ES

Semester :

3

Computer Networks (CNE)

Course type :

Elective Subject

Total Credit :

04

Teaching time (hours)

Examination Marking scheme

Theory

(hrs)

Practical

(hrs)

Internal

(Marks)

External

(Marks)

Total

(Marks)

4 X 15 = 60


30

70 ( Paper of 3 hrs)

100


Unit

No.

Topic

No.

Content

Hrs.

Marks

W + %

Credit

1




18

4


0.1

Basic of Computer Networks:
Advantages and
disadvantages of computer networking. Types

of Networks
-