BCA 2020 23 Batch
BCA 2020 23 Batch
BCA 2020 23 Batch
UTTARANCHALUNIVERSITY
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand-
248007, INDIA
EVALUATION SCHEME
BACHELOR OF COMPUTER APPLICATION- 3 Years
Under Choice Based Credit System (CBCS)
Course Structure & Syllabus of Bachelor of Computer Application
Applicable for Batch: 2020-23
SEMESTER- I
EXAMINATION – SCHEME
Evaluation – Scheme
Credit
Course Name of
S.No. Sessional Examination
Code Course Period
ESE Total
L T P ST1 ST2 TA
Fundamental of
BCA-
1 Information 4 4 - - 10 10 20 60 100
C101
Technology
BCA- Programming in
2 4 4 - - 10 10 20 60 100
C102 'C'
BCA- Technical
3 5 4 1 - 10 10 20 60 100
A103 Communication
Mathematical
BCA- Foundation of 1
4 4 3 - 10 10 20 60 100
A104 Computer
Science
BCA- PC Packages
5 1 - - 2 40 60 100
C151 Lab
BCA- Programming in
6 1 - - 2 40 60 100
C152 'C' Lab
Course Structure & Syllabus of Bachelor of Computer Application
Applicable for Batch: 2020-23
BCA-
7 Mini Project I 1 - - 2 40 60 100
S153
Hygiene And
BCA-
8. Environmental NC 1 - - 100 - 100
V105
Health*
Total Credit= 20 Total Period =24 Total Marks=700
*It is must for the student to qualify thevalue added course with 50% marks. Marks not be
added in total.
Course Structure & Syllabus of Bachelor of Computer Application
Applicable for Batch: 2020-23
SEMESTER- II
S.No. Course Name of Course Credit Remark
Code
1 BCA-C201 Data Structure Using ‘C’ 5 CORE -3
Object Oriented Programming
2 BCA-C202 4 CORE -4
using C++
4. Ability Enhancement
BCA-A204 Environmental Science 3
Compulsory Course-III
5 BCA-C251 Data Structure Using ‘C’ Lab 1 CORE -3 Practical
6 BCA-C252 Programming using C++Lab 1 CORE -4 Practical
EXAMINATION – SCHEME
S. Evaluation – Scheme
Credit
Course
N Name of Course Period Sessional Examination
Code ESE Total
o. L T P ST1 ST2 TA
Data Structure
1 BCA-C201 5 5 - - 10 10 20 60 100
Using ‘C’
Object Oriented
2 BCA-C202 Programming 4 4 - - 10 10 20 60 100
using C++
Software
3 BCA-C203 5 4 1 - 10 10 20 60 100
Engineering
Environmental
4 BCA-A204 3 3 - - 10 10 20 60 100
Science
Data Structure
5 BCA-C251 1 - - 2 40 60 100
using ‘C’ Lab
Programming
6 BCA-C252 1 - - 2 40 60 100
using C++ Lab
7 BCA-S253 Mini Project II 1 - - 2 40 60 100
Disaster
8. BCA-V205 NC 1 - - 100 - 100
Management*
Total Credit= 20 Total Period =24 Total Marks=700
*It is must for the student to qualify thevalue added course with 50% marks.Marks not be
added in total.
Course Structure & Syllabus of Bachelor of Computer Application
Applicable for Batch: 2020-23
SEMESTER- III
Course
S.No. Name of Course Credit Remark
Code
1 BCA-C301 4 CORE-6
Database Management Systems
EXAMINATION – SCHEME
Evaluation – Scheme
Credit
SEMESTER- IV
Evaluation – Scheme
Credit
BCA- Theory of
2 4 3 1 - 10 10 20 60 100
C402 Computation
BCA- Computer
3 4 3 1 - 10 10 20 60 100
C403 Networks
BCA- Programming in
4 5 5 - - 10 10 20 60 100
C404 JAVA
BCA- Operating System
5 1 - - 2 40 60 100
C451 and Linux Lab
BCA- Programming in
6 1 - - 2 40 60 100
C452 JAVA Lab
BCA- Mini Project IV 1 - - 2
7 40 60 100
S453
Total Credit= 20 Total Period = 23 Total Marks=700
Course Structure & Syllabus of Bachelor of Computer Application
Applicable for Batch: 2020-23
SEMESTER- V
EXAMINATION – SCHEME
Evaluation – Scheme
Credit
BCA- Mobile
4 E507 Computing
4 3 1 - 10 10 20 60 100
BCA-
Cloud Computing
E508
Computer
5. BCA-
Graphics and 1 - - 2 60 100
C551 40
Animation Lab
BCA- Advance Web
E552 Technologies Lab
1 - - 2 40 60 100
6.
BCA- Advance JAVA
E553 Lab
BCA-
7. Mini Project V 1 - - 2 40 60 100
S554
SEMESTER- VI
S.No. Course Name of Course Credit Remark
Code
1 BCA-C601 Project 6 CORE-15
2 BCA-C602 Seminar 2 CORE-16
EXAMINATION – SCHEME
Evaluation – Scheme
Credit
Course
S.No. Name of Course Sessional Examination
Code Period
ESE Total
L T P ST1 ST2 TA
1 BCA-
Project 6 4 - 4 - - 150 250 400
C601
2 BCA-
Seminar 2 2 - - - - 40 60 100
C602
TOTAL
SEMESTER CC-T CC-P VAC AECC DSE-T DSE- P SEC
COURSES
I 2 2 1 2 - - 1 8
II 3 2 1 1 - 1 8
III 4 2 - - - 1 7
IV 4 2 - - - - 1 7
V 1 1 - - 3 1 1 7
VI 3 1 - - 1 1 - 6
TOTAL 17 10 2 3 4 2 5 43
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
COMPREHENSIVE TABLE
of
Bachelor of Computer Application
S. Course Name PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
No. code
1. Fundamental of
BCA-
Information 2 2 2 2 - - 2 2
C101
Technology
2. BCA-
Programming in 'C'
C102 2.4 2.6 1 - 2 1.25 2.25 2
3. BCA- Technical
1.6 2 2.6 2.6 1.6 2 2.5 2.3
A103 Communication
4. Mathematical
BCA-
Foundation of
2 2.3 2 - 2 2 2 1.3
A104
Computer Science
5. BCA- 2 - 2 3 - - 2.4 -
PC Packages Lab
C151
6. BCA- Programming in 'C' 2 1.6 2 2 2 1.2 1 2
C152 Lab
7. BCA- 2 2 2 2.5 - 3 1.4 2
Mini Project I
S153
8. BCA - Hygiene and - - 1 - - - - -
V105 Environmental Health
9. BCA- Data Structure Using 2.8 2.8 1.6 - - 2 1.6 1.5
C201 ‘C’
10. Object Oriented 2.2 2.6 3 - 2 - - 2
BCA-
Programming using
C202
C++
11. BCA- 2 1.8 3 1.5 2 2 2 2
Software Engineering
C203
12. BCA- - - 1 - 1.2 - - -
Environmental Science
A204
13. BCA- Data Structure Using 2.2 2 2 3 3 2 1 1
C251 ‘C’ Lab
14. BCA- Programming using 2.6 2.4 2.7 - 2 - - 2.2
C252 C++Lab
15. BCA- 2 2 2 2.5 - 3 1.4 2
Mini Project II
S253
16. BCA- - - 1 - 1 - - -
Disaster Management
V205
17. BCA- Database Management 2 2 2.3 2 - 2 3 2
C301 Systems
18. BCA- 2 1.3 2 1 1.6 - 1 1.5
Web Technologies
C302
19. BCA- Data Warehouse and 2 2 2 2 2.5 2 2 2
C303 Data Mining
20. Computer Based 2.3 1 2 - 1.7 - 1.5 2
BCA-
Optimization
C304
Techniques
21 BCA- Database Management - 2 2 - 2 - 3 -
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
SYLLABUS
of
Bachelor Computer Application
SEMESTER –I
CO3 Summarize the basic concepts of digital electronics that acts as the foundation for the
logic behind digital computer systems.
CO4 Build word documents as per requirement by extensive use of tools available in the
application. Apply the knowledge acquired for content creation and construction.
CO5 Design presentations and analyze data for related activities with respect to particular
functional area.
Text Books:
1. V. Rajaraman, “Fundamentals of Computers”, Prentice Hall India Pvt., Limited
2. Yatendra Kumar, “Basics of Information Technology”, BBPP.
References:
1. Anurag Seetha, “Introduction to Computers and Information Technology”, Ram Prasad & Sons, Bhopal.
2. S.K.Basandra, “Computers Today “, Galgotia Publications.
3. Alexis Leon & Mathews Leon, “Fundamentals of Information technology”, Vikas Publishing House, New Delhi.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - - - - - - 2
CO2 2 2 - - - - - -
CO3 2 - - - - - -
CO4 - - 2 2 - - - -
CO5 2 - - 2 - - 2 -
Articulated Average CO 2 2 2 2 - - 2 2
CO1 Understand the basic concepts of C language and develop programming skills.
CO2 Develop Analytical / Logical Thinking and Problem Solving capabilities.
CO3 Design algorithm using concepts of Computer and Information Technology to
formulate programs for the real time problems
CO4 Develop sound technical knowledge of programming to enhance employability
CO5 Apply the concept of C programming using critical thinking and creativity skills to
solve complex problems.
Text Books
1. E. Balagurusamy, “Programming with ANSI-C”, Fourth Edition, 2008, Tata McGraw Hill.
2. Kanetkar Y, “Let us C”, BPB Publications, 2007.
Reference Books:
1. Byron S Gottfried “Programming with C” Second edition, Tata Mc Grawhill, 2007.
2. Venugopal K. R and Prasad S. R, “Mastering ‘C’”, Third Edition, 2008, Tata McGrawHill.
3. B.W. Kernighan & D. M. Ritchie, “The C Programming Language”, Second Edition.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
UNIT-V
Letter Writing (Formal/Informal), Memorandums, Writing Notices & Articles, E-mails,
Report Writing, Technical Proposals. Preparation for Job: Writing Application for jobs,
writing effective curriculum vitae, preparing for Interviews and Group discussion.
Course Outcomes (CO)
CO1 Acquire in-depth knowledge of the communication, apply for effective correspondence
with team and critically understand the requirements or real-time technical problems for
which solution can be designed thus creating a ground for future learning .
CO2 Demonstrate critical understanding, thinking and writing ability by making an optimum
use of correct vocabulary & grammar thus identify alternative solutions for technical or
business issues
CO3 Enhance the writing skills, learn the writing process (prewriting/writing/rewriting) and
apply them to design and develop appropriate technical and workplace documentation.
CO4 Acquire skills to modify body language and use ethically sound verbal/non-verbal skill,
while interaction or making presentations to create an impact on the audience thus
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
enhances employability
CO5 Develop listening and impressive speaking skills, demonstrating professional, ethical
and public-facing attributes for an entrepreneurs or executives of different cultural
backgrounds and utilize appropriate formats and conventions derived from individual
disciplines.
Text Books:
1. Meenakshi Raman & Sangeeta Sharma, “Technical Communication – Principles and Practice”, Oxford University
Press, Sixteenth Impression 2007.
2. Meenakshi Raman & Prakash Singh, “Business Communication”, Oxford University Press, Seventh Impression
2008.
Reference Books:
1. Herta A Murphy, Herbert W. Hilderbrandt & Jane P. Thomas, “Effective Business Communication”, Tata McGraw
Hill Publication.
2. Asha Kaul ,” Effective Business Communication”, Prentice-Hall India Pvt. Ltd., March 2008.
3. B. N.Basu, ”Technical Writing” , Prentice-Hall India Pvt. Ltd.,2007.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - 3 2 - - 3 3
CO2 1 2 2 3 2 2 2 2
CO3 - 2 3 3 - 2 - -
CO4 2 - 2 - 1 - - -
CO5 - 2 3 - 2 - - 2
Articulated Average CO 1.6 2 2.6 2.6 1.6 2 2.5 2.3
UNIT-IV
Prepositional Logic: Preposition, First order logic, Basic logical operations, Tautologies,
Contradictions, Algebra of Proposition, Logical implication, Logical equivalence, Normal
forms, Inference Theory, Predicates and quantifiers.
UNIT-V
Lattices: Introduction, Posets, Hasse Diagram, compound Lattice, Bounded Lattice,
complemented Lattice and Distributive Lattice.
Course Outcomes (CO)
CO1 Ability to apply knowledge of mathematics, science, and engineering to solve practical
problems.
CO2Analyze a problem and identify and define the computing requirements for solution.
CO3 Acquire ability to describe computer programs (e.g. recursive functions) in a formal
mathematical manner.
CO4 Ability to express and analyze logic sentence in terms of predicates, quantifiers, and
logical connectives.
CO5 Apply the technical knowledge to generating the function and recurrence relations to
solve the problems.
Text Books:
1. J. k Sharma, “Discrete Mathematics”, Macmillan.
2. Gersting, "Mathematical Structure for Computer Science", WH freeman and Macmillan
Reference Books:
1. Liptschutz Seymour, "Discrete Mathematics", TMH.
2 J.P Trembley & R. Manohar, "Discrete mathematical Structure with Application to Computer Science", TMH.
3 H. Rosen Kenneth, "Discrete Mathematics and its applications', TMH.
4 Doerr Alan and Levasseur Kenneth, "Applied Discrete Structure for Computer
Science”, Galgotia Pub. Pvt. Ltd.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
UNIT-III
Features of Personal Hygiene: Meaning of Personal Hygiene, Importance of Personal Hygiene,
Difference between Cleanliness and Hygiene, Components of Personal Hygiene, How to
Improve and Promote Hygiene
References:
1. Bassett W.H. (ed.) (2004) Clay’s Handbook of Environmental Health 19th ed, London, Spon Press.
2. UNICEF (2009) Community Approaches to Total Sanitation, Field Notes.
http://www.unicef.org/evaluation/files/CATS_field_note.pdf
3. WHO (1996) Participatory hygiene and sanitation transformation: A new approach to working with communities.
http://www.who.int/water_sanitation_health/hygiene/envsan/phast/en/
4. WHO (1998) Participatory Hygiene and Sanitation Transformation (PHAST) Step-by-step Guide: A Participatory
Approach for the Control of Diarrhoeal Diseases.
5. http://www.who.int/water_sanitation_health/hygiene/envsan/phastep/en/
Examination Scheme:
Components MSE Total
Weightage (%) 100% 100%
UU
and linking it with the word document using a utility called Mail Merge. The list of
invitee should not be less than 15. Apply formatting to the invitation- apply page
borders to the final merged document. Provide the word "birthday invitation " in the
header part and "name and contact number" in the footer part.
Practical No. 7. Create the following table in MS Word and name it as UIM-Student.
Practical No. 9. Create the record of at least 10 students in MS Excel consisting of the
following Columns:-
Column 1. Serial number
Column 2. Roll number
Column 3. University ID
Column 4. Your name
Column 5. Father’s name
Column 6. Mother’s name
Column 7. Address
Column 8. Your contact number
Column 9. Father’s contact number
Column 10. Mother’s contact number
Column 11. Date of birth
Column 12. Total Marks obtained in previous semester
Column 13. Percentage obtained in previous semester
Consider the following sample table:
Practical No. 11. In the above task include the following column as well:
Column 11. Display remarks as “Excellent” if percentage of student is greater than or equal
to 85 but less than 95 and display remarks as “Distinction” if percentage is greater than or
equal to 95 but less than or equal to 100.
Practical No. 12. Consider the following sample data of students:
S. No. Male Height Female Height
1 159 152
2 162 148
3 163 156
4 164 155
Course Outcomes:
CO1 Examine the connection of various hardware components of computer system and its
peripherals. Implement and identify the interaction between various hardware and
software components.
CO2 Apply and implement significant internal and external DOS commands to understand
their functionality.
CO3Apply significant concepts of text editing in the application software.
CO4 Apply and analyze numerical data pertaining to some mathematical problem to aid in
problem solving using application software.
CO5Demonstrate and develop effective presentations using application software.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 - 1 1 1 2 1 2
CO2 3 2 1 - - 1 1 2
CO3 1 2 3 - 3 1 1 2
CO4 1 1 3 - - 1 1 2
CO5 - - - 3 - 1 1 2
Articulated Average CO 2 1.6 2 2 2 1.2 1 2
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 2 1 - - 3 2 2
CO2 2 2 2 2 - 3 2 2
CO3 - 3 2 - - 3 1 2
CO4 1 1 3 - - 3 1 2
CO5 - - - 3 - 3 1 2
Articulated Average CO 2 2 2 2.5 - 3 1.4 2
SEMESTER- ll
CO3 Illustrate and compare various tools and techniques for algorithms and programming.
CO4 Acquire sound knowledge of data structure techniques to enhance the employability
status.
CO5 Build skills in designing algorithms for various applications to enhance competitive
skills and lifelong learning in the broadest context of technological change.
Text Books:
1. G. S. Baluja, “Data Structures through C”, Dhanpat Rai Publication.
2. Horowitz and Sahani, "Fundamentals of data Structures", Galgotia Publication.
Reference Books:
1. R. Kruse etal, "Data Structures and Program Design in C", Person Education.
2. A.M. Tenenbaum etal, "Data Structures and Program Design in C”, Person Education.
3. Lipschutz, "Data Structure", TMH.
4. K Loudon, "Mastering Algorithms with C", Shroff Publishers and Distributors.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 3 1 - - - 1 1
CO2 3 3 1 - - 2 1 1
CO3 3 3 2 - - - - -
CO4 2 2 2 - - - 3 2
CO5 3 3 2 - - - - 2
Articulated Average CO 2.8 2.8 1.6 - - 2 1.6 1.5
Text Books:
1. Robert Lafore,” Object-Oriented Programming in C++”, (4th Edition), SAMS
Reference Books:
1. E. BalaguruSwamy,”Object Oriented Programming with C++”, 6th Edition, TMH.
2. Robert Lafore,” Object-Oriented Programming in C++”, (4th Edition), SAMS
3. Al Stevenes ,“C++ Programming”, Wiley Dreamtech.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 3 3 - 2 - - -
CO2 - 3 3 - 2 - - 2
CO3 2 2 - - - - -
CO4 2 - 3 - 2 - -
CO5 2 - 3 - 2 - - 2
Articulated Average CO 2.2 2.6 3 - 2 - - 2
software.
CO2Students are able to analyze and identify the software requirement specification and
software matrices. So that efficient software can be developed.
CO3 Demonstrate an understanding of and apply current theories, models, and techniques of
software engineering to bring out innovative and novelistic solutions for the growth.
CO4The potential to develop software engineering capabilities skills to improve technological
expertise and employability.
CO5 Demonstrate the basic principles and relevance of project management software
principles such as cost estimating, scheduling, and analyzing the progress that helps to
enhance employability.
Text Books:
1. K. K Aggrawal. “Software Engineering”, New Age Publication.
2. Roger S. Pressman, “Software Engineering: A Practitioner's Approach”, McGraw Hill 2001.
Reference Books:
1. Pankaj Jalote , "Software Engineering", New Delhi: Narosa 2002.
2. David Gustafson ,”Software Engineering” , Schaum's Series, TMH.
3. Ghezzi Carlo, "Fundamentals of Software Engineering"
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 2 3 1 2 - - 2
CO2 2 3 - - 2 - - -
CO3 2 1 - - - 2 2 -
CO4 2 - 2 2 - 1 2
CO5 2 1 - - - - 3 2
Articulated Average CO 2 1.8 3 1.5 2 2 2 2
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
Course Outcome PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 - - - - 1 - - -
CO2 - - - - 2 - - -
CO3 - - - - 1 - - -
CO4 - - - - 1 - - -
CO5 - - 1 - 1 - - -
Articulated Average CO - - 1 - 1.2 - - -
Q3.Design, Develop and Implement a menu driven Program in C for the following operations
on two dimensional arrayof Integers
a. Find addition of two matrix
b. Find transpose of a matrix
c. Find multiplication of two matrix
d. Find addition of two matrix
e. Determine given matrix is sparse or not.
f. Exit
Support the program with appropriate functions for each of the above operations
Q4.Design, Develop and Implement a menu driven Program in C for the following operations
on RECURSION
a. Find factorial of an element
b. Find Fibonacci series
c. Find power of a number
d. Find sum of all digits
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
e. Exit
Support the program with appropriate functions for each of the above operations
Q5.Design, Develop and Implement a menu driven Program in C for the following operations
on Singly Linked List (SLL) of Student Data with the fields: USN, Name, Branch, Sem, PhNo
a. Create a SLL of N Students Data by using front insertion.
b. Display the status of SLL and count the number of nodes in it
c. Perform Insertion and Deletion at End of SLL
d. Perform Insertion and Deletion at Front of SLL
e. Perform Insertion and Deletion at given position of SLL
f. Reverse the elements of SLL
g. Exit
Q6. Design, Develop and Implement a menu driven Program in C for the following operations
on STACK of Integers (Array Implementation of Stack with maximum size MAX)
a. Push an Element on to Stack
b. Pop an Element from Stack
c. Demonstrate how Stack can be used to check Palindrome
d. Demonstrate Overflow and Underflow situations on Stack
e. Display the status of Stack
f. Exit
Support the program with appropriate functions for each of the above operations
Q7.Design, Develop and Implement a menu driven Program in C for the following operations
on STACK of Integers using Linked List
a. Push an Element on to Stack
b. Pop an Element from Stack
c. Demonstrate Overflow and Underflow situations on Stack
d. Display the status of Stack
e. Exit
Support the program with appropriate functions for each of the above operations
Q9.Design, Develop and Implement a menu driven Program in C for the following operations
on
Linear QUEUE of Characters (Array Implementation of Queue with maximum size MAX)
a. Insert an Element on to Linear QUEUE
b. Delete an Element from Linear QUEUE
c. Demonstrate Overflow and Underflow situations on Linear QUEUE
d. Display the status of Linear QUEUE
e. Exit
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Support the program with appropriate functions for each of the above operations
Q10.Design, Develop and Implement a menu driven Program in C for the following operations
on Circular QUEUE of Characters (Array Implementation of Queue with maximum size MAX)
a. Insert an Element on to Circular QUEUE
b. Delete an Element from Circular QUEUE
c. Demonstrate Overflow and Underflow situations on Circular QUEUE
d. Display the status of Circular QUEUE
e. Exit
Support the program with appropriate functions for each of the above operations
Q11.Design, Develop and Implement a menu driven Program in C for the following Searching
and Sorting operations using Array
a. Perform Linear Search
b. Perform Binary Search
c. Demonstrate Selection Sorting operation
d. Demonstrate Bubble sorting operation
e. Demonstrate Insertion Sorting operation
f. Demonstrate Quick sorting operation
e. Exit
Support the program with appropriate functions for each of the above operations
Q12.Design, Develop and Implement a menu driven Program in C for the following operations
on Binary Search Tree (BST) of Integers:
a. Create a BST of N Integers: 6, 9, 5, 2, 8, 15, 24, 14, 7, 8, 5, 2
b. Traverse the BST in Inorder, Preorder and Post Order
c. Search the BST for a given element (KEY) and report the appropriate message
d. Delete an element(ELEM) from BST
e. Exit
Course Outcomes:
CO1Infer the familiarity with algorithms and basic concepts of Data Structures and
programming skills.
CO2 Infer the familiarity with basic concepts of Function, Array and Link-list and formulate
algorithm for problems.
CO3Apply and practice logical formulations of Stack, Queues, Trees and various Sorting and
searching algorithm designs and develop solutions to complex problems.
CO4Design new algorithms that efficiently solve computing problems in real world.
CO5Rephrase the acquired technical communication skills in the form of documentation of
the carried out lab work.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
CO-PO Articulation Matrix:
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
in meters and centimeters and DB in feet and inches. Write a program that can read
values for the class objects and add one object of DM with another object of DB. Use a
friend function to carry out the addition operation. The object that stores the results
may be a DM object or DB object, depending on the units in which the results are
required. The display should be in the format of feet and inches or meters and
centimeters depending on the object on display.
6. Create a class rational which represents a numerical value by two double values-
NUMERATOR & DENOMINATOR. Include the following public member
Functions:constructor with no arguments (default). constructor with two arguments.
void reduce( ) that reduces the rational number by eliminating the highest common
factor between the numerator and denominator. Overload + operator to add two
rational number. Overload >> operator to enable input through cin. Overload <<
operator to enable output through cout. Write a main ( ) to test all the functions in the
class.
9. Imagine a toll booth with a class called toll Booth. The two data items are a type
unsigned int to hold the total number of cars, and a type double to hold the total
amount of money collected. A constructor initializes both these to 0. A member
function called payingCar ( ) increments the car total and adds 0.50 to the cash total.
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Another function, called nopayCar ( ), increments the car total but adds nothing to the
cash total. Finally, a member function called displays the two totals. Include a program
to test this class. This program should allow the user to push one key to count a paying
car, and another to count a nonpaying car. Pushing the ESC kay should cause the
program to print out the total cars and total cash and then exit.
10. Write a function called reversit ( ) that reverses a string (an array of char). Use a for
loop that swaps the first and last characters, then the second and next to last characters
and so on. The string should be passed to reversit ( ) as an argument. Write a program
to exercise reversit ( ). The program should get a string from the user, call reversit ( ),
and print out the result. Use an input method that allows embedded blanks. Test the
program with Napoleon s famous phrase, Able was I ere I saw Elba) .
11. Make a class Employee with a name and salary. Make a class Manager inherit from
Employee. Add an instance variable, named department, of type string. Supply a
method to string that prints the manager s name, department and salary. Make a class
Executive inherit from Manager. Supply a method to String that prints the string
Executive followed by the information stored in the Manager superclass object. Supply
a test program that tests these classes and methods.
12. Create a base class called shape. Use this class to store two double type values that
could be used to compute the area of figures. Derive two specific classes called triangle
and rectangle from the base shape. Add to the base class, a member function get_data (
) to initialize base class data members and another member function display_area ( ) to
compute and display the area of figures. Make display_area ( ) as a virtual function and
redefine this function in the derived classes to suit their requirements.Using these three
classes, design a program that will accept dimensions of a triangle or a rectangle
interactively and display the area.
Remember the two values given as input will be treated as lengths of two sides in the
case of rectangles and as base and height in the case of triangles and used as follows:
Area of rectangle = x * y,
Area of triangle = ½ * x * y
Course Outcomes:
CO1 Understand the working of C++ IDE with the fundamentals concepts of programming
and implement the solution for mathematical problems.
CO2 Develop and implement solutions for various problems using OOPs concepts like
Class, objects
CO3 Analysis and implement the reusable applications using inheritance.
CO4 Learn to create the solutions of complex applications using pointers and polymorphism
in C++ programming
CO5 Enhance technical knowledge to design console based applications to solve complex
mathematical and business problems using file handling, , exception handling and
template programming.
Examination Scheme:
UNIT-IV
List of reports to be generated, future scope and further enhancement of the project.
UNIT-V
Appendices, Coding, bibliography.
Course Outcomes:
CO1 Define the problems in various domains that can be solved using computer
applications.
CO2 Develop the ability to identify alternative solutions and plan the project.
CO3 Analyze and Design the software development process.
CO4To develop coding and testing skills for software development.
CO5 Build technical presentation skills and Create project documentation of the complete
process.
Text Books:
1. K. K Aggrawal. “Software Engineering”, New Age Publication.
2. Roger S. Pressman, “Software Engineering: A Practitioner's Approach”, McGraw Hill2001.
3. Robert Lafore,” Object-Oriented Programming in C++”, (4th Edition), SAMS
Reference Books:
1. Pankaj Jalote , "Software Engineering", New Delhi: Narosa 2002.
2. David Gustafson ,”Software Engineering” , Schaum's Series, TMH.
3. Ghezzi Carlo, "Fundamentals of Software Engineering"
4. Robert Lafore,” Object-Oriented Programming in C++”, (4th Edition), SAMS
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
SEMESTER- III
Timestampingprotocolsforconcurrencycontrol,validationbasedprotocol,multiplegranularity,
Multi-versionschemes, Recovery with concurrent transaction.
Course Outcomes:
CO1Understand the vital concepts of database management system and its architecture.
CO2Summarize the significance of database management system over traditional file based
system.
CO3Understand the concept of database normalization and its significance.
CO4Comprehend the transaction processing and recovery concepts.
CO5Understand the concept of concurrency control and Serializability in the context of
databasemanagement system.
Text Books:
1. Ivan Bayross. “SQL , PL/SQL the Programming Language of Oracle”, BPB.
2. Korth, Silbertz, Sudarshan, "Database Concepts" McGraw Hill.
Reference Books:
1. C.J. Date, "An Introduction to Database System", Addision Wesley.
2. Elmasri Navathe, "Fundamentals of Database Systems", Addision Wesley.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - 2 2 - - -
CO2 - - 2 - - - - -
CO3 2 2 3 - - - 3 2
CO4 2 - - - - 2 - -
CO5 2 - - - - 2 - -
Articulated Average CO 2 2 2.3 2 - 2 3 2
CO2Learn to create static web pages by analyzing the existing problems in real time
environment using font tags, list tags, table tags, frame tags, form tags & anchor tags.
CO3Develop the web designing skills using CSS and learn the programming concept of client
side scripting using JavaScript.
CO4Implement the server side scripting on the web application using PHP.
CO5Develop technical knowledge of database connectivity and validation of web application
through MySQL, PHP and JavaScript so that student can meet the current industry.
academic and research requirement.
Text Books:
1. Ivan Bayross, "Web Technologies Part-Ii", BPB Publications.
2. Steven, Hoizner. “The Complete Reference PHP”, MGH.
Reference Books:
1. J. Burdman, "Collaborative Web Development", Addison Wesley.
2. Sharma & Sharma, "Developing E-Commerce Sites", Addison Wesley.
3. Shishir Gundavarma,”Cgi Programming on the World Wide Web", O'reilly & Associate.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 1 - - 1 1 - 1
CO2 2 2 - 1 1 - - -
CO3 - 1 2 - 2 - - -
CO4 2 - 2 - 2 - - -
CO5 - - 2 - 2 - 1 2
Articulated Average CO 2 1.3 2 1 1.6 - 1 1.5
data mining.
CO5 Outline the prominent sub domains of web data mining and text data mining.
Text Book:
1. Jiawei Han and Micheline Kamber, “Data Mining: Concepts and Techniques”, 3rd edition, Kindle Edition.
Reference Book:
1. Alex Berson, “Data Warehousing, Data Mining & OLAP”,Tata McGraw-Hill Education, 01-Mar-2004.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - 2 - - 2 - -
CO2 - - - 2 2 - - -
CO3 - - - 2 - - -
CO4 - 2 - - 3 - 2 2
CO5 2 - - - - - - 2
Articulated Average CO 2 2 2 2 2.5 2 2 2
UNIT-II
The Simplex Method: Solution of LPP By Simplex Method, Exceptional Cases, Artificial
Variable Techniques (Big M), Two Phase of Simplex Method, Problem of Degeneracy.Dual
Simplex Method: - Dual and Primal Problem, Duality and Simplex Method, Solution of LPP
Using Revised Simplex Method.
UNIT-III
Special Types of Linear Programming Problems: Standard Transportation Problem, Balanced
Transportation Problem, VAM Method, Degeneracy in Transportation Problem, Assignment
Problems and its Solution by Hungarian Method. Game Theory.
UNIT-IV
Integer Programming: Introduction, Branch and Bound Techniques, Gomory’s Plane Cut and
Mix Cut Methods, Binary Linear Programming. Dynamic Programming: Basic Concepts,
Bellman’s Optimality Principles of D.P. Models and Computations.
UNIT-V
Queuing Models: Notations and Assumptions, Elements and Characteristics of Queing
Systems, Measurement of System Performance, Queing Models: Basic Single Channel Model,
Multiple Channel Model, Other Queuing Models: Poisson Arrival Rate With Any Service
Distribution, Finite Queue Length, Multiple Server, Priority Servicing Model.
Course Outcomes:
CO1 Understand and apply the concept of optimization and classification to solve practical
optimization problems.
CO2 Knowledge of applying evaluation optimization technique in engineering applications.
CO3 Apply the technical knowledge and critical thinking to model engineering
minima/maxima problems as optimization problems.
CO4 Apply the technical and critical thinking to integrate various resources for
optimization inthe industry as well as for strategic utilization of IT-enabled services
and functions.
CO5 Apply the Queuing Models techniques to solve the real world problem and also
develop the skills to identify the solution of the optimization problem.
Text Books:
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
employee_email_id Varchar2 30
employee_contact_no Number 12
i) Add a new column named employee_addresshaving data type as varchar2, size 30 in the
uim_employee table.
ii) Update the addresses of existing uim_employees in the table.
iii) Drop the column named employee_date_of_joining from the table.
iv) Modify the size of the column named employee_contact_no to 14.
v) Rename the table to employee_details from the table name uim_employee.
vi) Truncate as the records from the employee_details table.
vii) Drop the table named employee_details.
Practical No. 3. Implementation of keys and constraints concept. Create a table
named uim_student having attributes such as: student’s roll number, student’s name,
student’s date of birth, student’s course, student’s house address, student’s contact
number, student’s aadhaar number. The attribute named: student_roll_no has a
PRIMARY KEY constraint, student_name has NOT NULL constraint, student_
aadhaar _no as UNIQUE constraint.
Consider the following table:
Attribute Datatype Size Constraint
student_roll_no Number 3 PRIMARY KEY
student_name Char 25 NOT NULL
student_date_of_birth Date - -
student_course Varchar 15 -
student_address Varchar2 30 -
student_contact_no Number 10 -
student_aadhaar_no Number 12 UNIQUE
i) Describe the structure of uim_student table.
ii) Insert few tuples in the table.
iii) Examine the error message by inserting same student_roll_no values for two rows. Write the
error message and reason.
iv) Examine the error message by NOT inserting student_name value in a row in the table. Write
the error message and reason.
v) Examine the error message by inserting same student_ aadhaar_no values for two rows.
Write the error message and reason.
Practical No. 4. Implementation of Foreign key concept using two tables named:
uim_employee and uim_department. The employee table has employee’s id, employee’s
name and employee’s department number. The department table has department
number, department name and department location.
Consider the following two tables:
Table name: uim_employee Table name: uim_department
Attribute Data Siz Constra Attribute Data Siz Constra
type e int type e int
employee_id Char 8 - department_no Numb 3 PRIMA
er RY
KEY
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Practical No. 7. Extract the data from both the tables by performing join. Given two
tables named: uim_employee and uim_department. The employee table has attributes
related to employee’s id, employee’s name and employee’s department number. The
department table has attributes related to department number, department name and
department location.
Consider the following two tables:
Table name: uim_employee Table name: uim_department
Attribute Data Siz Constra Attribute Data Siz Constra
type e int type e int
employee_id Char 8 - department_no Numb 3 PRIMA
er RY
KEY
employee_name Varcha 20 - department_na Char 15 -
r2 me
employee_departme Numb 3 FOREIG department_loc Varcha 20 -
nt_no er N KEY ation r2
i) Display the structure of uim_employee table
ii) Display the structure of uim_department table
iii) Insert at least three department details in the department table.
iv) Display the data of uim_department table.
v) Insert employee’s details in uim_employee table who workin the corresponding departments
as in the uim_department table.
vi) Display the data of uim_employee table.
vii) Display employee_id, employee_name, department_no and department_name of employees
from both the tables uim_employee and uim_department by performing join.
viii) Display employee_id, department_no, department_name and department_location of
employees from both the tables uim_employee and uim_department by performing join.
Practical No. 8. The data in the table can be grouped based on certain attributes.
Consider the book table having attributes as book_id, book_name, book_theme and
book_price.
Consider the table below:
Table name: uim_book
Attribute Datatype Size Constraint
Book_id Number 10 PRIMARY KEY
book_name Varchar2 25 NOT NULL
book_theme Char 4 CHECK
Note: the book_theme can either be 'it' or 'mgt' only.
i) Add a new column named book_price having data type as Number and size as 7,2 in the
exisiting table named uim_book.
ii) Display the contents of uim_book table.
iii) Update the book prices of available books in the uim_book table.
iv) Display the contents after updation in uim_book table.
v) Find the sum of all the book price based on the book theme.
vi) Display the maximum book_price in each group of book_theme.
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Practical No. 9. There are numerous aggregate functions that can be performed on
table(s). Consider the attributes in the employee table as: employee’s id, employee’s
name, employee’s department number, employee’s designation, employee’s date of
joining, employee’s salary, employee’s email id, employee’s contact no and employee’s
aadhaar number.
Consider the following uu_employee table:
Course Outcomes:
CO1 Demonstrate the concepts of creation of tables, views and indexes.
CO2 Demonstrate the concept of keys and constraints on the tables.
CO3 Illustrate the concept of data and structure manipulation.
CO4 Demonstrate the use of various aggregate functions in SQL on data.
CO5 Illustrate the data segregation using various operators in SQL.
Examination Scheme:
Components Internal External Total
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
<100 Rs 3/Unit
Between 100 and 200 Rs 4/Unit
Between 201 and 300 Rs 5/Unit
>301 Rs 6 /Unit
Q10. Design an HTML form to input the salary details of an employee (Employee name, Basic
pay, DA and HRA). Write a PHP script to accept user input data and store it in a text file.
Write a PHP script to display the contents of the file.
Q11. Develop a PHP program to implement a session based counter which counts the number
of how time dose the user view the web page for this create a session variable using PHP.
Display the session variable using PHP.
Q12. Create a PHP program to develop a web application which display the result of the
student I which users inputs the marks list of the student and connect to a database and retrieve
data from a table and show the details in a neat format
a) Mark list of a student is entered and saved to MySQL table using PHP
b) Data stored in MySQL table is displayed
Course Outcomes:
CO1 Understand the concepts of basic html tags like list tags, table tags, frame tags, form
tags to develop the static web pages
CO2 Enhance the view of web pages through web designing techniques using CSS.
CO3 Learn the basic concepts of client side scripting and various validations constructs
using JavaScript.
CO4 Learn the fundamental concepts of server side scripting and basic programming
concepts using PHP.
CO5 Develop technical knowledge of database connectivity and validation of web
application through MySQL, PHP and JavaScript so that student can meet the current industry,
academic and research requirement.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
SEMESTER- IV
Text Books:
1. Silberschatz and Galvin, “Operating System Concepts 6/ed”, Addison Wesley.
2. Sumitabha Das, “Unix and Shell Programming”, TMH.
Reference Books:
1. Milenkovic, “Operating System: Concept 2E”, Tata McGraw-Hill Education.
2. William Stalling, “Operating Systems: Internals and Design Principles 5/ed”, PHI.
3. A. Tanenbaum, “Modern operating Systems”, PHI.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - - - - - 3 3
CO2 2 - - - - - 3 2
CO3 2 - - - - - 3 3
CO4 2 2 - - - - 3 2
CO5 2 3 - - 3 - 3 3
Articulated Average CO 2 2.5 - - 3 - 3 2.6
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 3 - - 3 2 3 3
CO2 3 3 - - 3 - 2 2
CO3 3 3 - - 3 2 2 2
CO4 3 3 - - 3 2 2 2
CO5 2 2 - - - - 2 2
Articulated Average CO 3 3 - - 3 2 2.2 2.2
References:
Text Books:
1. Forouzan, "Data Communication and Networking”, TMH.
Reference Books:
1. A.S. Tanenbaum, "Computer Networks”, 3rd Edition," PHI
2. W. Stallings, "Data and Computer Communication", Macmillan Press.
3. Comer, "Internetworking with TCP/IP", PHI.
4. Comer, "Computer networks & inter", PHI.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
directory as well as all its subdirectories at all levels must be searched. The script need not
include any error checking
Q 9:-
Design, Develop and implement a shell script that reports the logging in of a specified user
within one minute after he/she logs in. The script automatically terminates if the specified user
does not login during a specified period of time
Q10:-
Design, Develop and implement a shell script that folds long lines into 40 columns. Thus any
line that exceeds 40 characters must be broken after 40th ; a\ is to be appended as the
indication of folding and the processing is to be continued with the residue. The input is to be
through a text file created by the user.
Q11:-
Design, Develop and implement a shell script to implement terminal locking (similar to the
lock command) .it should prompt the user for the password .after accepting the password
entered by the user it must prompt again for the matching password as confirmation and if
match occurs it must lock the keyword until a matching password is entered again by the user
,note that the script must be written to disregard BREAK,control-D. No time limit need be
implemented for the lock duration.
Q 12:-
Design , Develop and Implement a shell script that delete all lines containing a specific word
in one or more file supplied as argument to it.
Course Outcomes (CO)
CO1 Ability to identify the basic Linux general-purpose commands.
CO2 Apply and change the ownership and file permissions using advanced Linux
commands.
CO3 Use the pwd, Sed,grep,chmod,sudo etc.
CO4 Implement and execute shell scripts.
CO5 Analyze and apply various tasks of administrator.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Practical 2. Design an interface called to fly with two methods godown() and go forward().
these methods would not contain any logic but each class. create class duck and finch to
implement the interface . finally, create a bird class and call the required method.
Practical 3. Design a Java applet that works as a simple calculator. use a grid layout to arrange
buttons for the digits and for the +, -,*, % operations. add a text field to display the result.
handle any possible exceptions like divide by zero.
Practical 4. Design a program that creates a user interface to perform integer divisions. the
user enters two numbers in the text fields, num1 and num2. the division of num1 and num2 is
displayed in the result field when the divide button is clicked. if num1 or num2 were not an
integer, the program would throw a number format exception. if num2 were zero, the program
would throw an arithmetic exception display the exception in a message dialog box.
Practical 5. Design a java program that implements a multi-thread application that has three
threads. first thread generates random integer every 1 second and if the value is even, second
thread computes the square of the number and prints. if the value is odd, the third thread will
print the value of cube of the number.
Practical 6. Develop a java program to create an abstract class named shape that contains two
integers and an empty method named printarea(). provide three classes named rectangle,
triangle and circle such that each one of the classes extends the class shape. each one of the
classes contains only the method printarea( ) that prints the area of the given shape.
Practical 7. Design a jframe with jmenu, jmenubar and jenumitem as shown in the following
figure
Practical 07. Design a table called emp and store the data in the table using java JDBC. the
schema of the table is given below
create table emp(id int(10),name varchar(40),age int(3));
Practical 08. Design an fFrame in java swing with a button, once the user will hit on the button
it will open a new jframe with a welcome message.
Practical 09. Design an HTML page with a text field an button user will search for a string in
the text field and will press the enter button and search for the string on google using
sendreirect() method of servlet
Practical 10. Develop aprogram in java swing to change background color of a frame
(using action event)
Sample output
Practical 11 Design a swing frame and divide the frame into 4 regions with a label on each
section using border-layout in java.
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Practical 12- Create a GUI form to perform insert, update delete the information’s of student
using Java JDBC
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 - 3 3 - - - 3 -
CO2 - 3 3 - - - 3 2
CO3 - 3 3 - - - 3 2
CO4 - 2 2 - 2 - 3
CO5 - 2 3 - 2 - 3 2
Articulated Average CO - 2.6 2.8 - 2 - 3 2
SEMESTER- V
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO2 Able to analyze and determine software security and vulnerabilities solutions to reduce
the risk of exploitation.
CO3 Implement cyber security solutions and use of cyber security, information assurance,
and cyber/computer forensics software/tools.
CO4Able to design and develop security architecture for an organization.
CO5 Able to implement various computer cyber security tools and methods to reduce risk of
cyber attacks.
References:
Text Books:
1. Anti-Hacker Tool Kit (Indian Edition) by Mike Shema, Publication Mc Graw Hill.
Reference Book
1. Nina Godbole and Sunit Belpure,”Cyber Security Understanding Cyber Crimes, Computer Forensics and Legal
Perspectives” , Publication Wiley
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
identification of problem.
CO5Understand mobile digital marketing techniques like SMS content, developing Mobile
responsive websites and apply them to solve marketing problem.
References:
Text Books:
1. Wiley, Ian Dobson “The Art of Digital Marketing: The Definitive Guide to Creating
Strategic, Targeted, and Measurable Online Campaigns”.
2. Pearson, Puneet Singh Bhatia “Fundamentals of Digital Marketing”.
Reference Books:
1. Oxford Universty Press , Vandana Ahuja “Digital Marketing”.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 - 2 - - - 2 -
CO2 2 1 - 2 - - 1 2
CO3 2 1 - - - 2 - -
CO4 2 2 - - 2 - - -
CO5 2 - - - 2 - 2 -
Articulated Average CO 2 1.3 2 2 2 2 2 2
UNIT- I
Meaning of ERP, Difference between Organization and Enterprise, Enterprise wide
information system, Custom built and packaged approaches, Needs and Evolution of ERP
Systems, Common myths and evolving realities, Relevance to Data Warehousing, Data
Mining and OLAP, ERP Drivers, Decision support system.
UNIT-II
ERP Domain, ERP Benefits classification, milestones and pitfalls, Forecast, Market players
and profiles, Evaluation criterion for ERP product, ERP Life Cycle: Adoption Decision,
Acquisition, Implementation, Use & Maintenance, Evolution and Retirement phases, ERP
Modules.
UNIT-III
Framework for evaluating ERP acquisition, Analytical Hierarchy Processes (AHP),
Applications of AHP in Evaluating ERP, Selection of Weights, Role of consultants, vendors
and users in ERP implementation; Implementation vendor’s evaluation criterion, ERP
Implementation approaches and methodology, ERP Implementation strategies, Critical success
and failure factors for implementation,ERP Customization, ERP-A manufacturing Perspective
UNIT-IV
Business Process Reengineering and Information Technology, Supply Chain Management,
Model for improving ERP effectiveness, ROI of ERP Implementation, Hidden costs, ERP
success inhibitors and accelerators, Management concern for ERP Success.
UNIT-V
Extended ERP, Case Studies Development and Analysis of ERP Implementations in focusing
the various issues discussed in above units through Soft System approaches or Qualitative
Analysis tools, Learning and Emerging Issues, ERP and E-Commerce, Present global and
Indian market scenario.
Course Outcomes (CO)
CO1 Understand the basic concepts, problem analysis, different Modules and Packages of
Enterprise Resource Planning.
CO2 Identify the steps and activities in the ERP life cycle and be able to design the ERP
life cycle stages for any new and existing system.
CO3 To understand the OLAP and OLTP operations and develop strategic Business
Database.
CO4 Understand the basic concepts of Data Warehouse, Data Mine, Business Process
Reengineering, Supply Chain Management, and Decision Support System for
successful ERP implementation to meet the current industry requirement.
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
CO5 Development and Analysis of ERP Implementations in focusing the various issues
through Soft System approaches for present global and Indian market scenario.
References:
Text Books:
1. A. Lexis Leon, “Enterprise Resource Planning”, TMH
Reference Books:
1. Brady, Manu, Wegner, “Enterprise Resource Planning”, TMH
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 3 - - - - - - -
CO2 2 3 2 - - 2 - -
CO3 2 2 - - - - - -
CO4 2 2 - - - - - -
CO5 3 3 2 - - 2 - -
Articulated Average CO 2.4 2.5 2 - - 2 - -
notation.
CO4To create effective application with the help of session management techniques.
CO5To design web application to manipulate data using PHP and My Sql.
References:
Text Books:
1. Ivan Bayross, "Web Technologies Part-Ii" , Bpb Publications.
2. Shishir Gundavarma,”Cgi Programming On The World Wide Web", O'reilly & Associate.
3. Sai Srinivas Sriparasa,”JavaScript and JSON Essentials”,Packt Publishing Ltd.
Reference Books:
1. Don Box, "Essential Com", Addison Wesley.
2. Hasin Hayder,”Object-Oriented Programming with Php5”, PACKT Publications.
3. Steven Holzner ,“PHP: The Complete Reference”,Paperback.
4. Thomas Powell, “JavaScript: The Complete Reference” Paperback.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO4 Design and develop MVC supported Web applications using java Struts
CO5 Design and Develop scalable, secure Web-based applications as per the current
industry
requirements with various frameworks t. And enhance the opportunities for
employability of the students.
References:
Text Books:
1 M.T. Savaliya,"Advanced Java, Revised ed (MISL-DT) Paperback – 2016", Dreamtech Press
2 Steven Hoizner, "Java2 Black book", Dreamtech.
Reference Books:
1 Dustin R. Calway, "Inside Serviets", Addison Wesley.
2 Mark Wutica, "Java Enterprise Edition”, QUE.
3 E. Balagurusamy , "Programming in JAVA”, TMH.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
References:
Text Books:
1. Kamal Raj “ Mobile Computing”, Oxford.
Reference Books
1. Shambhu Upadhyaya, Abhijeet Chaudhary, Kevin Kwiat, Mark Weises, “Mobile Computing”, Kluwer Academic
Publishers.
2. Uwe Hansmann, Lothar Merk, Martin-S-Nickious, Thomas Stohe, “Principles of Mobile Computing”, Springer
International Edition.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
2. Aim : Demonstrate reading contents from text file on your computer using AJAX,
XHR and JQuery.
Problem Statement: David (our client) is facing some issue in his website. He is having
some text file located somewhere and he wants the website should load data form text
file to his website. He wants these features in his website.
a) Create a HTML file (“statement.html”) and read the contents of a text file (data.txt)
using XMLHttpRequest object.
b) On clicking the button the content of text file must be loaded into target place.
c) Whatever content loaded form text file must be stored in a properly formatted table.
d) At the end of he wants information like 1) No. of lines 2) word length
3. Aim: Design a webpage and demonstrate DOM and CSS manipulation using AJAX
and JQuery.
Problem Statement: A vendor wants to create a webpage which have functionality of
DOM manipulation. He wants when user clicks on button add a new paragraph to
HTML page using AJAX.
Problems.
a) Design HTML page with 2 buttons. The first button to Add new paragraph and
second button to remove all paragraphs. There should be paragraph count system.
b) Design a webpage with 3 paragraphs and do CSS manipulation using DOM and
JQuery.
4. Aim: To Implement html form validation Using AJAX and JQuery.
Problem Statement:
a) Design a HTML registration () form and perform field validation using AJAX and
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
5. Aim: Design a webpage and create a JSON object with following information of a
Student.
Student- Personal Information (Name, Father’s Name, DOB, Gender, Address (City,
State, Pin Code))
Problem Statement:
a) Create a Nested JSON object for above student’s details.
b) Design HTML page and fetch details of Student’ Information.
c) Create script to add Academic details as (High-School, Marks, Inter-School,
Marks)
7. Aim : Create a HTML form to accept Student details (RollNo, Name, DOB , Photo)
and perform following;
Problem Statement:
a) Design a HTML form with validation thru AJAX.
b) Create PHP script to display the size, name , type of the image uploaded.
c) Create PHP script for validation of the uploaded file as per following criteria: file
size (50kb) and file type as JPG.
9. Aim: To demonstrate the concept of class and object with constructor and destructor.
Problem Statement:
a) Create web form asking the details of UU student (Roll-No, Name, DOB, Age,
Course) and submit the form.( redirected to process.php).
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
b) Create process.php script having class Student (Roll-No, Name, DOB, Age,
Course), initialize the data-members using PHP parameterized constructor and
show details using display(). Class should have destructor function.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
UNIT-III
Testing, System Security measures.
UNIT-IV
Reports, Future scope and further enhancement of the project.
UNIT-V
Appendices, coding, bibliography.
Course Outcomes (CO)
CO1 Enhance the presentation skills and student will learn to create proper documentation
of the project
CO2 Understand various project planning strategies using pert chart and giant chart and to
develop the critical analysis for real time problems using feasibility analysis technique.
CO3 Understand the project designing construct using software engineering designing tools
like DFD and UML diagrams.
CO4 Develop the critical analysis skills so that student will able to apply various testing
tools like unit testing, system testing, black box testing, alpha testing and beta testing
techniques on the project.
CO5 Produce entrepreneurs who can develop customized solution for small to large
enterprises.
Text Books:
1. K. K Aggrawal. “Software Engineering”, New Age Publication.
2. Roger S. Pressman, “Software Engineering: A Practitioner's Approach”, McGraw Hill 2001.
3. Ivan Bayross, "Web Technologies Part-Ii" , Bpb Publications.
4. Shishir Gundavarma,”Cgi Programming On The World Wide Web", O'reilly & Associate.
5. Sai Srinivas Sriparasa,”JavaScript and JSON Essentials”,Packt Publishing Ltd.
6. M.T. Savaliya,"Advanced Java, Revised ed (MISL-DT) Paperback – 2016", Dreamtech Press
7. Steven Hoizner, "Java2 Black book", Dreamtech.
Reference Books:
1. Pankaj Jalote , "Software Engineering", New Delhi: Narosa 2002.
2. David Gustafson ,”Software Engineering” , Schaum's Series, TMH.
3. Ghezzi Carlo, "Fundamentals of Software Engineering".
4. Don Box, "Essential Com", Addison Wesley.
5. Hasin Hayder,”Object-Oriented Programming with Php5”, PACKT Publications.
6. Steven Holzner ,“PHP: The Complete Reference”,Paperback.
SEMESTER-VI
Examination Scheme:
Components Internal External Total
Weightage (%) 37.5% 62.5% 100%
CO-POArticulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - - 2 - - - -
CO2 2 2 - - 2 - - -
CO3 - - 2 - - - - -
CO4 - - - - 2 - - -
CO5 - - - - - - 2 2
Articulated Average CO 2 2 2 2 2 - 2 2
Ex
amination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
CO3 Develop critical thinking, analytical skills to develop new window and web application
for existing problems using .net framework technology.
CO4 Implement validation controls on web based application using ASP.NET validation,
standard and rich controls.
CO5 Develop technical knowledge of ADO.net, Asp.net and window programming so that
student can meet the current industry, academic and research requirement.
References:
Text Books:
1. S.Pannikar, “Magic of C# with .Net Framework”, Firewall.
2. Addison Wesley, “C# Developers Guide to ASP.Net”,
Reference Books:
1. Wiley, “Beginning Visual C# 2008”,Wrox
2. C#.Net Developers Guide- Greg Hack, Jason Werry, SaurabhNandu. (SyngRess)
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-PO Articulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 2 - - - - - 2
CO2 1 3 1 - 1 2 - -
CO3 - 2 2 - 3 2 - -
CO4 2 2 - - 3 - 2 -
CO5 - 1 1 2 3 - - -
Articulated Average CO 1.6 2 1.3 2 2.5 2 2 2
1. Mark Beans, “Android Lollipop: A Beginner’s Guide to the Android Operating System”, Conceptual Kings
Publishers, 2014.
2. B.M. Harwani, “Android Programming Unleashed”, Pearson Publishers, 2013.
Reference Books:
1. Michael Burton, “Android App Development for Dummies”, Wiley Publishers.
2. Matthew Henry, “Dive in Android Programming”, Create Space Independent Publishers.
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
CO-POArticulation Matrix
CO-PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8
CO1 2 - - - - - - -
CO2 2 2 - - 2 - - -
CO3 - - 2 - 2 - - -
CO4 - - - - 2 - - -
CO5 - - - 2 2 - 2 2
Articulated Average CO 2 2 2 2 2 - 2 2
References:
Text Book:
1. Learning Python by Mark Lutz, David Ascher Shop O'Reilly - O'Reilly Media
Reference Books:
1. Learn Python the Hard Way, Zed A. Shaw , Goodreads.
2. Beginning Python Magnus Lie Hetland , Goodreads
3. Python Programming for the Absolute Beginner third edition Ross Dawson Goodreads
Examination Scheme:
Components Sessional-I Sessional-II Teacher Assignment External Total
Weightage (%) 10% 10% 20% 60% 100%
to enter into text boxes. The grams of fat, grams of carbohydrate and grams of protein.
Each gram of fat is 9 calories and protein or carbohydrate is 4 calories. Display the
total calories of the current food item in a label. Use to other labels to display and
accumulated some of calories and the count of items entered. The form food have 3
text boxes for the user to enter the grams for each category include label next to each
text box indicating what the user is enter.
10. Create the web application that accepts name, password ,age , email id, and user id. All
the information entry is compulsory. Password should be reconfirmed. Age should be
within 21 to 30. Email id should be valid. User id should have at least a capital letter
and digit as well as length should be between 7 and 20 characters.
11. Create a Web App to display all the Empname and Deptid of the employee from the
database using SQL source control and bind it to GridView . Database fields
are(DeptId, DeptName, EmpName, Salary).
12. Create a web application Login Module which adds Username and Password in the
database. Username in the database should be a primary key.
13. Create a web application to insert 3 records inside the SQL database table having
following fields( DeptId, DeptName, EmpName, Salary). Update the salary for any one
employee and increment it to 15% of the present salary. Perform delete operation on 1
row of the database table.
Course Outcomes (CO)
CO1 Understand the working of visual studio IDE with the fundamentals concepts of
programming using C# .NET.
CO2 Understand the fundamentals of Object oriented programming and apply to create
console application using C#.net.
CO3 Analysis the critical problems of the real time environment and able to design new
windows application using windows programming constructs through c#.net.
CO4 Learn to create web application and implement validation controls on web-based
application using ASP.NET validation, standard and rich controls.
CO5 Develop technical knowledge of ADO.net, Asp.net and window programming so that
student can meet the current industry, academic and research requirement.
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%
A member function GetType() to assign the following values for Food Type as per the given
Sticker
Q11. Design,Develop and implement a program to make Histrogram and Column Chart using
Uttaranchal University-Syllabus for Bachelor of Computer Application. w.e.f.-2020-23
UTTARANCHAL UNIVERSITY
(Established vide Uttaranchal University Act, 2012)
(Uttarakhand Act No. 11 of 2013)
Arcadia Grant, P.O. Chandanwari, Premnagar, Dehradun, Uttarakhand
Examination Scheme:
Components Internal External Total
Weightage (%) 40% 60% 100%