BCA 1st To 6th Sem
BCA 1st To 6th Sem
BCA 1st To 6th Sem
Practical
Max Min
1. BCA152 Programming
Fundamentals 50 25
using ‘C’-Lab
2. BCA155 MS Office Lab 50 25
RKDF UNIVERSITY, RANCHI
BCA 2019-2022
Choice Based Credit System
S.N. Subject Subject Name L T P Credit
Code
1. BCA101 Fundamentals of 3 1 0 4
Computer
2. BCA102 Programming 3 1 0 4
Fundamentals
using ‘C’
3. BCA103 Development of 3 1 0 4
Entrepreneurship
4. BCA104 Digital Electronics 3 1 0 4
6. BCA152 Programming 0 0 2 1
Fundamentals
using ‘C’-Lab
7. BCA155 MS Office Lab 2 1
Total 15 4 4 21
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- I
Course Content
Unit - I
Introduction of Computers: Computer System, System Characteristics and capabilities, Types of
Computers: Analog, Digital (Micro, Mini, Mainframe & Super Computers), Generation of
Computers.
Unit –II
Computer Organisation: Block Diagram of Computer and its functional units. Input Devices
KeyBoard, Scanner, Mouse, Light Pen, Bar Code Reader, OMR, OCR, MICR., Trackball,
Joystick, Touch Screen etc., Output Devices: Monitors Classification of Monitors based on
Technology (CRT Monitor & Flat panel LCD Monitor), Printers Dot Matrix Printer, Ink Jet
Printer, Laser Printer and Plotters, Types of Plotters Drum Plotter and Flat Bed Plotters, LCD
Projectors. Storage Devices: Magnetic tapes, Floppy Disks, Hard Disks, Compact Disc - CD-
ROM, CD-RW, VCD, DVD, DVD-RW.
Unit- II
Programming Languages: History, Classifications Low Level, Assembly & High Level
languages, Advantages & Disadvantages Programming Languages.
Unit- IV
Types Of Software: System Software - Translators (Compilers, Interpreters, Assemblers),
Operating System, Linkers, Libraries & Utilities, Application Software - Packaged & Tailored
Softwares. Operating Systems: Introduction, Types of O.S. - Single User, Multi User - Multi
Programming, Multi Tasking, Real Time, Time Sharing, Batch Processing, Parallel Processing,
Distributed Processing
Unit V
Program Planning: Purpose of Program Planning, Steps in Program Development,
Characteristics of a Good Program, Algorithms, Flow Charts through examples.
TEXT BOOK:
1. Computer Fundamentals By P.K. Sinha
2. Operating System By Peterson
Reference Books:
1. Easy Approach To Computer Course By G.K. Iyer
2. Computer Today By S.K. Basandra
3. Operating System By Godbole 4. 'O' Level Programming Concepts & Systems By V.K. Jain
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- I
Course Content
Unit I
Program Logic development Using algorithm and Flowchart, Historical development of_C,
Constants, variables and keywords,_C instructions. Data types - int, float, double, char, void,
short, long, longdouble, signed, unsigned
Unit –II
Decision control structure:- if statement, if-else statement, the conditional operators. Case
control structure: switch statement, goto statement. C' operators: Arithmetic, relational and
logical. Development of_C' program using Decision control & Case control structure.
Unit- III
Unit IV
Arrays: One dimension array, 2D array, 3D array, Introduction to Pointers. Functions: Function
Declaration and prototypes, Passing values between functions:- call by value. Development of_C
programs using Arrays, functions.
Unit V
Storage classes in_C', Structures:- declaring a structure, accessing structure element, how
structure elements are stored, array of structures, union.
Text Books:
2. Programming in C by E. Balaguruswami
Reference Books:
Course Content
Unit-I
Unit-II
Motivation to Achieve Targets and Establishment of ldeas. Setting Targets and Facing
Challenges. Resolving problems and creativity. Sequenced planning and guiding capacIty,
Development of Self Confidence. Communication Skills, Capacity to Influence, Leadership.
Unit Ill
Project Report - Evaluation of Selection Process. Detailed Project Report - Preparation of main
part of a project report pointing out necessary and viability. Selecting the form of Organization -
Meaning and characteristics of Sole Proprietorship, Partnership and Cooperative Committees,
Elements Affecting Selection of a form of an Organisation. Economic Management- Role of
Banks and Financial Institutions Banking, Financial Plans, Working Capital-Evaluation and
Management, Keeping of Accounts.
Unit- IV
Role of regulatory institutions - District Industry Centre, Pollution Control Board, Food and
Drug Administration, Special Study of Electricity Development and Municipal Corporation.
Role of Development Organizations - Jharkhand State Khadi & Gram Udyog Board, Jharkhand
State Mineral Development Corporation Ltd., etc. ,Self-employment-oriented schemes, Prime
Minister's Employment schemes, Golden Jubilee Urban Environment Scheme, Rani Durgavati
Self-Employment scheme/Pt. Deendayal Self Employment Scheme. d) Various grant schemes-
Cost-of-Capital Grant, Interest Grant, Exemption from Entry Tax, Project Report,
Reimbursement Grant, etc. (C)Role of Women Entrepreneurship in India, Women's
Development Corporations (WDCs), Special Incentives for Women Entrepreneurs, Prospects &
Possibilities
Reference Books :
4. AA Hand book on Project Appraisal and follow up, Govind Prakashan, 204, Saraswati Kunj,
90, S. V. Road, Goregoan, Bombay-400 062. - D. P. Sarda
6. Entrepreneurship Guide - Bihar State Financial Corporation, Fraser Road, Patna800 001.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application(BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- I
Course Content
Unit I
Unit -II
Basic logic designs: Logic gates AND, OR, NOT, NOR, NAND, xOR gates and their Truth
Tables, Boolean algebra, Minimization techniques, Karnaugh map, sOP and POS forms,
Combinational circuit design with gate: multiplexers & demultiplexers, Encoder-Decoder,
Adders and Subtractors, Flip flops: RS, JK, Master slave flip flops, Introduction to counters and
registers.
Unit - III
Memory: Memory cell, Primary memory-RAM, ROM, PROM, EPROM, EEPROM, Cache
memory, Secondary Memory and its types, Introduction to physical memory and Virtual
memory, memory accessing methods : serial and random access
Unit - IV
Unit- V
Data transfer schemes: (1) Programmed data transfer- synchronous, asynchronous and interrupt
driven data transfer scheme, (2) Direct memory access data transfer
TEXT BOOKS:
Reference Books:
Course Content
SYLLABUS
1. Write an interactive program that will read in a +ve integer value and
determine the following
i) If the integer is a prime number ii) If the integer is a Fibonacci
number
11 10 11
11 10 9 10 11
11 10 9 8 9 10 11
6. Using Ternary / Conditional operator find the greatest among 3 numbers.
Text Books:
Reference Books:
Course Content
Module – I
Module – II
EXCEL
1. BUILDING A SIMPLE WORKSHEET
2. Entering Text, Entering Values, Entering
Dates and Times, Moving
Around, Selecting Ranges, Using Menu, Using
3. Tool Bar, Using Shortcut Menus, Changing Entries,
Copying Entries, Moving Entries, Inserting and Deleting
cells
4. FORMATTING BASICS
5. Changing Character Style, Changing Alignment, Changing Column
Width
6. WORKING WITH MULTIPLE WORKSHEET
7. Copying entries between work books, Moving sheets
between work books, Deleting sheets, Quitting Excel
8. OPENING EXISTING WORKBOOKS
9. Simple calculations, Doing Arithmetic, Totalling column
of values, Naming cells and Ranges
10. FORMATTING TEXT
11. Displaying dollars and cents, Formatting decimal places,
dates Format, Copying style and formats
12. FORMULAS THAT MAKE DECISIONS
13. Using the IF function, Using the nested IF function, Copying
formulas
14. Checking Spelling, Printing Worksheets, Preview Worksheets,
Setting up the pages,
15. Sorting data, Keeping Leading in View, Finding records,
Adding and deleting Records, Filtering Records
16. Plotting charts, Sizing and moving charts, Updating
charts, changing the chart type, Using chart auto format
17. Creating Macros, Recording Macros, Running Macros
Module – III
POWER POINT
1. Main Features of Power Point
2. MAKING THE PRESENTATION
3. Creating Template with the Auto Content Wizard.
Creating a Presentation with a Template. Creating a
presentation from Scratch
4. DIFFERENT VIEWS
5. Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master
6. ANIMATION, ART AND SOUND
7. Controlling Transitions between slides.
Animating Different Parts of slide. Inserting
a Motion Clip. Including
8. Sounds in slides.
9. INCLUDING GRAPHS, CHARTS, TABLES AND COLUMNS
10. Organization Chart Slide, Creating a table Slide.
Creating two column Slide, Module 1: Showing A
Presentation,
11. Rehearsing/ Timing a Presentation, Designation some
slides as “Hidden”, Viewing Slides Anywhere in a Slide
Show.
12. Techniques for Making a Show Livelier
13. OFFICE CONNECTIONS
14. Presenting with the help of other Office Programs
Importing the text from a World Document.
15. Printing a Presentation
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application (BCA)
SCHEME
Second Semester
Practical
Max Min
1. BCA251 C++ Lab
50 25
2. BCA254 DBMS Lab 50 25
RKDF UNIVERSITY, RANCHI
BCA 2019-2022
Choice Based Credit System
5. BCA205 Discrete 3 1 0 4
Mathematics
6. BCA251 C++ Lab 0 0 2 1
7. BCA254 DBMS Lab 0 0 2 1
Total 15 4 4 22
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- II
Course Content
Course Subject Subject Code
B.C.A. Object Oriented Programming BCA201
with C++
Unit –I
Principles of OOP, procedure oriented programming vs. object oriented programming, basic concepts,
advantages, application of OOPs, object oriented languages. Beginning with C++: What is C++,
structure of C++ program, creating, compiling, linking & executing a C++ program, Tokens,
expressions & control structures, keywords, identifiers, basic data types, user-defined data types,
derived data types, symbolic constants, type compatibility, variable declaration, dynamic initialization
of variables, reference variables.
Unit –II
Operators in C++: scope resolution operator, memory management operators, manipulators, type cast
operators, operators, operator precedence, control structures. Functions in C++: Main function,
function prototyping, call by reference vs. call by value, inline functions, default arguments, const
arguments, function overloading, friend functions. Classes and objects: specifying a class, defining
member functions, making an outside functions inline, private member function; array within a class,
memory allocation for object; static data members, static member functions, array of objects, objects
as function arguments, returning objects.
Unit-III
Constructors and Destructors: Constructors, Parametric Constructors, Multiple Constructors in a class,
constructors with default arguments. Dynamic initialization of objects, copy constructors, dynamic
constructors, destructors. Operator Overloading & Type Conversions: Definition of Overloading, &
Operator Overloading, rules for Overloading Operators, Overloading Unary Operators, Binary
Operators, Binary Operators using Friends.
Unit –IV
Inheritance: defining derived classes, single inheritance, multilevel inheritance, multiple inheritance,
hierarchical inheritance, hybrid inheritance, virtual base class, abstract classes, constructors in derived
classes, member class, nesting of class.
Unit –V
Pointers, virtual functions and polymorphism, pointers to objects, this pointer, pointers to derived
class, pure virtual functions, exception handling in C++, managing console I/O operations, working
with files :open, close, basic read-write operations on files .
Suggested Readings:
Course Content
Unit –I
Basic Computer Organization and Design: Instruction Codes, Computer Registers, Computer Instruction,
Timing and Control, Infarction Cycle, Memory Reference Instruction, Input-Output Interrupt, Design of
Basic Computer, Design of Accumulator Logic.
Unit –II
Basic Computer Organizations and Design: Instruction Cycle, Memory –Reference Instructions, Register
reference instructions, Input -Output Instructions, Design of Accumulator Logic Shift Unit. Central
Processing Unit: Introduction, General Register Organization, Stack Organization, Instruction Formats,
Addressing Modes.
Unit-III
Central Processing Unit: Introduction, General Register Organization, Stack Organization, Instruction
Format, Addressing Modes, Data Transfer and Manipulation, Program Control, Reduced Instruction Set
Computer.
Unit-IV
Input-Output Organization: Peripheral Devices, Input-Output Interface, Asynchronous Data Transfer,
Modes of Transfer, Direct Memory Access, Input-Output Processor.
Unit –V
Memory Organization: Memory Hierarchy, Main Memory, Auxiliary Memory, Associative Memory,
Cache Memory, Virtual Memory, Memory Management Hardware.
Suggested Readings:
1.Morris Mano, Computer System Architecture, 3rd Edition, Prentice -Hall of India Private Limited, 1999.
2.WIliam Stallings, Computer Organization and Architecture, 4th Edition, Prentice Hall of India Private
Limited, 2001
3.Harry & Jordan, Computer Systems Design & Architecture, Addison Wesley, Delhi, 2000.4.Malvino,
“Digital Computer Electronics: An Introduction to Microcomputers”, McGraw Hill, 1993.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- II
Course Content
Course Subject Subject Code
B.C.A. Operating System BCA203
Unit –I
Operating System Definitions, its Components, Evolution of Operating System, types of operating
systems: batch, multiprogrammed, multitasking, desktop, multiprocessor, real-time, client-server, peer-
to-peer, distributed, clustered and handheld. Operating system services, dual-mode operation, protection
of I/O, memory and CPU. Non-virtual and virtual machines.
Unit –II
Scheduling:Basic Concepts, preemptive and non preemptive scheduling. Scheduling Algorithms. Types
of scheduling: -batch, interactive and real-time. Goals of scheduling algorithms. FCFS, SJF, RR,
priority, multiple queues, three-level scheduling.
Deadlocks:System Model, Deadlock Characterization, Methods for Handling Deadlocks, Deadlock
Prevention, Deadlock Avoidance, Deadlock Detection, Recovery from Deadlock. Banker's algorithm.
Unit-III
Memory Management Concepts: Address Binding, logical and physical address space, dynamic loading
etc., Contiguous allocation methods –static & dynamic partitioned memory allocation. Concepts of
fragmentation, swapping, relocation, compaction, protection, sharing. Segmentation.Non–contiguous
allocation methods –Paging: basic principle of operation, h/w support for paging, protection and
sharing. Virtual memory: concept of demand paging, Page fault, page replacement algorithms –FIFO,
LRU, OPT. Thrashing, Concept of Page fault frequency, pre-paging, decision about minimum number
of frames, page size.
Unit –IV
File system implementation, Responsibilities of file management system, directory implementation as
linear list/hash table, directory structure, disk organization, disk controller and driver, disk space
management –contiguous allocation, non contiguous allocation –chaining and indexing, disk address
translation. Idea about disk caching, disk mirroring. Disk scheduling algorithms. Disk management.
Unit –V
Device Management: I/O hardware, Techniques for device management. Dedicated devices, shared
devices, virtual peripherals. Security & protection: Security threats and goals, penetration attempts,
Security policies and mechanism, authentication, protection and access control. Interprocess
communication, need for interprocess synchronization. Deadlocks –definition, avoidance, detection,
prevention and recovery.
Suggested Readings:
Course Content
Unit – I
Introduction: Purpose of Database Systems, View of Data, Data Models, Database Languages,
Relational Database, Database Architecture, Database Users and Administrators, Transaction
Management.
Unit – II
Relational Data Models and Languages: Basic Concepts, Constraints, Keys, Entity-Relationship
Diagram, Weak Entity Sets, Extended E-R Features, Reduction of an E-R Diagram to Tables, The
Relational Algebra, The Tuple Relational Calculus and The Domain Relational Calculus.
Unit – III
Unit – IV
Query Processing and Optimization: Overview, Measures of Query Cost, Selection Operation, Join
Operation, Other Operations, Evaluation of Expressions, Transformation of Relational Expressions,
Estimating Statistics of Expression Results, and Choice of Evaluation Plans.
Unit – V
Transactions and Concurrency Control: Transaction Concept, Transaction State, Desirable Properties
of Transactions, Concurrent Executions, Serializability, Recoverability, Lock-Based Protocols,
Timestamp-Based Protocols and Deadlock Handling.
Text Books:
1. Silberschatz, Korth, & Sudarshan, “Database System Concepts”, 6th Edition, McGraw Hill, 2011.
Reference Books:
1. Elmasri, & Navathe, “Fundamentals of Database Systems”, 5th Edition, Pearson Education, 2008.
2. Date C.J., “An Introduction to Database System”, Pearson Education, New Delhi, 2005.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- II
Course Content
Unit – I
Sets and Propositions: Sets, Operations of sets, Finite and Infinite sets, Principle of inclusion and
exclusion, Propositions, Conditional Propositions, Logical Connectivity, Propositional calculus, Universal
and Existential Quantifiers, Normal forms, Mathematical Induction.
Unit – II
Relations and Functions: Relations, Properties of Binary Relations, Closure of relations, Warshall’s
algorithm, Equivalence relations. Functions, Types of functions, Composition of functions, Invertible
functions.Permutations and Combinations, Pigeonhole Principle, Recurrence Relation.
Unit – III
Unit – IV
Graph Theory and Trees: Basic terminology, representation of a graph in computer memory, Relations
and Digraphs, Paths in Relations and Digraphs, Shortest path in weighted graphs (Dijkstra’s algorithm).
Basic terminology and characterization of trees, Tree traversal, Spanning trees, Minimal Spanning
trees(Introduction).
Unit – V
Groups, Rings and Fields: Groups, Semi Groups, Monoids, Subgroups, Isomorphism and
Homomorphism and Normal Subgroups, Rings, Integral Domain, Rings Homomorphism, Polynomial
Rings, Fields.
Text Books:
Reference Books:
1. BiggsN., “Discrete Mathematics”, 3rd Edition, Oxford University Press, ISBN 0 –19 – 850717 – 8.
2. RosenKenneth H., “Discrete Mathematics and its Applications”, 6th edition, McGraw-Hill, 2007,
ISBN 978-0-07-288008-3.
3. LipschutzSemyour & Lipson Marc, “Discrete Mathematics”, McGraw-Hill, 3rd Special Indian
Edition, ISBN-13: 978-0-07-060174-1.
4. LiuC. L. and MohapatraD. P., “Elements of Discrete Mathematics”, SiE Edition, Tata McGraw-
Hill, 2008, ISBN 10:0-07-066913-9.
5. LipschutzS. and LipsonM., Schaum's Outline of Discrete Mathematics, Revised Third Edition,
Tata McGraw Hill, 2010.
6. MottJ. L., KandelA.and BakerT. P., Discrete Mathematics for Computer Scientists and
Mathematicians, 2nd Edition, Prentice Hall of India, 2001.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- II
Course Content
1. WAP to show the characteristic of a number. {E.g. 24 it has two coefficients 2 in tens position
and 4 in units position. It is composed of 2 and 3. It is a positive number. Also show whether
it is odd or even.
2. WAP to take input through command line argument and do the following:
a) Check whether the number is prime.
b) Generate the reverse a number.
3. Write a menu driven program using switch in C++ to perform following:
a) For input of 1, check whether the number is prime
b) For input of 3, find the factors of the number
c) For input of 5, check the number is odd or even.
4. Write a program in C++ to generate hexadecimal equivalent of a number without using
array.
5. WAP to take two number inputs through command line argument and do the following:
a) Check whether two numbers are prime to each other or not.
b) Find LCM of two numbers.
6. WAP to create a class and exhibit the role of static functions (other than main) by declaring,
defining and calling them.
7. WAP to compute and display the count of occurrence of 4 in a number. E.g. 4564 will
compute 2.
8. WAP to take an angle value in degrees and then compute the equivalent radians and then
prove
sin 2 cos2 1. Note180o c .
18. WAP to design a class called Account using the inheritance and static that show all function of
bank (withdrawal, deposit) and generate account number dynamically.
19. WAP to design an application Password.C++ that produces and prints a random password
depending upon name of an individual. If the input is Abdul Kalam then the password would be
33421LAM. Note: take the first name A=1, B=2, D=4, U=21 where 2+1=3, and L=12, where
1+2=3; so the number comes to be 12433, so u can find out.
*****
*******
*****
***
*
21. WAP to take a string count all vowels and then delete the same from the string.
22. Write a Patient class which inherits from the Person class. Patient can again be of
two types, indoor and outdoor. The Patient class requires the following:
a) a variable to store the patient ID for the patient
b) a variable to store the department of hospital
c) a variable to store the ward of hospital
d) a variable to store the patient 's date of joining the hospital
e) a variable to store the patient 's address
f) a variable to store the medical fees that the patient pays
g) constructor methods, which initialize the variables
h) a method to calculate the medical fees (for both indoor and outdoor patient)
23. WAP to take a string as password and check whether it contains at least two numbers,
3 alphabets and no space in it. If any contrary throw message.
24. Write a program in C++ to create a class called Rational having two data members for
numerator and denominator. Take two inputs of rational numbers and perform
multiplication and division. Display the result in reduced form.
25. Write a program in C++ to print a format like,
*******
*****
***
*
26. Write a class called Shape which contains a user-defined interface for
Computation, which contains methods for calculation of area, perimeter and
volume. Write four classes for circle, rectangle, sphere and rectangular
parallelepiped, and all these classes inherit from Shape. Now take input for the
following:
a) radius of circle and compute its area and perimeter
b) Length and breadth of rectangle and compute its area and perimeter
c) Length, breadth and height for rectangular parallelepiped and compute
its area and volume
d) Radius of sphere and compute its area and volume
** Area of circle= r 2 , perimeter of circle= 2r , area of sphere= 4r 2 , volume of sphere=
4 3
r , volume
3
of rectangular parallelepiped = l b h area of rectangular parallelepiped= 2(l b b
h h l)
Course Content
emp(empno,ename,job,mgr,hiredate,sal,comm,deptn
o,gr), dept(deptno,dname,loc)
27. List all the employees name and salaries increased by 15% and
expressed as a whole number of dollars.
28. Produce the following
EMPLOYEE AND JOB
SMITH CLERK
ALLEN SALESMAN
29. Produce the
following
output:
SMITH ( Clerk)
ALLEN ( Salesman)
30. Do a case sensitive search for a list of employees with a job that the user enters.
31. It has been discovered that the sales people in dept. 30 are not all male.
Please produce the Followingoutput.
ENAME DEPTNO JOB
ALLEN 30 Sales Person
32. Display each employees name and hiredate of dept 20.
33. Display each employees name, hiredate and salary review date. Assume
salary review date is one year from hiredate. Output should be in ascending
review date.
34. Print list of employees displaying just salary, if more than 1500. If exactly
1500 display “ On Target”. If less than 1500 display “ Below 1500”.
35. Write a query which returns DAY of the week ( i.e. MONDAY) for any
date entered in the format DD/MM/YY.
36. Write a query to calculate length of service of each employee.
37. Find the minimum salary of all employees.
38. Find the maximum, minimum, and average salaries of all employees.
39. List the maximum and minimum salary of each job type.
40. Find how many managers are in each dept.
41. Find the average salary and average total remuneration of each job type.
Remembers sales man earn commission.
42. Find out the difference between highest and lowest salary.
43. Find all department s which have more than three employees.
44. Check whether all employee nos are unique. ( No Duplicate)
45. List lowest paid employee working for each Manager. Exclude any groups
where the minimum salary is less than 1000. Sort the output by salary.
46. Produce a list showing employees ‘salary grade’.(> 10000 A, >10000 &<20000 B,
>20000 C)
47. Show only employee on Grade C.
48. Show all employee in Dallas.
49. List the employees name, job, salary, grade and department for everyone in the
company except clerks. Sort on salary, displaying the highest first.
50. List the following details of employees who earn $36000 a year or who are clerks.
Ename Job Annual Sal Dept no Dname Grade
51. Display all employees who earn less than their managers.
52. Display all employees by name and eno along with their managers name and number.
53. Modify above spoliation to display KING who has no MANAGER.
54. Find the job that was files in the first half of 1983 and the name job that was
filled in the same period in 1984.
55. Find all employees who have joined before their manager.
EMPLOYEE HIREDATE MANAGER HIREDATE
56. Find the employees who earn the highest salary in each job, type, sort in
descending order of salary.
57. Find the employees who earn the minimum salary for their job,
Display the result in descending order of salary
.
58. Find the most recently hired employees in the department. Order by hiredate.
59. Show the details of any employee who earns a salary greater than the
average for their department. Sort in department number order.
60. List all department where there are no employees.
TEXT BOOK
1.SQL, PL/SQL the programming Language of Oracle, Ivan Bayross, 4th edition
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application (BCA)
SCHEME
Third Semester
Practical
Max Min
1. BCA351 Data Structure
Lab 50 25
2. BCA354 CONM Lab 50 25
RKDF UNIVERSITY, RANCHI
BCA 2019-2022
Choice Based Credit System
Third Semester
Course Content
UNIT-I
UNIT-II
UNIT-III
Software Project Management: Size Estimation- LOC and FP Metrics, Cost Estimation-Delphi
and Basic COCOMO.
UNIT-IV
Software Design: Classification, Software Design Approaches, Structured Analysis Data flow
Diagrams and Structured Design, Introduction to Object Oriented Design. Coding and Testing of
Software: Unit Testing, Black Box Testing, White Box Testing, Debugging, Program Analysis
Tools, System Testing.
UNIT-V
Software Quality Assurance: ISO 9000 and SEI CMM and their Comparison. Software
Maintenance: Maintenance Process Models and Reverse Engineering, Estimation of
Maintenance Costs.
Reference Books:
2) Richard Fairley- Software Engineering Concepts, Tata McGraw Hill, New Delhi, 2006.
Course Content
UNIT-I
A First look at a C++ Program, Variables and Constants, Arithmetic Expressions, Logical
Expressions and if-else Statements, Iterative Statements, The switch Statement, Arrays, Strings,
Structures Pointers, References, Dynamic Memory Allocation. Introduction, Public and Private
Members, Encapsulation, Implementation of a Class, Syntax for Accessing Class Members,
Constructors and Destructors, Arrays of Class Objects, Operator Overloading for Classes,
Classes and Efficiency.
UNIT-II
Data Structures and Abstract Data Types, Linked List Data structure, Linked List- Single Linked
Lists, Circular Linked List, Doubly Linked Lists ,Traversal, The Insert Function, Remove
Function, Linked Lists vs. Arrays.
UNIT-III
UNIT-IV
Introduction, Binary Search Trees, Tree Traversals, Graph- adjacency lists & adjacency matrix.
UNIT-V
Introduction, Sequential and Binary Search, Selection Sort, Insertion Sort, Bubble Sort, Quick
sort.
Reference Books:
1. S.Sahni- Data Structures, Algorithms and Applications in C++, 2nd Edn. Universities
Press, India, 2005.
2. 1. M.Litvin&G.Litvin- Programs with C++ and Data structures-Vikas Publishing Home,
New Delhi, 2005
3. Introduction to Algorithms by Thomas H. Cormen
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- III
Course Content
UNIT-I
Errors in Numerical Calculations: Numbers and their accuracy, Errors and their Computations-
Absolute, Relative and Percentage, General Error Formula. Solution of Algebraic and
Transcendental Equations: Introduction, Bisection method, Iteration method, Method of False
Position, Newton- Raphson method.
UNIT-II
UNIT-III
UNIT-IV
Numerical Solution of Linear System of Equations: Direct Methods- Matrix Inversion Method,
Gauss-Jordan Method, Gauss Elimination Method.
UNIT-V
Text/References:
3) B.S.Grewal- Numerical Methods in Engineering & Science, Khanna Publishers, Delhi, 2005.
4) S.C.Gupta and V.K.Kapoor – Elements of Mathematics, Statistics, Sultan Chand and Sons.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- I
Course Content
Unit I
Unit II
Media and Transmission modes: Data and signals, Periodic analog signals, Digital signals ,
Transmission impairment , Digital to digital, Analog to digital conversion, Transmission modes,
Digital to analog conversion, Analog to analog conversion, Guided media and Unguided media.
Unit III
Switching and routing algorithms: Switching basics, circuit switching, packet switching and
Message switching. datagram networks and virtual circuit networks, routing algorithms- distance
vector routing and link state routing Information Encoding, Error Detection and Correction
Introduction, representing different symbols, Minimizing errors, Error classification, types of
errors, redundancy, detection versus correction, hamming distance, cyclic redundancy check,
checksum and Flow control.
Unit IV
IP: PV4 addressing, IPv6 addresses, IPv6 header formats, IPv6 extension headers, IPv6 auto
configuration.
Unit V
Network Security: Requirements, conventional encryption, public key encryption & digital
signatures.
Books:
2) William Stallings, Data and Computer Communications, Pearson Education India, 2007,
Eighth Edition.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- III
Course Content
UNIT-I
Introduction to E-commerce: E-commerce: The revolution is just beginning, The visions and
forces behind E-commerce, Understanding E-commerce.
UNIT-II
UNIT-III
E-commerce infrastructure: The Internet, Technology background, The internettoday, The world
wide web. Building an E-commerce web site: A systematic approach, choosing server software,
choosing the hardware for an E-commerce site, other E-commerce site tools.
UNIT-IV
Security and Encryption: The E-commerce security environment, Security threats in the E-
commerce environment, Technology solutions, Policies, Procedures and Laws.
UNIT-V
Ethical, Social, and Political issues in E-commerce: Understanding ethical, social, and political
issues in E-commerce, Privacy and information rights, Intellectual property rights, Governance,
Public safety and welfare.
Reference Books:
Course Content
SYLLABUS
Text Books:
1. Baluja G S, “Data Structure through C”, Ganpat Rai Publication, New Delhi, 2015.
2. Pai G A V, “Data Structures and Algorithms: Concepts, Techniques and
Applications”, 2nd Edn, Tata McGraw-Hill, 2008.
3. Horowitz E., Sahni S., Susan A., “Fundamentals of Data Structures in C”, 2nd
Edition, University Press, 2010.
Reference Books:
Course Content
Assignment 1
Write a program in C to solve the equation x4 + x2 -1 = 0, correct to eight decimal places using
bisection method.
Assignment 2
Write a program in C to find the root (which lies between 2 and 3) of the following equation
correct to six significant figures using bisection method:
x2 – 5log10 (5x2+2x+3) = 0
Assignment 3
Write a program in C to find the root of the equation x3 – 4x2 + 10x – 10 = 0 correct to six
significant figures using Regula-Falsi Method.
Assignment 4
Write a program in C to find the root (which lies between 1 and 2) of the following equation
correct to six decimal places using Regula-Falsi Method and the method of Bisection. Compare
the number of iterations required in both the cases:
2x – 3cosx = 1.85
Assignment 5
Write a program in C to solve the equation 3x – cosx - 1= 0, by the method of Iteration, for the
root lying between 0 and 1, correct to 6 decimal places.
Assignment 7
Assignment 8
Write a program in C to compute a difference table for the following data and hence find the
p yq
value of yq and
p
; p and q are to be taken from the users.
Assignment 9
Write a program in C to find f(2.02) having given the following table, using Newton’s forward
Interpolation formula correct to five significant figures.
Assignment 10
Write a program in C to find f(2.91) having given the following table, using Newton’s
Interpolation formula, correct to five significant figures.
Assignment 11
f(X) 14 27 35 ? 50 65
Assignment 12
Write a program in C to find the value of X when it is given that f(X) = 55 in the table given in
Assignment 11 after finding the value of f(31).
Assignment 13
Solve by Gauss elimination method with partial pivoting, the following system of equations
correct up to four significant figures.
x + 3y = 2z = 5
2x – y + z = -1
x + 2y + 3z = 2
Assignment 14
Hence find the root of the following system of equations correct up to five decimal places:
5x + 3y +7z = 5
x +5 y +2 z = -1
-
7x + 2y + 10z = 5
Assignment 15
Assignment 16
Solve, by Gauss-Seidel
Seidel iteration method, the following system of equations, correct up to four
significant figures.
Assignment 17
Write a program in C to calculate the approximate value of the following definite integrals using
Trapizoidal rule, taking 20 subintervals, correct up to 6 significant figures. Calculate the
percentage of error present in the result for (i).
(i)
Assignment 18
0 .5
dx
Write a program in C to calculate the approximate value of 0 (1 x 2 )(1 0.75 x 2 )
correct up
Assignment 19
1
dx
Write a program in C to calculate the approximate value of
0 x 2x 3
2 correct up to 4
significant figures, using Simpson’s 1/3 rule and Trapizoidal rulerule, taking 18 subintervals.
Compare the results by calculating percentage error. (Assume the result correct upto 7 significant
significa
digits as the exact value.)
Assignment 20
3
dx
Write a program in C to calculate the approximate value of
2 ( x 1) x 2 2 x
correct up to 6
dy y
; y(0.2) = 2, taking step length h = 0.01.
dx 1 x
Assignment 22
dy
1 x x 2 ; y(0) = 1,
dx
taking step length h = 0.25. Compare the results (approximate values) obtained in both the cases
with the exact value.
Assignment 23
dy/dx = (0.5 - x + y2) / (x2 + y +1); y(0) = 0, taking step length h = 0.1.
Assignment 24
Assignment 25
Write a program in C to represent a set of 100 bivariate data of the form (x, y) into a two way
frequency table and then calculate and from the marginal distributions. Generate the (x, y)
tuples using random numbers so that 0 < x < 51 and 150 < y < 250.
Assignment 26
Assignment 27
Ten students obtained the following marks in Mathematics and Statistics. Calculate the rank
correlation coefficient between these two sets of data using a C program.
Student 1 2 3 4 5 6 7 8 9 10
Marks in Mathematics 78 36 98 25 75 82 90 62 65 39
Marks in Statistics 84 51 91 60 68 62 86 58 53 47
Assignment 28
Write a program in C to predict the value of x when the value of y is given and vice versa from a
given bivariate data set.
Reference books:
1. Mollah S. A., “Numerical Analysis and Computational Procedures,” Books and Allied (P)
Ltd., Kolkata, 2017.
2. Sastry S.S., “Introductory Methods of Numerical Analysis,” PHI, Private Ltd., New Delhi.
3. Pal N. & Sarkar S., “Statistics: Concepts and Applications,” PHI, New Delhi, 2005.
4. Das N. G., “Statistical Methods,” Tata McGraw Hill Edu. P. Ltd., New Delhi, 2010.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application (BCA)
SCHEME
Fourth Semester
Practical
Max Min
1. BCA452 Web
Programming 50 25
Lab
2. BCA455 OOP in Java 50 25
Lab
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Application (BCA) 2019-2022
SCHEME
Fourth Semester
Choice Based Credit System
Course Content
Unit – I
Introduction:
What is an algorithm? Design and performance analysis of algorithms, space and time trade-offs.
Analysis of selection sort and insertion sort. Asymptotic notations (O, è, ¿,ωο) to measure
complexity of algorithms.
Unit – II
Recursion:
Basic concept. Analysis of recursive algorithms, Master's theorem. Divide & Conquer: The
general method. binary search, finding the maximum and minimum, merge sort, quick sort, Best
and worst case analysis for the mentioned algorithms.
Unit – III
The general method. Applications to Knapsack problem, minimum weight spanning trees: Prim’s
& Kruskal’s algorithms. Dijkstra's algorithm for finding single source shortest paths problem.
Unit – IV
Algorithms on Graphs:
Breadth First Search, Depth First Search, Biconnectivity, Depth First Search of a Directed
Graph, Topological Sorting.
Unit – V
8-queen problem, Branch and Bound: 0/1 Knapsack problem, assignment problem.
Text Books:
Reference Books:
1. Aho Alfred V., Hopcroft John E. & Ullman Jeffrey D., “The Design & Analysis of Computer
Algorithms”, Addison Wesley Publications.
2. Kleinberg Jon & Tardos Eva, “Algorithm Design”, Pearson Education Publications.
3. Brassard Gilles & Bratley Paul, “Fundamentals of Algorithms”, PHI Publications.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- IV
Course Content
Unit – I
Introduction to Internet and HTML: Introduction to Internet, Internet Services, Web Server, Web
Client, Domain Registration, Internet Security. HTML Tags, HTML Documents, Header Section, Body
Section, Headings, Link Documents using Anchor Tag, Formatting Characters, Font tag, Images and
Pictures, Listing, Tables in HTML.
Unit – II
Java Script:Data Types, Variables, Operators, Conditional Statements, Array Objects, Date Objects,
String Objects, Use of Java Script in Web Pages, Advantages of Java Script, Type Casting, Array,
Operators and Expression, Conditional Checking, Function, User Defined Function.
Unit – III
Understanding XML: Overview of XML, XML Families of Technology, Creating XML Documents,
Rules for Well-Formed XML, Discerning Structure, Working with Mixed content, Adding Comments,
CDATA Sections, Creating a DTD-The Concept of a Valid XML Document, Creating a DTD for an
existing XML File.
Unit – IV
ASP .NET: Building Web Forms Using ASP .NET, Exploring ASP .NET Server Controls,
Using ASP.NET Server Controls to Create Web Forms, Understanding the Code behind the
Page. Working with User Controls, Exposing User Control Properties and Methods, Using ASP
.NET Server Controls in User Controls, Using Validation Controls to Improve Web Forms,
Uploading Files to a Web Server.
Unit – V
PHP: Preparing the Use PHP, Exploring PHP for the First Time, Understanding PHP Basics, Displaying
PHP Output, Managing PHP Program Flow. Planning a PHP Web Application, Creating and Using a
Logon Window, Managing System Data, Updating a PHP Web Application.
TEXT BOOKS
1. XavierC., “Web Technology & Design”, New Age International Publishers, 1st
Edn, New Delhi, 2004.
2. BaiXue, Ekedahl Michael, FarrellJoyce, GosselinDon, ZakDiane, KaparthiShashi,
MacintyrePeter, Morrissey Bill, “The Web Warrior Guide to Web Programming”,
India Edition, Thomson Education.
REFERENCE BOOK
1. RossIvan Bay, “Web Enable Commercial Application Using HTML, DHTML”,
BPB Publication.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- IV
Course Content
Unit – I
What is Psychology? Whom does the Psychologist observe? What does Psychologist observe?
Where does the Psychologist observe?
Unit – II
Sensation & Perception, Feelings and Emotions, Learning and Thinking.( in so far as they are
applicable to Industry), Personality, Definition & Theories, Assessing Personality.
Unit – III
An Overview of Transactional Analysis as a Tool for Measuring One‘s Own Awareness and of
helping Interpersonal Relationship in an Organisation. Theories of Organisation, Contingency
Model and other Models of Organisation, Theories of Motivation. – Abraham Maslow,
Herzerberg Mecleland.
Unit – IV
Group Dynamics, Structure, Process, Values of Groups, Role and Stature. Theories of
Leadership, Identifying Leadership Potential.
Unit – V
Course Content
Unit – I
Overview of System Analysis & Design Definition, Characteristics, System Concepts, Elements
and Types. System Development Life Cycle Impetus for change, Steps involved in SDLC,
People involved SDLC. Initial Investigation Background Analysis, Fact finding techniques, tools
for Information gathe ring, types of interviews and questionnaires.
Unit – II
Structured Analysis Definition, tools for structured analysis. Feasibilit Study Definition,
Considerations Technical, Economic, Behavioral & Political, Steps in Feasibility Study,
Feasibility Report. Cost Benefit Analysis (CBA) Categories Hardware, Personnel, Facility,
Operating and Supply Costs, Proce dure for CBA Determination.
Unit – III
Unit – IV
Quality Assurance – Definition, Goals in System Life Cycle, Levels of Quality Assurance,
Tresting. Implementation – Conversion, Stages of Conversion, Combating resistance to change,
Post Implementation Review, Review Plan. Software Maintenance – Maintenance/Enhancement,
Activities of a Maintenance procedure, reducing maintenance costs
Unit – V
System Security – Data Security, Threats to System Security, Risk Analysis, Control Measures,
System Audit, Protection Againts VIRUS. Hardware and Software Selection –
Hardware/Software Suppliers, Procedure for Hardware/Software Selection, Major Phases in
Selection. Types of Software, Attributes of Software, Criteria for Software Selection, Evaluation
Process. Financial Consideration in Selection – Rental, Lease, Purchase Options.
TEXT BOOKS:
REFERENCE BOOKS:
2. Modern System Analysis & Design by A Hoffer, F George, S Valaciah, Low price Edn.
Pearson Education.
3. Information Technology & Computer Applications – by V.K. Kapoor, Sultan Chand & Sons,
New Delhi.
Course Content
Unit - I
Unit - II
Data types and program statements: Primitive and reference data types, variables and constants,
enumerated constants, labelled statement, expression and null statements, compound statement,
control statement – decision and loops, jump statement, declaration statement, try-throw-catch-
finally statement, declaring and creating arrays, accessing array elements, assigning values to
array elements, multidimensional arrays.
Unit - III
Functions, Data Abstraction and classes: Declaration, definition and call, main method
arguments, reference variables, method overloading, parameter passing by value for primitive
types, object references and arrays, scope of variables, return from methods.
Class and object, class members and initialization, access rights of members – public, private and
protected access modifiers, constructor and copy constructor, mutability, finalization, dynamic
memory management, garbage collection, this keyword, static members, scope of variables,
interface – declaration, implementation and extending, package and package visibility.
Unit – IV
Inheritance and Collection classes: multi-level and single inheritance, multiple inheritance of
interfaces, Object class, access rights in subclasses and packages, constructor calling sequence,
super keyword, dynamic binding of methods, abstract class, overriding, shadowing and hiding,
finalize, association, aggregation and composition.
Module – V
Input/Output and JAVA Applets: Stream clases – InputStream, OutputStream, Buffered Stream,
file classes and handling, pushback streams, reader and writer classes, file reader and writer,
serialization.
Applet code example, HTML tags for applet, applet life cycle, color, font andbasic GUI
handling, basic graphics, and animation.
Text Books:
1. Balagurusamy E., “Programming in Java”, 2nd Edition, Tata McGraw Hill
Publication, New Delhi.
Reference Books:
1. Naghton Patrick & Schildt H., “The Complete Reference Java 2”, Tata McGraw
Hill Publication, New Delhi.
2. Dietel Harvey M & Dietel Paul J., “Java How to program”, 7th edition, Pearson
Education, New Delhi.
Web Programming Lab
SYLLABUS
1. India is a large country. Different regions observe variations in climate. The spoken
language of one state is quite different from that of another. They wear different types
of garments. They celebrate different festivals and perform varied religious rites.
People belonging to diverse cultures belong to different religious faiths. In spite of
these diversities, Indians feel a sense of unity and oneness among them. Thus, we
conclude that India is a land of Unity in Diversity.
a) All the headings should be H2 and green colour.
b) Main heading should be H1 and centre aligned.
c) The background should be yellow colour.
d) There are 10 paragraphs so each of them should be made using P tag.
e) The Introduction and Conclusion paragraphs should have “Times New
Roman” font, the size should be 12 and colour should be blue.
f) All the remaining paragraphs text should be pink and magenta coloured in
an alternate way.
g) There should be one meaningful picture in the web page with specific
dimension.
2. Create a webpage having a list as shown below:
Food
a. Fruit
Apple
Mango
Pear
b. Vegetable
Potato
Tomato
Carrot
Dress
a. Ethnic wear
Kurta
Sherwani
b. Western wear
suit
jeans
Sports
a. Indoor sports
carom
table tennis
b. Outdoor sports
Cricket
Hockey
3. Create a webpage with the following:
a) A superscript and subscript tag
b) Pre tag
c) Paragraph tag
d) Anchor tag
e) Image tag
f) Definition list tag
g) Marquee tag
h) Horizontal line tag
i) Break tag
j) Heading tag
4. Create a webpage having 10 divisions each having separate background color and text
color using
<DIV> tag. At the top right corner there should be an image hyperlink opening in a new
webpage.
5. Create a webpage with a form loaded into it and take input of three
strings through three textboxes and then concatenate them without using any
built-in function.
6. Create a webpage with two tables. First one should have 1 row and 5 columns and
the second one with 3 rows and 4 columns. The contents of the first table should be
center aligned and contents of the second table should be right aligned. Each column
of the first table should have separate
colors and each row of the second table should have separate colors.
8. Write a JavaScript program to search the element 4 in the array [2, 6, 4, 10, 4,
0, -2] using any method.
9. Create a framed webpage with different frames as below:
1 2 3
4 5
6 7 8
Contents of 1st, 3rd, 5th, 7th frame should be same again 2nd, 4th, 6th and 8th should be same.
10. Create a webpage to take input of a string and check whether it is a palindrome or not.
11. Write a program using JavaScript to display a structure as given below:
*
**
***
****
*****
12. Write a program using JavaScript to take input of an array of numbers like [-4, 5, 6, -
1, 10] and then sort it in descending order.
13. Create a webpage to take input of a string and reverse that without using any user
defined function.
14. Write a JavaScript program to search 10 in the array [2, 6, -5, 10, 11, 0, -2] using a
binary search method.
15. Write a JavaScript program to take two arrays like [3, 7, 1, 6, 2, 3] and [5, 6, 0, -3]
and merge them into third array along with that remove the repetitive elements.
16. Write a JavaScript program to calculate the percentage of three subjects’ (English,
Mathematics, and Science) marks along with the name of a student. The name and
individual marks input shall be taken by form in the webpage.
17. Create a webpage to take input of a string and count the number of vowels in it.
18. Create a webpage to take input of two strings and concatenate them without using any
built-in function.
19. Create a webpage to take input of a string and then slice it into three separate strings and
display that.
20. Write a JavaScript program to take two arrays like [1, 3, 8, 1, 6, 2, 3] and [2, 1, 5, 6, 0,
-3] and merge them into third array along with that remove the repetitive elements.
21. Write a JavaScript program to calculate and display the aggregate and percentage of
three subjects’ (Physics, Chemistry and Mathematics) marks along with the name of a
student. The name and individual marks input shall be taken by textbox in the
webpage.
22. Create a webpage to take input of a string and check whether it is a palindrome or not.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
SCHEME
Fifth Semester
Practical
Max Min
1. BCA551 Computer
Graphics Lab 50 25
2. BCA553 PE-I Lab 50 25
Android
Program
ming
Lab
Python
Program
ming
Lab
3. BCA554 PE-II Lab 50 25
Soft
Computing
Lab
Data
Analytics
Lab using R
Language
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
SCHEME
Fifth Semester
Choice Based Credit System
Course Content
Unit – I
Introduction to Graphics Systems: Video Display Devices, Raster Scan Systems, Random
Scan Systems, Graphics Monitors and Workstations, Input Devices, Hard Copy Devices,
Graphics Software. Three-Dimensional Viewing Devices, Stereoscopic & Virtual Reality
Systems
Unit – II
Output Primitives: Points and Lines, Line Drawing Algorithms (DDA and Bresenham’s
Algorithms), Loading the Frame Buffer, Circle Generating Algorithm, Filled Area Primitives –
Scan-line Polygon Fill Algorithm, Boundary-Fill Algorithm, Flood-Fill Algorithm, Color Tables.
Unit – III
Unit – V
TEXT BOOKS
1. HearnD. and BakerM. P., “Computer Graphics: C Version”, 2nd Edition, Pearson
Education, 2007.
2. BufordJ. F. K., “Multimedia Systems”, 1st Edition, Pearson Education, 2005.
REFERENCE BOOKS
1. FoleyJ. D., DamA. Van, Feiner S. K. and HughesJ. F., “Computer Graphics:
Principles and Practice in C”, 2nd Edition, Pearson Education, 2000.
2. ParekhR., “Principles of Multimedia”, 2nd Edition, Tata McGraw Hill, 2012.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- V
Course Content
Unit – I
Unit – II
Unit – IV
Course Content
Unit – I
Unit – II
Unit – III
Amazon Web Services: Compute Services, Storage Services, Communication Services. Google
AppEngine: Architectural and Core Concepts, Application Life-Cycle, Cost Model.
Unit – IV
Application of clouds in: Health care, Biology, CRM, ERP, Social Networking, Productivity and
Geoscience. Cloudlets for Mobile Cloud Computing.
TEXT BOOK
REFERENCE BOOK
1. HwangKai, FoxGeoffrey C., DongarraJack J., “Distributed and Cloud Computing
from Parallel Processing to the Internet of Things”, Morgan Kaufmann - India
Edition, 2012.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- V
Course Content
Unit – I
Unit – II
Android User Interface: Linear Layout, Absolute Layout, Frame Layout, Relative Layout, Table
Layout.
Unit – III
Designing User Interface with View: Text View, Push Button, Image Button, Edit Text,
Checkbox, ToggleButton, Radio Button, ProgressBar, Spinner, List View, Gridview, Time and
Date Picker.
Unit – IV
Displaying Pictures and Menus with Views: Gallery Views,ImageSwitcher, GridView, Options
Menu, Context Menu, DigitalClock View, Webview.
Unit – V
SQLITE Database in Android: SQLite Database, Creation and connection of the database,
extracting values from a cursor.
TEXT BOOK
1. DixitPrashant Kumar, “Android”, Vikas Publishing House Pvt. Ltd, 1stEdition, 2014.
REFERENCE BOOK
LeeWei-Meng, “Beginning Android for Application Development”, Wiley, Indian Edition.
SYLLABUS
Roll Number
Name
Login Id
Password
Submit
8. Write a program using Android Developer Studio/Eclipse to implement Check_box.
9. Write a program using Android Developer Studio/Eclipse to implement Radio_Button.
10. Write a program using Android Developer Studio/Eclipse to import image to Frame
Layout.
11. Write a program using Android Developer Studio/Eclipse to display an option Menu.
12. Write a program using Android Developer Studio/Eclipse to generate Analog Clock.
13. Write a program using Android Developer Studio/Eclipse to generate Digital Clock
14. Write a program using Android Developer Studio/Eclipse to load URL “google.com”.
15. Write a program using Android Developer Studio/Eclipse to load URL “bitmesra.ac.in”
16. Write a program using Android Developer Studio/Eclipse to accept a mobile number and
then send sms “Welcome”.
17. Write a program using Android Developer Studio/Eclipse to implement Context Menu.
18. Write a program using Android Developer Studio/Eclipse to display current date.
19. Create a SQLITE database Employee and Make a form in Android Studio/Eclipse to
allow data entry to Employee Form with the following command buttons:
Save
Employee Id
Employee Name
Cancel
Address
Date of Joining
1. Create a SQLITE database Student and Make a form in Android Studio/Eclipse to allow
data entry to Student Form with the following command buttons:
Submit
Roll No
Name
Cancel
Text Books:
1. DixitPrashant Kumar, “Android”, Vikas Publishing House Pvt. Ltd, 1 st Edition,2014.
Reference Books:
Programming Android, 2nd Edition, Zigurd Mednieks, Blake Meike, Laird Dornin, Masumi
Nakamura, O'Reilly Media, October 2012
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- V
Course Content
Unit – I
Lists:Introduction, List Basics, Copying Lists, Passing Lists to Functions, Returning a List from
a Function, Searching Lists, Sorting, Processing Two-Dimensional Lists, Passing Two-
Dimensional Lists to Functions, Multidimensional Lists.
Unit – IV
Tuples, Sets, and Dictionaries: Introduction, Tuples: Creating Tuples, Basic Tuple Operations,
Indexing and Slicing in Tuples, Tuple methods, Sets: Creating Sets, Manipulating and Accessing
Sets, Subset and Superset, Set Operations, Comparing the Performance of Sets and Lists,
Dictionaries: Creating a Dictionary, Adding, Modifying, and Retrieving Values, Deleting Items,
Looping Items, The Dictionary Methods.
Unit – V
Objects and Classes: Introduction, Defining Classes for Objects, Immutable Objects vs.
Mutable Objects, Hiding Data Fields, Class Abstraction and Encapsulation, Object-Oriented
Thinking.Inheritance and Polymorphism: Introduction, Superclasses and Subclasses, Overriding
Methods, The object Class, Polymorphism and Dynamic Binding, The isinstanceFunction. Class
Relationships: Association, Aggregation, composition.
Files and Exception Handling:Introduction, text input and ouput: opening a file, Writing Data,
Testing a File’s Existence, Reading All Data from a File, Writing and Reading Numeric Data,
Binary IO Using Pickling, Exception Handling, Raising Exceptions.
TEXT BOOK
1. Y. Daniel Liang, “Introduction to programming using python”, Pearson Education; First
edition (2017).
REFERENCE BOOK
1. Martin C. Brown, “Python: The Complete Reference”, McGraw Hill Education; Forth
edition (2018)
2. Mark Lutz, “Learning Python” O′Reilly Fifth edition (2013)
3. Mark Summerfield, “Programming in Python 3: A Complete Introduction to the Python
Language” Pearson Education; Second edition (2018)
SYLLABUS
2. Write a program to read two integers and perform arithmetic operations on them
(addition, subtraction, multiplication and division).
3. Write a program to read the marks of three subjects and find the average of them.
4. Surface area of a prism can be calculated if the lengths of the three sides are known.
Write a program that takes the sides as input (read it as integer) and prints the surface
area of the prism (Surface Area = 2ab + 2bc + 2ca)
5. A plane travels 395,000 meters in 9000 seconds. Write a program to find the speed of the
plane (Speed = Distance / Time).
6. You need to empty out the rectangular swimming pool which is 12 meters long, 7 meters
wide and 2 meter depth. You have a pump which can move 17 cubic meters of water in
an hour. Write a program to find how long it will take to empty your pool? (Volume = l *
w * h, and flow = volume/time).
8. A car starts from a stoplight and is traveling with a velocity of 10 m/sec east in 20
seconds. Write a program to find the acceleration of the car. [acc = (Vfinal−Vinitial)/
Time].
9. Write a Program to Prompt for a Score between 0.0 and 1.0. If the Score Is Out of Range,
Print an Error. If the Score Is between 0.0 and 1.0, Print a Grade Using the Following
Table
11. Suppose you want to develop a program to play a lottery. The program randomly
generates a two-digit number, prompts the user to enter a two-digit number, and
determines whether the user wins according to the following rules:
a) If the user’s input matches the lottery in the exact order, the award is $10,000.
b) If all the digits in the user’s input match all the digits in the lottery number, the award
is $3,000.
c) If one digit in the user’s input matches a digit in the lottery number, the award is
$1,000.
14. Write a program that prompts the user to enter a four-digit integer and displays the
number in reverse order.
17. Write a Program to Display the Fibonacci Sequences up to nth Term Where n is Provided
by the User.
18. Write a Program to Find the Sum of All Odd and Even Numbers up to a Number
Specified by the User.
21. Write a Program to Demonstrate the Return of Multiple Values from a Function
Definition.
24. Program to Print the Characters Which Are Common in Two Strings.
26. Write Python Program to Count the Number of Times an Item appears in the List.
27. Write a program to create a list of integer numbers. Sort the elements using any sorting
method.
28. Write a program to create a lists of integer numbers and perform the linear and binary
search.
29. Write a program to create a lists of cities names and perform the sort the cities name in
alphabetical order.
34. Write a program to create tuples, and perform the following operations: Merging of
tuples, Spliting of a tuple, comparison of two tuples.
35. Write a program to create an intersection, union, set difference, and symmetric difference
of sets.
36. Write a program with “MyRectangle” class aving the dimensions as data members and
area() as a method member. Calculate the area of each rectangle object created by user.
37. Design a class with name “MyComplex” to represent the complex number including the
constructor overloading, methods to perform the arithmetic operation over the two
complex numbers. Write the complete python program for the above design.
38. Design a class with name “Distance” to represent the distance in feet and inch. Include
the method to calculate the addition of two distances. Write the complete python
program for the above design.
39. Write a complete program to implement the Employee and its subclasses (Salarayed
Employee, DailyWaged Employee, Commission based employee) given in Hierarchical
and multilevel manner. The program should exhibit the use of super key word to invoke
the super class constructor.
40. Write a program to open a file and perform the reading and writing operation with the
file.
42. Write a program to count the frequencies of each word from a file.
44. Write a program to append a file with the content of another file.
46. Write a program to delete and insert a sentence at specified position in a file.
47. Write a program to delete a sentence from a file if the file contains a specific word.
Text Books:
1. Y. Daniel Liang, “Introduction to programming using python”, Pearson Education; First
edition (2017).
Reference Books :
1. Martin C. Brown, “Python: The Complete Reference”, McGraw Hill Education; Forth
edition (2018)
2. Mark Lutz, “Learning Python” O′Reilly Fifth edition (2013)
3. Mark Summerfield, “Programming in Python 3: A Complete Introduction to the Python
Language” Pearson Education; Second edition (2018)
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- V
Course Content
Unit – I
Fuzzy Set Theory: Basic Definition and Terminology, Set Theoretic Operations, Fuzzy types
and levels, MF Formulation and Parameterization, MF of two dimensions, Fuzzy Union,
Intersection and Complement, Fuzzy Number, Fuzzy measure.
Unit – II
Fuzzy Logic: Fuzzy Rules and Fuzzy Reasoning: Extension Principles and Fuzzy Relations,
Fuzzy IF THEN Rules, Defuzzification, Fuzzy Reasoning. Fuzzy Inference System:
Introduction, Mamdani Fuzzy Models, Other Variants, Sugeno Fuzzy Models, Tsukamoto Fuzzy
Models.
Unit – III
Unit – IV
Introduction to Artificial Neural Networks: What is a Neural Network? Human Brain, Models of
Neuron, Neural Network viewed as Directed Graphs, Feedback, Network Architecture,
Knowledge Representation, Learning processes:(Error correction, Memory-Based, Hebbian ,
Competitive, Boltzman ,Supervised,Unsupervised),Memory,Adaptation.
Unit – V
Text Books:
1. Jang J.S.R., Sun C.T. and Mizutani E., “Neuro-Fuzzy and Soft Computing” PHI/Pearson
Education, New Delhi, 2004.
2. Rajasekaran S. & Vijayalakshmi, G.A. Pai, "Neural Networks, Fuzzy Logic, and Genetic
Algorithms: Synthesis and Applications”, PHI, New Delhi, 2003.
3. Ross T. J., “Fuzzy Logic with Engineering Applications”, TMH, New York, 1997.
4. Haykins Simon, “Neural Networks:A Comprehensive Foundation”, Pearson Education,2002.
Reference Books:
1. Ray K.S., “Soft Computing and Its application”, Vol 1, Apple Academic Press.2015.
2. Lee K.H., “First Course on Fuzzy Theory and App.”, Adv in Soft Computing Spinger.2005.
3. Zimmermann H.Z., “Fuzzy Set Theory and its App”, 4thEdition, Spinger Science,2001.
Text Books:
1. Jang J.S.R., Sun C.T. and Mizutani E., “Neuro-Fuzzy and Soft Computing” PHI/Pearson
Education, New Delhi, 2004.
2. Rajasekaran S. & Vijayalakshmi, G.A. Pai, "Neural Networks, Fuzzy Logic, and Genetic
Algorithms: Synthesis and Applications”, PHI, New Delhi, 2003.
3. Ross T. J., “Fuzzy Logic with Engineering Applications”, TMH, New York, 1997.
4. Haykins Simon, “Neural Networks:A Comprehensive Foundation”, Pearson Education,2002.
Reference Books:
1. Ray K.S., “Soft Computing and Its application”, Vol 1, Apple Academic Press.2015.
2. Lee K.H., “First Course on Fuzzy Theory and App.”, Adv in Soft Computing Spinger.2005.
3. Zimmermann H.Z., “Fuzzy Set Theory and its App”, 4thEdition, Spinger Science,2001.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- V
Course Content
Unit – I
Analysis using Descriptive and Pictorial Statistics: mean, median, mode, harmonic mean,
geometric mean, variance and standard deviation, quantiles, skewness, moments and kurtosis.
Data Visualization: Summery table, Contingency table, Bar plot, Pie chart, Frequency
distribution, Relative frequency distribution, Cumulative frequency distribution, Histogram,
Frequency polygon, Cumulative frequency graphs, Box plot, Time series plot, Scatter diagram.
Unit – II
Data Relationships, Transformation, and Data Cleaning: Relationships between different types of
data: Relationship between two categorical data, Relationship between categorical and
quantitative data, Relationship between two quantitative data Transformation: The logarithm
transformation, Root and
square root transformation Standardization (Z-transformation), Min-max normalization. Data
cleaning: missing values, noisy data.
Unit – III
Analysis using Inferential Statistics: Sampling, Sampling Distribution, and Estimation of
Parameters, Sampling distribution of: means, proportions, difference of means, difference of
proportions. Hypothesis testing about: population mean, the difference between two means,
about a population proportion, difference between two proportions.
Unit – IV
Social Network and Text Data Analysis: What is a social network? Characteristics of social
network. Link mining: Tasks and challenges. Mining on social networks. Text data analysis and
informational retrieval. Dimensional reduction for text.
Unit – V
Outlier Analysis: Outlier detection based on: statistical distribution, distance based, deviation
based.
Text Books:
1. Gupta and Gupta, “Business Statistics”, Sultan Chand and Sons, 2014.
2. Bishnu and Bhattacherjee, Data Analysis: Using Statistics and Probability with R
Language, PHI Learning, 2019.
3. Han J and Kamber M, “Data Mining: Concepts and techniques”, Morgan Kaufmann
Publishers.
Reference Books:
Unit – II
8. Summery table, contingency table. 9. Frequency distribution, relative frequency distribution,
cumulative frequency distribution. 10 Histogram, frequency polygon, cumulative frequency
graphs, 11 Satter diagram. 12. Pie chart (2 D and 3 D) and bar plot (stacked and side by side). 13.
Time series plot.
Unit – III
14. Relationships between different types of data: Relationship between two categorical data. 15.
Relationship between categorical and quantitative data. 16. Relationship between two
quantitative data Transformation. 17. Logarithm transformation, Root and square root
transformation. 18. Z-transformation 19. Min-max normalization.
Unit – IV
20. Sampling distribution of: means. 21. Sampling distribution of: proportions. 22. Sampling
distribution of: difference of means. 23. Sampling distribution of: difference of proportions.
Unit – V
24. Hypothesis testing about: population mean. 25. Hypothesis testing about: the difference
between two means. 26. Hypothesis testing about: a population proportion. 27. Hypothesis
testing about: difference between two proportions. 28. Identification of outlier data using scatter
plot and regression line. 29. Identification of outlier data using quartiles. 30. Identification of
outlier data using box plot.
Text Books:
1. Jared P. Lander, R for Everyone: Advanced Analytics and Graphics, Addison-Wesley
Professional, 2017.
2. Bishnu, Partha Sarathi, Bhattacherjee, Vandana, Data Analysis : Using Statistics and
Probability with R Language, PHI Learning, 2019.
Reference Books:
1. Mark Gardener, Beginning R: The Statistical Programming Language, O’Reilly.
2. Hadley Wickham and , R for Data Science: Import, Tidy, Transform, Visualize, and
Model Data, O'Reilly.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
SCHEME
Sixth Semester
Course Content
Introduction: What is data mining? Motivating challenges. The origins of data mining. Data
mining tasks. Data: Types of Data. Attributes and Measurement. Types of Data Sets. Data
Quality Measurement and Data Collection Issues.
Unit – II
Measures of Similarity and Dissimilarity: Basics. Similarity and Dissimilarity between Simple
Attributes. Dissimilarities between Data Objects. Similarities between Data Objects. Examples
of Proximity Measures. Issues in Proximity Calculation. Selecting the Right Proximity Measure.
Unit – III
Unit – IV
Cluster Analysis: Basic Concepts and Algorithms. What Is Cluster Analysis? Different Types of
Clustering. Different Types of Clusters. K-means. Basic K-means Algorithm. Basic
Agglomerative Hierarchical Clustering Algorithm. Key Issues in Hierarchical Clustering. The
DBSCAN Algorithm.
Unit – V
Classification: Basic Concepts and Techniques. General Framework for Classification. Decision
Tree Classifier. A Basic Algorithm to Build a Decision Tree. Methods for Expressing Attribute
Test Conditions. Measures for Selecting an Attribute Test Condition. Algorithm for Decision
Tree Induction. Characteristics of Decision Tree Classifiers. Model Evaluation.
TEXT BOOK
1. Tan Pang-Ning, Steinbach Michael, andKumar Vipin , “Introduction to Data
Mining”, Pearson Education, New Delhi.
REFERENCE BOOKS
1. Han Jiawei & Kamber Micheline, “Data Mining Concepts & Techniques”,
Publisher Harcourt India. Private Limited, Second Edition
2. Dunham H.M. & Sridhar S., “Data Mining”, Pearson Education, New Delhi, 2006.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- VI
Course Content
Unit – I
Unit – II
Distributed Computing Paradigms: Paradigms and Abstraction, Message Passing, The Client-
Server Paradigm, the Message System Paradigm, Remote Procedure Call Model, RMI, The
Distributed Objects Paradigm, The Object space, The Mobile Agent Paradigm.
Unit – III
The Socket API: The Socket metaphor in IPC, The Datagram Socket API, The Stream-Mode
Socket API, Sockets with nonblocking I/O Operations, Secure Socket API.
The client server paradigm issuers, connection- oriented and connectionless servers, Iterative
server and concurrent server, stateful server and stateless server.
Unit – IV
Distributed Objects: Remote Procedure Calls, Distributed Objected Systems, Remote Method
Invocation, The Java RMI Architecture, The API for the Java RMI, RMI Security Manager,
Comparison of RMI
Remote Procedure Calls, Distributed Objected Systems, Remote Method Invocation, The Java
RMI Architecture, The API for the Java RMI, RMI Security Manager, Comparison of RMI and
Socket APIs.
Unit – V
TEXT BOOK
1. Liu M. L., “Distributed Computing: Principles and Application”, Pearson Education,
2008.
REFERENCE BOOK
1. AltiyaH., WelchJ., “Distributed Computing Fundamentals, Simulations and
Advanced Topics”, 2nd edition, Wiley – India Edition, 2006.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- VI
Course Content
Unit – I
Unit – II
Mobile Application Architectures, Client-Server layers and Tires, Client thin and fat & web page
Hosting, Server one, two and three tire architecture, Connection type with always, partially and
never connect, Good Architectural Design Tenets
Unit – III
Mobile Infrastructure, Mobile Device Types, Mobile Device Components, Connection Methods
Unit – IV
Mobile Client Applications, Thin Client, Fat Client, Web Page Hosting, Best Practices
Unit – V
Reference Books:
1. McWherterJeff, GowellScott, “Professional Mobile Application Development”, John Wiley &
Sons 2012.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- VI
Course Content
Unit – I
Unit – II
Unit – III
Amazon Web Services: Compute Services, Storage Services, Communication Services. Google
AppEngine: Architectural and Core Concepts, Application Life-Cycle, Cost Model.
Unit – IV
Application of clouds in: Health care, Biology, CRM, ERP, Social Networking, Productivity and
Geoscience. Cloudlets for Mobile Cloud Computing.
TEXT BOOK
REFERENCE BOOK
1. HwangKai, FoxGeoffrey C., DongarraJack J., “Distributed and Cloud Computing
from Parallel Processing to the Internet of Things”, Morgan Kaufmann - India
Edition, 2012.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- VI
Course Content
Introduction to networking: OSI Reference model, Active vs Passive attacks, Layers and
cryptography, Multilevel model of security.
Unit – II
Modes of Operation: encrypting large messages, Generating MAC’s, Multiple Encryption DES,
Hash and message digest: Using Hash for encrypting, MD2, MD4, MD5, SHA1.
Unit – III
Unit – IV
Real time communication security: Session key establishment, perfect forward secrecy, DOS,
clogging protection, Arranging for parallel computation, session resumption, data steam
protection, plausible deniability.
Unit – V
TEXT BOOK
1. Kaufman Charlie, Perlman Radia and Speciner Mike, “Network
Security: Private Communication in a Public World”, 2nd Edition,
Prentice Hall, 2002.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
New Scheme Based on AICTE Flexible Curricula
Semester- VI
Course Content
Unit – I
IPsec protocols - IP Authentication header - IP ESP, Key management protocol for IPsec,
Transport layer Security: SSL protocol, Cryptography computations - TLS protocol
Unit – II
PGP - S/ MIME: Internet Firewalls for Trusted System: Roles of Firewalls - firewall related
terminology, Types of Firewalls, Firewall design, Honeycomb design: Set for E-Commerce
transactions
Unit – III
methodology, Forensics duplication & investigations, Preparation of IR: Creating response tool
kit & IR team, Forensics Technology & Systems
Unit – IV
Processing Crime & Incident Scenes, Working with windows & DOS systems, Current computer
Forensics tools: Software/ hardware tools
Unit – V
Validating Forensics data, Data hiding techniques, Performing Remote Acquisition, Network
Forensics, Email investigations, Cell phone & Mobile devices Forensics
Text Books:
1. Albert J. Marcella Jr., & Frederic Guillossou, “Cyber Forensics: From Data to Digital
Evidence”, John Wiley and Sons, ISBN-13: 978-1118273661, 2012.
RKDF UNIVERSITY, RANCHI
Bachelor of Computer Applications (BCA)
Unit-I:
Unit-II:
Unit-III:
Unit -IV:
Distributed DBMS Reliability: Reliability Concepts and Measures, Failures and Fault
Tolerance in Distributed Systems, Failures in Distributed DBMS, Local Reliability Protocols,
Distributed Reliability Protocols.
TEXT BOOK
REFERENCE BOOKS
Unit-I
Introduction to DSS:
Definition. Types of DSS. Data and Model Management. DSS Knowledge Base. User interface.
The DSS user. Categories and classes of DSS.
Unit -II
Definition. Types of decision. Different levels of Decision makers in the organization and their
requirement. Decision effectiveness. Simon’s model of decision making. Rational decision
making. Bounded rationality. Biases and heuristics in decision making.
Unit -III
Group decision making. GDSS modeling. Brainstorming process. MDM support technologies.
Managing MDM activities. System perspective of a DSS: DSS in the context of information
system. Information quality issues in DSS design. Role of internet in DSS development.
Unit -IV
Strategies for DSS analysis and design. The DSS developer. Tools for DSS development.
Implementing and Integrating DSS: DSS implementation. System evaluation. The importance of
Unit-V
TEXT BOOK
1. Marakas George M., “Decision Support Systems in the 21st century”, Pearson education.
REFERENCE BOOKS
1. Turban Efraim, “Decision Support Systems and Intelligent Systems”, Pearson Education.