DETAILED SYLLABUS

FOR
MASTER OF COMPUTER APPLICATIONS
(MCA)

(EFFECTIVE FROM BATCH 2020-22)

[UNDER CBCS SYSTEM]

MAKHANLAL CHATURVEDI NATIONAL UNIVERSITY OF JOURNALISM & COMMUNICATION

B-38, Vikas Bhawan, Press Complex, M.P. Nagar, Zone-I, Bhopal – 462011
Web : www.mcu.ac.in e-mail : [email protected]
 ABOUT UNIVERSITY

Makhanlal Chaturvedi National University of Journalism and Communication (MCNUJC) was

established 29 years ago. Carrying forward the legacy of excellence, it is a lead
leader
er and pioneer in
Mass Communication, Media, Journalism, Computer Applications, Digital media, and
Management Education.
Established in 1990 by the Madhya Pradesh Government, MCNUJC is named after Pt.
Makhanlal Chaturvedi, the great editor, poet, litterateur and freedom fighter. It is the first
academic centre of excellence in the entire Asian sub sub-continent
continent where professionals are
developed in Communication, Media, and IT disciplines through traditional and modern
methods of communication relevant to the current media needs. The University is also
recognised under section 12(B) of UGC.
Sticking to the newest trends of Media and Information Technology, the University conducts
postgraduate, undergraduate as well as skill
skill-oriented
oriented diploma courses in Journalism,
Jo
Broadcast Journalism, Advertising and Public relations, Electronic Media, New Media,
Computer Applications Media management and Communication Research.
University has been a pioneer in launching many new job job-oriented
oriented courses of significance,
whichh have received enormous appreciation among employers. The University has a focused
approach towards professional education, training and innovative methods of teaching and
learning. Students get opportunity to study subjects of their choice under the Choice
Choi Based
Credit System (CBCS) as per the industry needs. The University is equally appreciated for its
research contribution through its research scholars leading to the award of PhD in Media and
Computer Applications. Most of the faculty members of the un university
iversity hold a PhD along with
strong research contribution.
MCNUJC is a unique amalgamation of Media and IT professionals and academicians. Today,
the university is also providing education to the remote rural areas with a wide network of over
more than 1700 700 associated study institutes, where annually over one lakh students are
studying in regular programmes. This is a grand indicator of the university’s success,
credibility, popularity and recognition.
Our faculty members are renowned for their dynamic ap
approach,
proach, research and dedication. They
are approachable and enthusiastic teachers who make their disciplines accessible and
enjoyable. The university aims to transform dreams and ambitions of students into global
opportunities for success. Alumni are placed in renowned print media institutions, channels,
advertising agencies, public relations firms, graphic designing and multimedia world,
information technology and computer industries and many of them occupy senior positions.
What makes MCNUJC the first choichoice
ce for media, communication and IT education in the entire
country is its comprehensive academics with exceptional industry exposure and quality
education on affordable fee structure with the best professional environment.
Hon’ble Vicee President of India is the Visitor of our university. The Chief Minister of Madhya
Pradesh is the Chairman of the General Council and the Management Committee of the
University. General Council is the supreme decision
decision-making
making body of the university and it
directs the academic and administrative activities of the university. Many distinguished people
in the media like the Chairman of Press Council of India, representative of Editors’ Guild,
reputed information technology professionals, renowned teachers and well-known
known personalities
of the country and the state are nominated as the members of the General Council. The

Dr. C.P.Agrawal
 Master of Computer Applications (MCA) - 2020 Semester - I

Management Committee of the university executes the policy and administrative matters.
Leading University through managing, teaching and administ
administering
ering lie with the Vice Chancellor
of the university. The Academic Council includes distinguished teachers of media and
computers, senior professionals and heads of the university departments. It provides guidance
and decides matter related to teaching, tr
training
aining and research activities of the university. The
Vice Chancellor is also the Chairman of the Academic Council.

Page 3 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

MASTERS OF COMPUTER APPLICATION (MCA)

Level – Postgraduate Duration – 2 years ( 4 Semesters) Seats – 60

Eligibility Criteria
Passed BCA/Bachelor Degree in Computer Science Science/Engineering
Engineering or equivalent Degree
OR
Passed B.Sc./B.Com./B.A. with Mathematics at 10+2 Level or at Graduation Level (with
additional bridge Courses as per the norms of the University).
Candidate must Obtained at least 50% marks (45% marks in case of candidate belonging
to reserved category) in the qualifying Examination

ABOUT THE PROGRAMME

Master of Computer Applications (MCA) is a two years post graduate programme. The
curriculum of MCA is designed to meet the growin
growingg demand of qualified professionals in the
field of ICT. It comprises of the core subjects like database, networking, data structure, core
programming languages like C, C++, .NET and Java. Students also get exposure to advanced
topics like cyber security, mobile software, IOT, data science etc. Elective papers help students
to have an exposure in Cloud Computing, Big Data and Information Security related subjects.
COURSE OBJECTIVE
 To empower students with basic skills of various technologies.
 To develop the ability to identify, analyse, formulate and develop computer applications.
 To enable the students to select modern computing tools and techniques and use them
with
dexterity.
If you are looking for challenging roles in the IT industry, computer science research,
web and mobile development, data analysis, information security etc., this programme is
for you.
CAREER PATH YOU CAN CHOOSE AFTER THE COU
COURSE
 Software Developer.
 Programmer.
 Systems Analyst.
 Computer Support.
 Engineer.
 Database Administrator.
 Systems Administrator.
 Web Designer & Developer.
 Network Administrator.

Page 4 Dr. C.P.Agrawal

 MCA (2 YEAR) PROGRAMME SCHEME 2020-22
Core Courses Core Courses Elective Skill Enhancement Open Electives (OE)
Compulsory (CCC) (CCE) Courses (SEC)
Semester 2 Professional Core courses Professional Elective Courses Professional Skill Oriented
Choose 1 Course of 3 Credits From University
of 5 Credits of 5 Credits Courses of 3 Credits
Open Electives for PG in Each Semester
2*5= 10 Credits (Choose 2 Courses) (Choose 2 Courses)
1*3 = 3 Credits
2* 5 = 10 Credits 2*3 = 6 Credits
I  Database Management  Operating Systems  Linux Server  Management Information Systems
System  Computer Organization & Administration  Advanced Excel
 Programming with Architecture  Programming with C++  Multimedia Systems
VB.Net and ASP.Net  Discrete Mathematics  Professional
Communication Skills
II  Data Mining and  Data Structures and  Programming in Python  Statistical Methods
Business Intelligence Algorithms
s  NOSQL Databases  Virtual Reality
 Web Technologies  Computer Networks  Digital Marketing  Angular Java Script
 Computer Graphics
III  Software Engineering  Theory of Computation  Programming with R  Social Media Mining
 Java Programming  Big Data  Internet of Things  Service Oriented Architecture
 Development and  User Interface Design  Software Testing and Quality Assurance
Operational Tools (Dev
(DevOps)
IV  Cloud Computing  Management Theory &  Cyber Security  Blockchain Technology
 Project Work (5 Credits) Practices  Agile & Scrum  Programming with Go
 Artificial Intelligence &  Data visualization  Software Project Management
Machine learning  Enterprise Resource Planning (ERP) & CRM
 Mobile Application
Development

Dr. C.P.Agrawal
 Semester – I
Course Course Title Hours Per Week Credit End- Continu-
Continu End- Total
CC/C Code L T P Term ous Term Marks
E/SE/ Theory Evaluation Practical
OE Exam Marks Exam
Marks Marks
Database Management
CC 1MCACCC1 3 0 4 5 50 20 30 100
System
Programming with
CC 1MCACCC2 3 0 4 5 50 20 30 100
VB.Net and ASP.Net
1MCACCE(A) Operating Systems 5 0 0 5 80 20 0 100
(CE) Select Any 2

Computer Organization
1MCACCE(B) 5 0 0 5 80 20 0 100
& Architecture
1MCACCE(C) Discrete Mathematics 5 0 0 5 80 20 0 100
Linux Server
(SE) Select Any 2

1MCASEC(A) 1 0 4 3 0 10 40 50
Administration
1MCASEC(B) Programming with C++ 2 0 2 3 0 10 40 50
Professional
1MCASEC(C) 2 1 0 3 40 10 0 50
Communication Skills
Management
(OE) Select Any 1

1MCAOE(A) 3 0 0 3 40 10 0 50
Information Systems
1MCAOE(B) Advanced Excel 2 0 2 3 40 10 0 50

1MCAOE(C) Multimedia Systems 2 0 2 3 40 10 0 50

SEMESTER TOTAL 29 550

1 Hr. Lecture (L) per week - 1 credit 1 Hr. Practical (P) per week - 0.5 credit
Definition of Credit
1 Hr. Tutorial (T) per week - 1 credit 2 Hours Practical(Lab)/week - 1 credit

Semester –II
Course Course Title Hours Per Week Credit End- Continu-
Continu End- Total
CC/
Code L T P Term ous Term Marks
CE/S
Theory Evaluation Practical
E/
Exam Marks Exam
OE
Marks Marks
Data Mining and
CC 2MCACCC1 4 1 0 5 80 20 0 100
Business Intelligence
CC 2MCACCC2 Web Technologies 2 0 6 5 50 20 30 100
(SE) Select Any 2 (CE) Select Any 2

Data Structures and

2MCACCE(A) 4 0 2 5 80 20 0 100
Algorithms
2MCACCE(B) Computer Networks 4 1 0 5 80 20 0 100
2MCACCE(C) Computer Graphics 4 1 0 5 80 20 0 100

2MCASEC(A) Programming in Python 2 0 2 3 0 10 40 50

2MCASEC(B) NOSQL Databases 2 0 2 3 0 10 40 50

2MCASEC(C) Digital Marketing 2 0 2 3 40 10 0 50

(OE) Select Any

2MCAOE(A) Statistical Methods 2 1 0 3 40 10 0 50

2MCAOE(B) Virtual Reality 2 0 2 3 40 10 0 50
1

2MCAOE(C) Angular Java Script 2 0 2 3 40 10 0 50

SEMESTER TOTAL 29 550

Dr. C.P.Agrawal
 Semester –III
Course Course Title Hours Per Credit End- Continu-
Continu End- Total
CC/
Code Week Term ous Term Marks
CE/S
L T P Theory Evaluation Practical
E/
Exam Marks Exam
OE
Marks Marks
CC 3MCACCC1 Software Engineering 4 1 0 5 80 20 0 100
CC 3MCACCC2 Java Programming 3 0 4 5 50 20 30 100
(SE) Select Any 2 (CE) Select Any 2

3MCACCE(A) Theory of Computation 4 1 0 5 80 20 0 100

3MCACCE(B) Big Data 3 0 4 5 80 20 0 100
Development and
3MCACCE(C) 3 0 4 5 50 20 30 100
Operational Tools ((DevOps)

3MCASEC(A) Programming with R 2 0 2 3 0 10 40 50

3MCASEC(B) Internet of Things 2 0 2 3 0 10 40 50

3MCASEC(C) User Interface Design 2 0 2 3 0 10 40 50

3MCAOE(A) Social Media Mining 2 0 2 3 40 10 0 50

(OE) Select Any 1

Service Oriented
3MCAOE(B) 2 0 2 3 40 10 0 50
Architecture
Software Testing and
3MCAOE(C) 2 1 0 3 40 10 0 50
Quality Assurance
SEMESTER TOTAL 29 550

1 Hr. Lecture (L) per week - 1 credit 1 Hr. Practical (P) per week - 0.5 credit
Definition of Credit
1 Hr. Tutorial (T) per week - 1 credit 2 Hours Practical(Lab)/week - 1 credit

Semester - IV
Course Course Title Hours Per Credit End- Continu-
Continu End- Total
CC/ Code Week Term ous Term Marks
CE/S L T P Theory Evaluation Practical
E/ OE Exam Marks Exam
Marks Marks
CC 4MCACCC1 Cloud Computing 3 0 4 5 50 20 30 100
CC 4MCACCC2 Project Work 0 2 6 5 0 20 80 100
Management Theory &
4MCACCE(A) 5 0 0 5 80 20 0 100
(CE) Select Any 2

Practices
Artificial Intelligence &
4MCACCE(B) 4 0 2 5 80 20 0 100
Machine learning
Mobile Application
4MCACCE(C) 3 0 4 5 80 20 0 100
Development
(SE) Select Any 2

4MCASEC(A) Cyber Security 2 0 2 3 40 10 0 50

4MCASEC(B) Agile & Scrum 2 1 0 3 40 10 0 50

4MCASEC(C) Data visualization 2 1 0 3 40 10 0 50

4MCAOE(A) Blockchain Technology 2 0 2 3 40 10 0 50

(OE) Select Any 1

4MCAOE(B) Programming with Go 1 0 4 3 40 10 0 50

Software Project
4MCAOE(C) 2 0 2 3 40 10 0 50
Management
Enterprise Resource 10
4MCAOE(D) 3 0 0 3 40 0 50
Planning (ERP) & CRM
SEMESTER TOTAL 29 550

Dr. C.P.Agrawal
 Master of Computer Applications (MCA) - 2020 Semester - I

SEMESTER-I
1MCACCC1 - DATABASE MANAGEMENT SYSTEM

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 3 0 4 5 50 20 30 100

Prerequisite: Students are expected to know following topics before learning the syllabus.
Theory classes may be organized if required. These topics are prerequisite not to be included
for theory exam :- Significance of Databases
Databases, Database System Applications,, Advantages and
Disadvantages of different Database Management systemssystems, Comparison between DBMS,DBMS
RDBMS,, Distributed and Centralized DB, Database design ER Diagram, Relational Databases:
Integrity Constraints, Functional Dependency
Dependency, Multi-valued Dependency, Normalization.
Normaliz
COURSE OBJECTIVES
 To create andmanipulate
manipulate a database using SQL.
 To know database administration basics and practice commands.
 To Understand File Organization and Indexing in Database.
 To Acquire the Knowledge of Query Evaluation to Monitor the Performance of the DBMS.
 To Impart Knowledge in Transaction Processing
Processing, Concurrency Control Techniques and
Recovery Procedures.
 To Know Parallel, Distributed
Distributed, Object relational and XML database basics.
COURSE OUTCOME
 Understand and describe the basic concepts and terminology of Database Management
System.
 Apply query language commands using MySQL.
 Understand internal storage mechanism
mechanism, File Organization and Indexing in Database.
 Understand Concurrency, Transaction and recovery management concepts.
 Know Basic Concepts in parallel
parallel, distributed, object relational and XML database.

UNIT-WISE SYLLABUS

UNIT I
Database creation & using through MySQL
MySQL, Query Language Introduction, DDL,
DDL DML and DCL
Commands, Integrity Constrain
Constraints, Query Structure, Basic Operations, SQL Data Types and
Schemas, Set Operations, Null Values
Values, Aggregate Functions, Sub queries, Modification
Modi of the
Database, Join Expressions
UNIT- II
Views, Transactions, Authorization
Authorization, Trigger, Recursive Queries, Database
base Administration
Basics, Running and Shutting Down
Down, setting up Account, Users Role and privileges,
privileges MySQL
Show Command, Backup and Restore
Restore.(all above are implemented in labusing
sing MySQL)

Page 8 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT III
Overview of Physical Storage Media
Media, RAID, Storage Access, File Organization,, Organization of
Records in Files, Data-Dictionary
Dictionary Storage
Storage, Indexing Basics, Ordered Indices,
Indices B+-Tree Index
Files, B-Tree Index Files, Hashing
Hashing, Multiple-Key Access, Query Optimization Basics.
UNIT-IV
Transaction Concept, Transaction State
State, Concurrent Executions,, Serializability, Recoverability,
Concurrency Management, LockLock-Based Protocols, Timestamp-BasedBased Protocols,
Protocols Validation-
Based Protocols, Recovery, Failure Classification
Classification, Storage Structure, Recovery and Atomicity,
Atomicity
Log-Based Recovery
UNIT-V
Database system Architecture
Architecture, Centralized and Client-Server Systems,, Server System
Architectures Parallel Systems, Distributed Systems
SystemsParallel Databases, I/O Parallelism,
Parallelism Design
of Parallel SystemsDistributed Databases
Databases, Heterogeneous and Homogeneous Databases,
Distributed Data, StorageObject Relational Database
Database, XML database.

TEXT & REFERENCE BOOKS

 MySQL 8.0 Reference Manual Available online at

https://dev.mysql.com/doc/refman/8.0/en/
 MySQL 8.0 Reference Manual in PDF format available online at
https://downloads.mysql.com/docs/refman
https://downloads.mysql.com/docs/refman-8.0-en.pdf
 Learning MySQL by Hugh E. Williams, Seyed M.M. Tahaghoghi
Tahaghoghi, O’Reilly,, ISBN-978-
ISBN
596008642
 Beginning MySQL by Geoff Moes
Moes, Robert Sheldon Wrox Publictions, ISBN –0764579509
 Creating your MySQL Database: Pract
Practical
ical Design Tips and Techniques by Marc Delisle,
PACKT Publications, ISBN-978
978-1904811305
 Mysql: The Complete Reference by Vaswani Vikram, Tata McGraw-Hill
Hill Education India,
India
ISBN: 9780070586840, 9780070586840
 Murach'S Mysql by Murach Joel, PACKT Publishing, ISBN: 9789350237694,
9789350237694

Page 9 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCACCC2 - PROGRAMMING WITH VB.

VB.NET
NET AND ASP.NET

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 3 0 4 5 50 20 30 100

COURSE OBJECTIVES
 Identify the basics of.NET framework
framework, architecture and user programs.
 Do GUIprogramming using VB.NET
 Examine the challenges involved in
in.NET framework programming
 Do event driven programming projects
 Learn the ADO..NET Database Usages in Website Creation
 Develop
velop Websites with use of ASP.
ASP..NET.
COURSE OUTCOME
 Understand and explore various features of VB.NET framework
 Analyze, design
sign and develop the GUI based applications software using VB.NET.
 Design, develop and implement complete software projects using VB.NET with
consideration of environment in team spirit.
 Analyze the requirement, design and develop dynamic and static websites and web
applications using.NET technology.
 Integrate and apply different components including database
database, with proper choice of
languages mapping

UNIT-WISE SYLLABUS

UNIT- I
Object-Oriented Programming:: Classes and Objects
Objects, Fields, Properties, Methods,
Methods and Events,
Abstraction, Encapsulation, Inheritance
Inheritance, and Polymorphism, Overloading,
Overloading Overriding,
Shadowing, Constructors and Destruct
Destructors,.Net
Net Framework : Features & Architecture,
Architecture Common
Language Runtime, Common Type System
System, MSIL, Class Libraries. Event Driven
Drive Programming,
Methods and Events. Programming into Visu
Visual Studio, IDE of VB.Net- Menu Bar, Toolbar,
Project Explorer, Toolbox, Pro
Properties Window, Form Designer, Form Layout, Layout Immediate
Window, ASP & HTML Forms, Building VB.NET and C# Applications
UNIT- II
Visual Basic Language: Operators
Operators, Conditionals, Loops, Statements, Variables,
Variables Data Types,
Arrays and Dynamic Arrays, Operators. Pr
Procedures,, Scope, and Exception Handling, Creating
Functions, Exception Handling,, Using Resume Next and Resume Line, Using On Error GoTo,
GoTo
Windows Forms : Loading, Showing and Hiding Forms
Forms, Working with Multiple Forms,
Forms Creating
Windows Applications, Adding Controls to Forms, Handling Events, MsgBox Function, Function
InputBox Function, Startup Form
Form, Multiple Document Interface (MDI) Applications,
Applications Dialog
Boxes, Controls at Run Time, Mouse Events
Events, Keyboard Events, Beeping, Deploying Applications

Page 10 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT- III
.NET Tools: Control Class, Text Boxes
Boxes, Rich Text Boxes, Labels, Link Labels,
Labels Buttons,
Checkboxes, Radio Buttons, Panels
Panels, and Group Boxes, List Boxes, Checked List Boxes,
Boxes Combo
Boxes, and Picture Boxes, Scroll Bars
Bars, Splitters, Track Bars, Pickers, Notify Icons,
Icons Tool Tips,
and Timers, Menus, Built-inin Dialog Boxes
Boxes, and Printing, Image Lists, Tree and List Views,
Views
Toolbars, Status and Progress Bars
Bars, and Tab Controls
UNIT- IV
Web Forms with ASP.Net: Web Form Controls Controls, HTML, Web Applications,, Multiform Web
Project, Client Events, Title Bar Text
Text, Error Page, Search Engine Keywords, Embedding Visual
Basic Code in Web Pages, Validation Controls
Controls, Calendars. Introduction to Windows Services &
Web Services
UNIT- V
Data Access with ADO.NET: Server Explorer Data Adaptors and Datas
Datasets, ADO.NET Objects,
Objects
Data Connection, Dragging Tables
Tables, Dataset, Data Grid, Data Adapter Controls,
Controls Dataset
Schema, MS Jet Database, Relational Databases.Binding Controls to Databases: Simple
Binding, Complex Binding, Navigating in Datasets
Datasets, Data Forms, Handling
dling Databases in Code,
Database Access in Web Applications.

TEXT &REFERENCE BOOKS

 Steven Holzner, VB.Net Programming

Programming-Black Book-Dreamtech
Dreamtech Publications
 EvangelosPetroutsosMastering VB.Net - BPB Publications
 Mathew Macdonald-The
The Complete Reference Asp.Net-TMH
 Professional ASP.Net- Wrox Publication
 Stephen Walther Active Server Pages 2.0 (Unleashed) -Techmedia
 Eric A.. Smith ASP 3 Programming Bible: IDG Books

LIST OF PRACTICAL

1. Write a program to perform arithmetic operation in console application using

usin switch case.
2. Write a program to perform reverse number.
3. Write a console application that obtains four int
integer values from the user and displays the
product.
4. If you have two integers stored in variables var1 and var2 var2, what Boolean test can you
perform to see if one or the other (but not both) is greater than 10?
5. Write an application that includes the logic from Exercise 4
4, obtains two numbers from the
user, and displays them, but rejects any input where both numbers are greater than 10
and asks for two new numbers.
6. Write a console application that places double quotation marks around each word in a
string.
7. Write an application that uses two command
command-line
line arguments to place values into a string
and an integer variable, respectively. Then display these values.
8. Write an application that receives the following information from a set of students:

Page 11 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

 Student Id:
 Student Name:
 Course Name:
 Date of Birth:
The application should also display the information of all the students once the data is
Entered.
9. Create an application that allows the user to enter a number in the textbox named
“getnum‟. Check whether
ther the number in the textbox ““getnum‟ is palindrome or not. Print
the message accordingly in the label control named lbl display when the user clicks on the
button “check‟.
10. Write a program to declare clas
class “Distance‟ have data member’s dist1, dist2, dist3.
Initialize the two data members using constructor and store their addition in third data
member using function and display addition.
11. Define a class “salary‟ which will contain member variable Basic, TA, DA,
DA HRA. Write a
program using Constructor with default values for DA and HRA and calculate the salary of
employee.
12. Write a program to check whether the given number is Armstrong number or not.
13. Write a console application
cation for bank account in C#
C#.Net.
14. Write a console application to display student information using class and object.
15. Write a console application to display employee information using properties.
16. Write a console application for a class person having data members name & age. Accept the
value for this using constructor. And display the output for one object.
17. Write a console application containing a method that will swap the value of two integer type
variable.
18. Write a console application calculate the area an
andd circumference of circle & rectangle using
inheritance.
19. Write a program for calculates the area and circumference of circle & rectangle using
abstract class.
20. Design a sign-Up form & validate user phone no with exactly 10 digit and email-id.
email
21. Design a sign-up form & validate username (minimum 8 characters &maximum 15and
15 only
character), password and retype password (both should be same)
22. Design a web application form having loan amount
amount, interest
rest rate and duration fields.
Calculate
alculate the simple interest and perf
perform necessary validation i.e. Ensures data has been
entered for each field. Checking for non-numeric value.
23. Create an application which will ask the user to input his name and a message,
message display the
two items concatenated in a label
label, and change the format of the label using radio buttons
and check boxes for selection
selection, the user can make the label text bold, underlined or italic
and change its color. include buttons to display the message in the label,
label clear the text
boxes and label and exit.
24. List of employeess is available in list box.. Write an application to add selected or all records
from listbox (assume multi-line
line property of textbox is true).

Page 12 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

25. “How is the book ASP.NET with C# by Raj Sharma?” Give the user three choice :i)Good
ii)Satisfactory iii)Bad. Provi
Provide a VOTE button. After user votes, present the result in
percentage using labels next to the choices.
26. Create a project that calculates the total of fat
fat, carbohydrate and protein. Allow the user to
enter into text boxes. The grams of fat
fat, grams of carbohydrate
rate 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 ente
entered.
red. 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.
27. Create a Global.asax file with Application variables co count, color1 and gotohp. Create a
Session variable
riable called cont1. Initialize co
count
nt as 0 and assign any color to color1. For the
variable
iable gotohp, give a hyperlink to any Website. Use the variables in a Web Form. Try
these with the lock and unlock methods.
28. Write a program that gets user input such as the user name
name, mode of payment,
payment appropriate
credit card. After the user enters the appropriate values the Validation button validates the
values entered.
29. Create the application that accepts name
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.
30. Create a Web Application to display all the Empname and Deptid of the employee from the
database using SQL source control and bind it to GridView
GridView. Database fields are(DeptId,
are(DeptId
DeptName, EmpName, Salary)
31. Create a Login Module which adds Username and Password in the database. Username in
the database should be a primary key.
32. Write a program to get a user input such as the boiling point of water and test it to the
appropriate value using Compare Validator.
33. Create a web application to insert 3 records inside the S
SQL
QL database table having following
fields(DeptId, DeptName, EmpName
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.
34. Create a web page to display the cr cricket
icket score from the table event (id,
(id name, score).
Refresh the website automatically after every 30 seconds.
35. Write a program to display three images in a line. When any one of the images is clicked, it
must be displayed below. On clicking the displayed im
image
age it must be cleared.
36. Design a college website (minimum
minimum 4 pages)
37. Design a company website (minimum
minimum 4 pages)

Page 13 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCACCE(A) - OPERATING SYSTEMS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 5 0 0 5 80 20 0 100

COURSE OBJECTIVES
 To Understand the Services Provided by Operating System
 To Understand the Working and Organization of Process and its Scheduling and
Synchronization.
 To Understand the Concept of Deadlock.
 To Understand Different Approaches to Memory Management Techniques.
 To Understand the Structure and Organization of the File System.
COURSE OUTCOMES
 Identify and describe the Services Provided by Operating Systems.
 Understand and Solve Problems Involving Process Control, Mutual Exclusion,
Exclusion
Synchronization and Deadlock.
 Implement Processor Scheduling
Scheduling, Synchronization and Disk Allocation Algorithms for a
Given Scenario
 Apply Various Approaches of Memory Management Techniques
 Analyze Various Operating System A
Approaches in Linux and Windows

UNIT-WISE SYLLABUS

UNIT– I
Definitions, Components and Types of Operating System
System, Operating System Services,
Services System
Calls, System Programs, Process Concepts
Concepts, Process State & Process Control Block,
Block Process
Scheduling, Scheduling
ng Criteria
Criteria, Scheduling Algorithms, Multiple-Processor
Processor Scheduling,
Scheduling Real-
Time Scheduling, Threads Introduction
UNIT–II
The Critical Sections Problem,, Semaphores, Classical Problem of Synchronization,
Synchronization Deadlock
Characterizations, Method for Handling Deadlocks
Deadlocks, Deadlock Prevention, Deadlock Avoidance,
Avoidance
Deadlock Detection, Recovery from Deadlock
Deadlock, Combined Approach to Deadlock
UNIT–III
Storage Management Logical Versus Physical Address Space
Space, Swapping, Contiguous Allocating,
Allocating
Paging, Segmentation, Virtual Memory
Memory, Demand Paging, Performance of Demand Paging,
Paging Page
Replacement, Page Replacement Algorithms
Algorithms, Thrashing, Demand Segmentation
UNIT–IV
Disk Structure, Disk Scheduling
Scheduling, Disk Management, Swap Space Management,
Management Disk
Reliability, Stable Storage Implementation
Implementation, File Concepts, Directory Structure,
Structure Protecting, I/O
Subsystem Overview, I/O Hardware
Hardware, Application I/O Interface, Kernel I/O Subsystem

Page 14 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT–V
Case Studies: Linux System: History
History, Components, Kernel Modules, Process Management –
Model, Identity, Context, Schedu
Scheduling – Kernel Synchronization, Process Scheduling,
Scheduling Memory
Management of Physical Memory
Windows System: History, Design Principal
Principal, Components

TEXT &REFERENCE BOOKS

 Silberschatz, Galvin, Gagne

Gagne-Operating System Concepts -Wiley
Wiley Student Edition
 Milan Milenkovic-Operating
Operating System Concepts & Design
Design-TMH Publication
 Andrew S. Tanenbaum-Modern
Modern Operating System
System-PHI

Page 15 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCACCE(B) - COMPUTER ORGANIZATIO

ORGANIZATIONN & ARCHITECTURE

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 5 0 0 5 80 20 0 100

COURSE OBJECTIVES
 To understand the basic blocks of digital logic.
 Understand basic operation of Combinational Circuits.
 Understand the Boolean algebra and map simplification.
 To examine the basics of assembly programming.
 To learn the memory addressing techniques and I/O organization.
COURSE OUTCOMES
 Able to Apply Boolean algebra and map simplification to digital circuit design
 Able to Apply the flip-flop
flop operation to design the timing and control circ
circuit
uit
 By using memory addressing techniques solve memory address problem
 Able to write
rite assembly code for some basic problem.
 Understand the various types of memory and their functions.

UNIT-WISE SYLLABUS

UNIT-I
Digital Logic Circuits : Digital Computers
Computers, Logic Gates, Boolean Algebra, Map Simplification,
Simplification
Product-of sums simplification,, don’t-care-conditions, Combinational Circuits,, Half-Adder, Full
–Adder, Sequential Circuits, Flip
Flip-Flops SR, & J K, Basis Computer Organization,
Organization Instruction
codes, Stored programram organization
organization, Computer registers, CommonBus system,
system Computer
Instructions, timing and Control
Control, Instruction Cycle, Memory-Reference
Reference Instructions,
Instructions Input-
Output and Interrupt, Complete Computer Description
UNIT-II
Basis Computer Organization and Design : Design of Basis Computer, Control Logic Gates,Gates
Control of Registers and Memory
Memory, Design of Accumulator Logic, Control of AC Register,
Register Adder
and Logic Circuit, Multiple Bus Organization of Computer
Computer, Memory Addressing
UNIT-III
Programming the Basis Computer:
Computer:Programming the Basis Computer, Machine Languages,
Languages
Assembly Language, The Assembler
Assembler, Program Loops, Programming Arithmetic and Logic
Operations, Subroutines, subroutine Parameters and Data Linkage
Linkage,, Input output
Programming, Character Manipulation
Manipulation, Program Interrupt

Page 16 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT-IV
Micro programmed Control:Control
Control Memory
Memory, Address Sequencing, Conditional Branching,
Branching
Mapping of Instruction, Subroutines
Subroutines, Micro program Example, Design of Control Unit,
Unit
Microgram Sequencer
UNIT-V
Input-Output
Output & Memory Organiza
Organization : Peripheral Devices, Input-Output
Output Interface,
Interface Modes of
Transfer, Priority Interrupt, Daisy
Daisy-Chaining Priority, Parallel Priority Interrupt,
Interrupt Priority
Encoder, Interrupt Cycle, Direct Memory Access (DMA)
(DMA), Memory Hierarchy,
Hierarchy Main Memory,
Auxiliary Memory, Associative Memory
Memory, Cache Memory, Virtual Memory, Memory Management
Hardware.

TEXT &REFERENCE BOOKS

 Computer System Architecture Third Edition, by Mano M. Morris, Pearson Education

India, ISBN: 9788131700709, 9788131700709
 Digital Design by Mano M. Morris, Pearson Education India, ISBN: 9789353062019,
9789353062019
 Digital Logic & Computer Design by Mano M. Morris, Pearson Education India, , ISBN:
9788177584097, 9788177584097
 Computer Organization and Architecture by Basu P N, Vikas Publishing House
Hou Pvt Ltd,
ISBN: 9788125939917, 9788125939917
 Computer Organization & Architecture 10th Edition - Designing for Performance by
Stallings William, Pearson, ISBN: 9789332570405, 9789332570405
 Computer Architecture and Organization by Hayes John, Tata McGr
McGraw-Hill
Hill Education
India, ISBN: 9781259028564, 9781259028564
 Computer Organization by Hamacher V. Carl, McGraw
McGraw-Hill Education - Europe, ISBN:
9781259005275, 9781259005275

Page 17 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCACCE(C) - DISCRETE MATHEMATICS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 5 0 0 5 80 20 0 100

COURSE OBJECTIVES
 Understand Different Types of Discrete Structures
 Express a Logic Sentence in Terms of Predicates
Predicates, Quantifiers, and Logical Connectives
 Solve Problems Using the Principle of Inclusion
Inclusion-Exclusion.
 Understand Recursive Definitions;
COURSE OUTCOMES
 Apply the Operations of Sets and use Venn Diagrams to Solve Applied Problems.
 Analyze Properties of Algebraic Structures Such as Groups
Groups, Rings and Fields.
 Use and Analyze Recursive Definitions
 Understand, Explain and Apply the Basic Principles of Sets and Operations in Sets to Solve
the Problems
 Analyze Modern Problems in Computer Science and solve them Using Graphs and Trees.

UNIT-WISE SYLLABUS

UNIT-I
Set Theory: Introduction to Set Theory
Theory, Set Operations, Algebra of Sets, Duality,
Duality Finite and
Infinite Sets, Cartesian Product
Product, Relations, Representation of Relations, Types of Relation,
Relation
Equivalence Relations and Partitions
Partitions, Partial Ordering Relations and Lattices,, Function and its
Types, Composition of Function and Relations
UNIT- II
Graphs and Trees: Introduction to Graphs
Graphs, Directed and Undirected Graphs,
Graphs Homomorphic
and Isomorphic Graphs, Subgraphs
Subgraphs, Cut Points and Bridges, Multigraph and Weighted Graph,
Gra
Paths and Circuits, Shortest Path in Weighted Graphs
Graphs, Eurelian Path and Circuits,
Circuits Hamilton
Paths and Circuits, Planar Graphs
Graphs, Euler’s Formula, Graph Coloring, Trees,, Spanning Trees,
Binary Trees and its Traversals.
UNIT- III
Propositional Logic: Basic Operations: and(^)
and(^), Or(V), Not(~), Truth Value of a Compound
Statement, Propositions, Tautologies
Tautologies, Contradictions, Validity of Arguments,, Boolean Algebra
Group Theory: Definition and Examples of a Monoid Monoid, Semigroup, Groups and Rings,Rings
Homomorphism, Isomorphism ism and Automorphism
Automorphism, Subgroups and Normal Subgroups,
Subgroups Cyclic
Groups, Cosets, Lagrange’s Theorem.

Page 18 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT- IV
Definitions and Properties; Equivalence Relations and Equivalence Classes.Representations of
Relations by Binary Matrices and Digraphs; Operations o on
n Relations. Closure of a Relations;
Reflexive, Symmetric and Transitive Closures.
UNIT- V
Definitions and Properties of Recursion and Recurrence Relation: Linear Recurrence Relation
with Constant Coefficients, Homogeneous Solutions
Solutions, Particular Solutions, Total Solution of a
Recurrence Relation Using Generating Functions.

TEXT &REFERENCE BOOKS

 C.L Liu- Elements of Discrete Mathematics

Mathematics- McGraw Hill
 K.H.Rosen, Discrete Mathematics and Applications
Applications, Fifth Edition 2003, Tata Mcgraw Hill
 W.K.Grassmann and J.P.Trembnlay
J.P.Trembnlay, Logic and Discrete Mathematics, a Computer
Science
 Ronald Graham, Donald Knuth and Oren Patashik
Patashik- Concrete Mathematics: a Foundation
for Computer Science Ronald Graham
 Donald Knuth and Oren Patashik
Patashik- Concrete Mathematics: a Foundation for Computer
Co
Science-Addison-Wesley
 Judith L. Gersting -Mathematical
Mathematical Structures for Computer Science
Science, -Computer
Computer Science
Press.
 K. a. Ross, Ch. R. B. Wright
Wright, Discrete Mathematics, Prentice Hall Inc., 1992 (Or Pwn
Warszawa 1996).

Page 19 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCASEC(A) - LINUX SERVER ADMINISTRATION

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 1 0 4 3 0 10 40 50

COURSE OBJECTIVES
 Understand the fundamental
undamental concepts of Linux Server Administration
 Install and configure basic Linux services.
 Manage Users, Permissions, Folders, and Native Applications in Linux server.
 Manage the resources and security of a computer running Linux at a basic level
 Configure and manage simple networking services in Linux server.
 Creating and Maintaining E--Mail, FTP, and Web Servers.
COURSE OUTCOMES
 Explain the fundamental concepts of Linux Server Administration
 Install, configure and manage basic Linux services.
 Manage Users and their permissions, applications and service
servicess in Linux server.
 Manage the resources and security of a Linux server.
 Configure and manage basic networking services in Linux server.
 Install and configure E-Mail,
Mail, FTP, and Web Servers.

UNIT-WISE SYLLABUS

UNIT – I
Introduction, Understanding Linux Distr
Distributions, Installing Linux
Using Essential Tools - Logging in to Linux, Using the Seven Essential Linux Command Line
Tools (ls, cp, mv, rm, mkdir, cd, pwd) Getting Help with man, Finding Which man Page to Use,
Using pinfo, Using Other Systems for Getting HHelp
Working with the Bash Shell - Understanding the Shell and Other Core Linux Components,
Using I/O Redirection and Piping, Working with history, Using Command Line Completion,
Using Variables, Using Other Bash Features, Working with Bash Startup Files
Essential
ssential File Management Tools - Understanding the Linux File System Hierarchy, Listing
Files with ls, Using Wildcards, Copying Files with cp, Working with Directories, Using Absolute
and Relative Paths, Moving Files with mv, Removing Files with rm, Unders
Understanding
tanding Hard and
Symbolic Links, Managing Hard and Symbolic Links, Finding Files with find, Using Advanced
find Options, Archiving Files with tar, Managing File Compression
Working with Text Files - Understanding vi, Creating Text Files with vi, Browsing Text Files
with more and less, Using head and tail to See File Start and End, Displaying File Contents
with cat and tac, Working with grep, Understanding Regular Expressions, Using Regular
Expressions with grep, Using Common Text Processing Utilities

Page 20 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

Connecting to a Server - Understanding the Root User, Using su, Using sudo, Creating a
Simple sudo Configuration, Working on Linux from Graphical Interface or Command Line,
Using ssh to Connect to a Remote Server, Using ssh Keys
UNIT - II
User and Group Management ent - Understanding Users, Understanding File Ownership,
Creating Users with useradd, Creating Groups with groupadd, Managing User and Group
Properties, Configuring Defaults for New Users, Managing Password Properties, Understanding
User and Group Configuration
ation Files, Managing Current Sessions
Permissions Management - Understanding Basic Linux Permissions, Managing Basic Linux
Permissions, Understanding Advanced Linux Permissions, Managing Advanced Linux
Permissions, Managing umask
Managing Partitions - Understanding
derstanding Disk Storage and Devices, Understanding MBR and GPT
Partitions, Creating MBR Partitions, Creating MBR Extended and Logical Partitions, Managing
GPT Partitions, Working with SSD, Adding a Swap Partition, Understanding Encrypted
Partitions, Configuring
guring Encrypted Partitions
Managing File Systems and Mounts - Understanding Linux File Systems, Creating File
Systems, Mounting File Systems through /etc/fstab, Using File System Label and UUID,
Managing Systemd Mounts, Managing Systemd Automounts
Managing
ng the Boot Procedure - Understanding the Linux Boot Procedure, Shutting Down a
System, Configuring the GRUB2 Boot Loader, Troubleshooting Boot Issues, Working with a
Rescue Disk
UNIT – III
Managing Networking - Understanding IPv4 Basics, Understanding IPv
IPv66 Basics, Applying run-
run
time Network Configuration, Understanding Network Device Naming, Managing Host Names,
Managing Host Name Resolution, Using Common Network Tools
Managing Time - Understanding Linux Time, Managing Linux Time, Understanding the NTP
Protocol,
ocol, Configuring Time Synchronization
Working with Systemd - Understanding Systemd, Managing Systemd Services, Modifying
Service Configuration, Understanding Targets, Managing Targets
Process Management - Understanding Linux Processes and Jobs, Managing Interactive Shell
Jobs, Monitoring Processes with top, Changing top Display Properties, Monitoring Process
Properties with ps, Changing Process Priority, Managing Processes with kill
Managing Software - Installing
talling Software from Source Packages, Understanding Software
Packages, Managing Libraries, Understanding Repositories, Managing Packages with yum,
Managing Packages with apt, Using rpm
Scheduling Tasks - Understanding Linux Task Scheduling, Scheduling Ta
Tasks
sks with cron, Using
systemd Timers, Using at to Schedule Tasks
Reading Log Files - Understanding Linux Logging, Working with journalctl, Understanding
Rsyslog
UNIT – IV
An Introduction to Bash Shell Scripting - Understanding Bash Shell Scripts, Essential Shell
Script Components, Using Loops in Shell Scripts

Page 21 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

Managing Local Security - Using ulimit to Configure Resource Limitations, Configuring PAM,
Working with /etc/securetty, Managing Secure Mount Options
Configuring a Firewall - Understanding Linux Firew
Firewalling,
alling, Configuring a Firewall with
firewalld, Configuring a Firewall with ufw, Understanding iptables Basics, Configuring a
Firewall with iptables
Managing SELinux and AppArmor - Understanding the Need for Mandatory Access Control,
SELinux versus AppArmor,, Configuring AppArmor, Troubleshooting AppArmor, Configuring
SELinux Mode, Working with SELinux Labels, Managing SELinux Booleans, Troubleshooting
SELinux
Managing SSH Services - Configuring the SSH Service, Using SSH Public/Private Keys, Using
scp to Copy
y Files, Managing File Synchronization with rsync, SSH Port Forwarding
Managing Web Services - Configuring a Web Service, Managing Web Service Log Files,
Configuring Virtual Hosts, Restricting Access to a Web Page
Configuring FTP Services - Understanding FTP Solutions, Configuring a Basic FTP Server,
Working with sftp
UNIT - V
Configuring a Basic DNS Server - Understanding DNS, Configuring BIND, Configuring a
Caching DNS Server
Providing NFS and CIFS File Shares - Understanding Linux File Sharing Solutions, Solut
Configuring a Basic NFS Server, Persistently Mounting NFS Shares, Configuring a Basic Samba
Server, Mounting Samba Shares,
Configuring a Database Server - Understanding Linux Database Solutions, Installing
MariaDB, Creating a Simple Database
Configuring
ring Basic Email Handling - Understanding Email Handling, Configuring a Basic
Postfix Server, Configuring Dovecot as an IMAP Server
Configuring a Web Proxy - Understanding Web Proxies, Configuring a Basic Squid Proxy,
Restricting Access to the Squid Proxy
Working with Virtual Machines - Understanding Linux Virtualization Solutions, Creating a
KVM Virtual Machines, Managing KVM Virtual Machines

LINUX SERVER A
ADMIN PRACTICAL LAB

UNIT -I
Lab: Installing Linux
Lab: Using Essential Tools,
Lab: Working with the Bash Shell
Lab: Using Essential File Management Tools
Lab: Working with Text Files
Lab: Connecting to a Server
UNIT -II
Lab: Managing Users
Lab: Managing Permissions

Page 22 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

Lab: Managing Partitions

Lab: Managing File Systems
Lab: Managing the Boot Procedure
UNIT -III
Lab: Managing Networking
Lab: Managing Time
Lab: Working with Systemd
Lab: Managing Processes
Lab: Managing Software
Lab: Scheduling Tasks
Lab: Working with Logging
UNIT -IV
Lab: Writing Shell Scripts
Lab: Managing Security
Lab: Configuring a Firewall
Lab: Managing Mandatory Access Control
Lab: Configuring SSH
Lab: Managing Web Services
Lab: Configuring FTP Services
UNIT - V
Lab: Configuring DNS
Lab: Managing Remote File Shares
Lab: Configuring a Database Server
Lab: Configuring Email
Lab: Configuring a Proxy
Lab: Managing KVM Virtual Machines

TEXT & REFERENCE BOOKS

 Christopher Negus Fedora and Red Hat Enterprise Linux Bibile, Wiley India Ltd.
 Christopher Negus, Linux Bible, Wiley India Ltd
 Linux Administration, Kogent Learning Solutions Inc., ISBN 13
13- 9789350044209, ISBN
10-935004420x,
935004420x, Wiley India
 Linux Administration A Beginner’s Guide, Sixth Edition, Wale Soyinka, MC Graw Hill
 Linux: Powerful Server Administration by Jonathan Hobson, Oliver Pelz, and Uday R.
Sawant, Packt Publishing
 Forouzan-Unix
Unix & Shell Programming, Cengage Publications

Page 23 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCASEC(B) - PROGRAMMING WITH C++

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVES
 To Implement Object Oriented Programming.
 To Learn the Syntax and Semantics of the C++ Programming Language.
 To Learn how to Implement Copy Constructors and Class Member Functions.
 To Learn how to Overload Functions and Operators in C++.
 To Learn how Containment and Inheritance Promote Code Reuse in C++.
 To Learn how to Use Exception Handling in C++ Programs.
COURSE OUTCOMES
 Explain Concepts and Advantages of Object Oriented Programming.
 Apply and implement the concepts of the Object
Object-Oriented
Oriented paradigms to analyze,
analyze design and
developthe solutions of real world problems using the Principles of information Hiding,
Hiding
Localization and Modularity.
 Design, Development
nt and maintain the small applications
applications, system utility for societal and
academic problems using reusability concepts in team spirit.
 Demonstrate the Advanced Features of C++ Specifically Stream I/O
I/O,, Templates and
Operator Overloading and overriding
overriding.

UNIT-WISE SYLLABUS

UNIT-I
Overview of C++: Object Oriented Programming
Programming, Concepts, Advantages,, Usage, Program
Development Environment, C++ Language Standards
Standards, Introduction to Various C++ Compilers,
Compilers
C++ Standard Libraries, Main Function in C++ C++, Meaning of Empty
pty Argument List,
List Function
Prototyping, Default Arguments and Argument Matching
Matching, User Defined Data Types,
Types Classes &
Objects : Structure, Union & Classes
Classes, Inline Function, Scope Resolution Operator,
Operator Static Class
Members: Static Data Member
Member, Static Member Function, Passing Objects to Function,
Function
Returning Objects, Object Assignment
Assignment, Friend Function, Friend Classes.
UNIT-II
Array, Pointers References & the Dynamic Allocation Operators: Array of Objects,
Objects Pointers to
Object, Type Checking C++ Pointers
Pointers, This Pointer, Pointer to Derived Types,, Pointer to Class
Members, References: Reference Parameter
Parameter, Call by Reference and Return by Reference Passing
References to Objects, Returning Reference
Reference, Independent Reference, C++Dynamic Allocation
Operators, Initializing Allocated
cated Memory
Memory, Allocating Array, Allocating Objects.
Constructor & Destructor: Introduction
Introduction, Constructor, Access Specifiers for Constructors,
Constructors and
Instantiation, Parameterized Constructor
Constructor, Multiple Constructor in a Class, Constructor with
Default Argument, Copy Constructor
Constructor, Destructor.

Page 24 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT- III
Overloading as Polymorphism,, Function & Operator Overloading, Function Overloading,
Overloading
Overloading Constructor Function Finding the Address of an Overloaded Function,
Function Operator
Overloading: Creating a Member Operator Fu Function, Creating Prefix & Postfix Forms of the
Increment & Decrement Operation
Operation, Overloading the Shorthand Operation (I.E. +=, += -= etc.),
Operator Overloading Restrictions
Restrictions, Operator Overloading Using Friend Function,
Function Overloading
New & Delete, Overloading Som
Some Special Operators, Overloading [ ], ( ), -, Comma Operator,
Operator
Overloading << and >>, Namespaces: Global Namespace and Namespace Standard, Standard Nested
Namespaces.
UNIT- IV
Inheritance: Base Class Access Control
Control, Protected Base Class Inheritance, Single, Multiple &
Multilevel Inheritance, Inheriting Multiple Base Classes
Classes, Constructors,, Destructors &
Inheritance, When Constructor & Destructor Function are Executed
Executed, Passing Parameters to
Base Class Constructors, Granting Access
Access, Virtual Base Classes, Virtual Functions
Functio &
Polymorphism: Virtual Function
Function, Pure Virtual Functions, Early Vs. Late Binding.
Exception Handling: try, throw,, catch Sequence, Multiple Catch Blocks, Uncaught Exceptions,
Exceptions
Catch-All Exception Handler, Catching Multiple Exceptions,
s, Controlling uncaught Exceptions.
File Handling in C++: C++ I/O System Basics: C++ Streams
Streams, the Basic Stream Classes C++
Predefined Streams, File
ile operations in C++, Sequential & Random
Random-Access
Access file operations in C++
UNIT- V
Formatted I/O: Formatting Using the IOS Members, Setting the Formal Flags,, Clearing Format
Flags, an Overloaded Form of Setf()
Setf(), Using Width() Precision() and Fill(), Using Manipulators to
Format I/O, Creating Your Own Manipulators.
Class templates: Implementing a Class Template
Template, Implementing
nting Class Template Member
functions, Using a Class Template
Template, Function Templates, Implementing Function Templates,
Templates
Using Template Functions, Template Instantiation
Instantiation, Class Template Specialization,
Specialization Template
Class Partial Specialization, Template Function SpSpecialization, Template Parameters,
Parameters Static
Members and Variables, Templates and Friends
Friends, Templates and Multiple-file
file Projects,
Projects Overview
of Standard Template Library (STL)

TEXT &REFERENCE BOOKS

 Herbertz Shield, "C++ The Complete Reference "TMH Publication IS

ISBN 0--07-463880-7
 Ashok Kamthane , Object-Oriented
Oriented Programming with ANSI and Turbo C++,
C++ Pearson
India, ISBN: 9788131791448/9788131703830, 8131703835
 R. Subburaj, 'Object Oriented Programming WithC++Vikas Publishing House,
House New
Delhi.ISBN 81-259-1450-1 1
 E. Balgurusamy, "C++ '' TMH Publication ISBN O
O-07-462038-X
 M. Kumar 'Programming In C++'' TMH Publications
 R. Lafore, 'Object Oriented Programming C++"
 Ashok. N. Kamthane, "Object Oriented Programming WithANSI& Turbo C++",
C++" Pearson
Education Publication, ISBN
BN-8j-7808-772-3

Page 25 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

LIST OF PRACTICAL

1. Basic Programming
 Write a Program That Just Outputs `Hello
`Hello, World
 Write a Program to Find Maximum and Minimum of Given 3 Numbers.
 Write a Program That Output Value as Number and as Character.
 Implementation of the Funct
Function
ion That Calculates the Cross Sum of an Integer.(123 as
1+2+3).
 Determine Number of Characters in a String.
2. Function and Array
 Raising a Number N to a Power P is the Same as Multiplying N by Itself P Times. Write a
Function Called Power ( ) That Takes a D
Double
ouble Value for N and an INT Value for P,
P and
Returns the Result as Double Value. use a Default Argument of 2 for P,
P So That If This
Argument is Omitted, the Number Will Be Squared. Write a Main ( ) Function That Gets
Values from the User to Test This Func
Function.
 Write a C++ Program to Sort an Array of Integer in Ascending Order Using a Function
Called Exchange( ) Which Accepts Two Integer Arguments by Reference.
3. Write a C++ Program to Implement Function Overloading in Order to Compute.
4. Write a C++ Program to
o Implement Power(M
Power(M, N) Where
5. I) M is Double and N is Int II) M and N are Int.
6. Write a Program That Uses a Structure Called Point to Model a Point. Define Three Points,
Points
and Have the User Input Values to Two of Them. Then Set the Third Point Equal to the
Sum of the Other Two, and Display the Value of the New Point. Interaction with the
Program Might Look Like This:
Enter Coordinates for P1: 3 4
Enter Coordinates for P2: 5 7
Coordinates of P1 + P2 are: 8
8, 11
7. Create the Equivalent of a Four Function Cal
Calculator. Program Should Request the User to
Enter a Number, an Operator
Operator, and Another Number. It Should Then Carry Out the
Specified Arithmetical Operation: Adding
Adding, Subtracting, Multiplying, Or Dividing the Two
Numbers. (It Should use a Switch Statement to Select the Operation). Finally It Should
Display the Result. When It Finishes the Calculation
Calculation, the Program Should Ask If the User
Wantss to Do Another Calculation. Response Can Be Y Or N. Some Sample Interaction with
the Program Might Look Like This.
Enter First Number, Operator
Operator, Second Number: 10/ 3
Answer = 3.333333
Do Another (Y/ N)? Y
Enter First Number, Operator
Operator, Second Number 12 + 100
Answer = 112
Do Another (Y/ N) ? N
8. Create a 'Distance' Class with :
 Feet and Inches as Data Members
 Member Function
ion to Input Distance

Page 26 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

 Member Function to Output Distance

 Member Function to Add Two Distance Objects
 Write a Main Function to Create Objects of Distance Class. Input Two Distances
and Output the Sum.
9. Create a Class Called 'Time' That Has
 Three Integer Data Members for Hours
Hours, Minutes and Seconds
 Constructor to Initialize the Object to Zero
 Constructor to Initialize the Object to Some Constant Value
 Member Function to Add Two Time Objects
 Member Function to Display Time in Hh:Mm:Ss Format
 Write a Main Functio
Function to Create Two Time Objects, Add Them and Display the
Result in Hh:Mm:Ss Format.
10. Create a Class Called 'Employee' That Has
 Empcode and Empname as Data Members
 Member Function Getdata( ) to Input Data
 Member Function Display( ) to Output Data
 Write a Main Function to Create Emp
Emp, an Array of Employee Objects. Accept and
 Display the Details of At Least 6 Employees.
11. Create a Class Rational Which Represents a Numerical Value by Two Double Values-
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 Denomi
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.
12. Create a Class 'Complex' to Hold a Co
Complex
mplex Number. Write a Friend Function Toadd Two
Complex Numbers. Write a Main Function to Add Two Complex Objects.
13. Create a 'Matrix' Class of Size M X N. Overload the ‘+’ Operator to Add Twomatrix Objects.
Write a Main Function to Implement It.
14. Create a 'String'
tring' Class Which Overloads ‘ = = ' Operator to Compare Two Stringobjects.
15. Create a Base Class Called 'Shape' Having
 Two Data Members of Type Double.
 Member Function Get
Get-Data(( ) to Initialize Base Class Data Members.
 Pure Virtual Member Function Display-Area(( ) to Compute and Display the Area
ofthe Geometrical Object.
 Derive Two Specific Classes 'Triangle' and 'Rectangle' from the Base Class.
 Using These Three Classes Design a Program That Will Accept Dimension of a
Triangle/Rectangle Interactively and Dis
Display the Area.
16. Consider the Following Class Definition
Class Father {

Page 27 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

Protected :Int Age;

Public;
Father (Int X) {Age = X;}
Virtual Void Iam( )
{ Cout<< I Am the Father
Father, My Age is : << Age<< End1:}
};
 Derive the Two Classes Son and Daughter from the Above Class and for Each,
Each
Define Iam( ) to Write Our Similar But Appropriate Messages. You Should Also
Define Suitable Constructors for These Classes.
 Now, Write a Main ( ) That Creates Objects of the Three Classes and Then Calls Iam
( ) for Them. Declare
e Pointer to Father. Successively
Successively, Assign Addresses of Objects of
the Two Derived Classes to This Pointer and in Each Case
Case, Call Iam( ) Through the
Pointer to Demonstrate Polymorphism in Action.
17. Write a C++ Program That Displays the Size (in Bytes) of a G
Given
iven File. the Name ofthe File is
Specified as Command Line Argument.
18. Design Your own Manipulator to Provide the Following Output Specification Forprinting
Money Value:
a) 10 Columns Width
b) The Character '$' At the Beginning
c) Two Digits Precision
d) Filling of Unused
nused Spaces with ' * '
e) Trailing Zeros Shown
19. Write a program in C++ to Create a Function Template
20. Write a program in C++ to Create a Class Template

Page 28 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCASEC(C) - PROFESSIONAL COMMUNI

COMMUNICATION
CATION SKILLS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 1 0 3 40 10 0 50

COURSE OBJECTIVES:
 Improve Verbal and Non-Verbal
Verbal Communication Style
 Enhance Interpersonal Skills
Skills.
 Communicate Clearly and With Impact
 Develop Oral and Written Language Skills
 Develop Reading, Listening,, Speaking Skills,
COURSE OUTCOME:
 Explain and use Basic Concept of Communication
Communication.
 Demonstratethe Phonetic Capability in Communication
Communication.
 Indulge the Soft and Ethical Skills in Their Pers
Personality
 Participate inGroup Discussion
Discussion, Mock Interview, Group Presentation etc.
 Explain and use Leadership Skills
Skills, Time Management Skills, Public Speaking Skills,
Skills and
Situation Handling Skills to Solve the Societal Problem
Problem.

UNIT -WISE SYLLABUS

UNIT - I
Elements
lements of Communication : the Importance and Scope of Communication Through English at
the Present Time, the Process and Factors of Communication : Sender
Sender, Receiver,
Receiver Channel,
Code, Topic, Message, Context
Context, Feedback, ‘Noise’, Filters and Barriers.
Barriers Purpose of
Communication, Verbal and Non Verbal Communication
Communication.
UNIT - II
Sounds of English: Vowels, Diphthongs
Diphthongs, Consonants, Consonant Clusters, the International
Phonetic Alphabet (IPA) ; Phonemic Transcription
Transcription, Problem Sounds, Stress and Intonation
UNIT - III
Developing
veloping Reading and Writing Skills: the Importance of Developing Reading and Skills, Skills
Benefits of Effective Reading, the Importance of Writing Skills
Skills, the Differences Between Speech
and Writing, the Qualities of Effective Writing : Art of Condensation
Condensation, Writing
Wri Effective
Sentences, Developing Logical Paragraphs
Paragraphs, Précis, Essay, Drafting, Editing.
UNIT - IV
Soft Skills Practice and Ethical Skills:Personality Development
Development, Participating in Group
Discussion and Job Interviews, Time Management Presentation Skills
Skills, Leadership Skills,
Skills Public
Speaking, Extempore, Expressing Oneself in Various Situations Situations, the Illusion of
Communications, DangerofHalf Baked Ideas
Ideas, The Art of Explanation.

Page 29 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT - V
Self Presentation:Dress Code,, Business Card, Handshake, Telephone Etiquette, Etique Email
Etiquette, Dining Etiquette, office Etiquette
Etiquette, International Business Etiquette,
Etiquette Approaches to
Professional Writing, Writing a C C. V, Resume, Applications, Reports, Business and Social
Letters, Notices, Circulars and Memos
Memos.

REFERENCE BOOKS

 Practical English Usage, Michael Swan

Swan, Oxford
 English for Effective Communication
Communication, Sanjay Kumarand Pushplata, Oxford
 B. K. Das et al-An
An Introduction to Professional English and Soft Skills -Cambridge
Cambridge
University Press.
 Bovee et al Business Communication Today - ( Pearson)
 Meenakshi Raman and Prakash Singh
Singh-Business Communication - -(Oxford)
(Oxford)
 Brian Clegg - Crash Course in Personal Development - Kogan Page
 Adele B. LynnActivities for Developing Emotional Intelligence -(HRD Press)
 Edward De Bono -Lateral
Lateral Thinking -Penguin

Page 30 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCAOE(A) - MANAGEMENT INFORMATI

INFORMATION
ON SYSTEMS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 3 0 0 3 40 10 0 50

COURSE OBJECTIVES
 To understand the process of Management roles
roles, activities, planning and control
 To understand MIS feasibility study
 To explore approaches, techniques and methodologies to MIS development
 To understand Project management methodologies
 To understand the types of Files
Files, Data Bases and Information Processing Control
 Understand the input /output form design
COURSE OUTCOMES
 Able to define Management activities
activities, roles and levels
 Able to apply feasibility study to design any MIS software.
 Understand and define the relationships of MIS with other enterprise applications
 Explore Decision Making Process.
 Apply from design techniques in software user interface design
 Able to understand MIS projects and methodologies.

UNIT-WISE SYLLABUS

UNITI
Management activities, roles and levels, Management Planning and Control: how planning and
control systems interrelate, Strategic Planning within an organization, activities,
activities techniques
andResults, The nature of decision
decision-making: decision-making models and, classification of
decision-making situations, The nature of information
information, classifications and characteristics. The
nature of information and decision
decision-making
making at different management levels,
levels and the MIS
subtypes typically implemented at each level ofmanageme ofmanagement nt to support these
information/decision-making
making Requirements
Requirements, Management as the direct user of an MIS vs.
Intermediary use, Measurement of MIS performance and capabilities.
UNIT II
Logical Data Concepts, Types of Files
Files, Databases, Serial Access andDirect
irect Access
A devices.
Sequential, Hashed and indexed File Organization – Data Base Organization – single flat File –
Hierarchical, Network, Relational DB Structures. Transaction Processing – Control and
Retrieval.
ieval. Word and Text Processing
Processing. Document Filing Computer Graphics,
Graphics Composition
andReproduction, Document Distribution
Distribution, Facsimile Transmission, Message Systems,
Systems
InformationProcessing Control-- Availability Controls.The relationships of MIS to other
enterprise applications, such as Transaction Processing Systems ((TPS)TPS) and Enterprise
Resource Planning (ERP) systems Human ResourcesResources, Marketing &Sales,
&Sales Production,
Accounting & Finance, CustomerRelationships Management (CRM) (CRM), Product Supply Chain

Page 31 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

Management systems, The Internet and MIS provisions: Internet and the linkages
link to legacy
MIS, security issues.
UNIT III
MIS feasibility study, Assessment of economic
economic, Cost-Benefit
Benefit Analysis Overall approaches to
MIS development: Techniques and methodologies for supporting MIS development: Data
warehouse/BI systems development met
methodologies
hodologies and techniquesFact finding techniques (e.g.
SQIRO)
RO) Database design techniques, Decision Making Process – Problem Formulation,
Formulation
programmed vs s Non Programmed Decision
Decision, Criteria for Decision Making, Classical Economical
Model, Administrative Model,, Resolution of Conflict Uncertainty Avoidance,
Avoidance Problematic
Search, Incremental Decision Making
Making, Pay off Matrices, Decision Trees,, Games Theory,
Statistical Inference documenting and Communicating Decision rulesrules, Support for Decision
making phases.
UNIT IV
Management
anagement Reporting Systems (MRS)
(MRS), Decision Support Systems (DSS),, Group Decision
Support Systems (GDSS), Knowledge Based Systems that support management such as Expert
Systems (ES) and Neural Network (NN) systems
systems, The application of On-Line
On Analytical
Processing (OLAP)/Data, mining/Business Intelligence (BI) tools in supporting management,
management
decision making. Data warehouses and data mini
mining
ng facilities: the relationship between data
warehousing and other MIS facilities.
System Design: System design considerati
consideration, input/output design, forms design,
design file
organization and database, data management
management, file design, program design,
design control and
security.
UNIT V
Managing MIS projects:Project management methodologiesOO methodologies
methodologies,, Value Analysis,
The use of CASE tools to aid MIS development
development, The suitability of packages vs. bespoke systems
development, End-user
user development of MIS and its implications
implications, Outsourcing vs. insourcing of
MIS development and/or operational activities
activities, Developments in hardware, software,
software Internet
and communications capabilities and their implication for MIS MIS, Trends in management and
organisations, for example the possible movement towards flexible
flexible, virtual organisations and
the role of MIS may have in this scenario MIS and mobile computing
computing, MIS and nd social media

TEXT &REFERENCE BOOKS

 Gordon B. Davis And MaggretheH

MaggretheH.Olson, Management Information Systems,
Systems McGraw Hill
 International Edition.
 RoberG.Mudrick, Joel E. Ross And James RR.ClAGGET, Information
on Systems For Modern
Management, Prentice Hall Of India (P) Ltd., Eastern Economy Edition.
 Jerome Kanter Management Information Systems
Systems, Prentice Hall of India Ltd.
 Kenneth C. Laudon& Jane P. Laudon
Laudon, Essentials ofManagement Information Systems,
Systems
Tenth Edition, Pearson
on Prentice
Prentice-Hall.
 Terry Lucey, Management
nt Information Systems
Systems, Ninth Edition, Thompson
 McNurlin, Sprague & Bui, Information Systems Management in Practi
Practice,
ce, Prentice Hall.
Hall
 Efraim Turban, Jay Aronson & Tin
Tin-Peng Liang, Decision Support Systems and Intelligent
Systems, Ninth International E
Edition, Pearson Prentice- Hall.

Page 32 Dr. C.P.Agrawal

Master of Computer Applications (MCA) - 2020 Semester - I

Page 33 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCAOE(B) - ADVANCED EXCEL

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 To use of various Excel functions.
 To create pivot tables and charts.
 To validate and consolidate data.
 To protecting worksheets and workbooks.
 To Create, use, Edit, and Manage macros.
 To Import and export data.
COURSE OUTCOMES
 Explain and Apply Functions
Functions, Formulas, Chart, Macro, Filtering and Sorting of Data in
Excel.
 Protect data and carryout data analysis in Excel
 Create Summaries and Linkage in Excel
 Explain and Apply Data Consolidation Feature to Combine Data from Several Workbooks
into one
 Apply Goal Seek Analysis for EfficientDecisi
EfficientDecision Making

UNIT-WISE SYLLABUS

UNIT-I
Using Excel Shortcuts with Full List of Excel Shortcuts
Shortcuts, Copy, Cut, Paste, Hide,
Hide Unhide, Delete
and Link the Data in Rows, Columns and Sheets Sheets, Using Paste Special Options,
Options Formatting
Cells, Rows, Columns and Sheets
Sheets, Protecting & Un protecting Cells, Rows, Columns and Sheets
with or without, Password, Page Layout
Layout, Themes, Background and Printer Properties,
Properties Inserting
Pictures, Hyperlinks, Header/Footers
Header/Footers, Shapes and Other Objects in Worksheets
UNIT-II
Lookup and Reference
e Functions: VLOOKUP
VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH,
MATCH OFFSET,
TRANSPOSE etc., Logical Function: IF/ELSE
IF/ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc.,
etc.
Date and Time Functions: DATE
DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES,
MINUTES HOURS,
NOW, TODAY, MONTH, YEAR,, YEARFRAC, TIME, WEEKDAY, WORKDAY etc., etc. Information
Functions: CELL, ERROR.TYPE
ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN,
ISEVEN ISLOGICAL,
ISNA, ISNONTEXT, ISNUMBER,, ISREF, ISTEXT, TYPE etc.
UNIT-III
Math and Trigonometry Functions: RAND
RAND, ROUND, CEILING, FLOOR, INT, LCM,
LCM MOD, EVEN,
SUMIF, SUMIFS etc. Statistical Functions: AVEDEV
AVEDEV, AVERAGE, AVERAGEA,
AVERAGEA AVERAGEIF,
COUNT, COUNTA, COUNTBLANK
COUNTBLANK, COUNTIF, FORECAST, MAX, MAXA, MIN,, MINA, STDEVA

Page 34 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

etc Text Functions: LEFT, RIGHT

RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER,
PROPER REPLACE,
REPT, FIND, SEARCH, SUBSTITUTE
SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE,
CONCATENATE DOLLAR etc.
UNIT-IV
Using Conditional Formatting,, Using Conditional Formatting with Multiple Cell Rules,
Rules Using
Color Scales and Icon Sets in Conditional Formatting
Formatting, Creating New Rules and Managing
Existing Rules, Data Sorting and Filtering
Filtering, Sorting Data by Values, Colors, etc. Using Filters to
Sort Data, Advance Filtering Options
Options, Database Functions: DGET, DMAX, DMIN, DMIN DPRODUCT,
DSTDEV, DSTDEVP, DSUM, DVAR DVAR, DVARP etc, Financial function PV, FV etc.
UNIT-V
Pivot Tables, Creating Pivot Tables
Tables, Using Pivot Table Options, Changing and Updating Data
Range, Formatting Pivot Table and Making Dynamic Pivot Tables
Tables, Creating Pivot Charts,
Charts Types
of Pivot Charts and Their Usage Formatting Pivot Charts and Making Dynamic Pivot Charts,
Charts
VBA Macro, Introduction to VBA MacroMacro, Recording Macro & Understanding Code Behind,
Behind
Editing

TEXT &REFERENCE BOOKS

 Microsoft Excel 2013 Bible by John Walkenbach

Walkenbach, Wiley publication
 Excel 2013 Pivot Table Data Crunching by Bill Jelen
Jelen, Pearson publication
 Excel Functions and Formulas by Bernd Held
Held, BPB publication

Page 35 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

1MCAOE(C) - MULTIMEDIA SYSTEMS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 To
o provide students with a basic understanding of multimedia systems and its components.
components
 To understand multimediainformation representation and multimedia standards in the
components of multimedia – Text, audio, image, video and animation.
 To gain knowledge about the standards tools and techniques used in development of
multimedia components for productions
 To create simple multimedia applications and products for using standalone, networked or
web based computers.
COURSE OUTCOMES
 Define multimedia and its components
 Acquire skill to create various multimedia components
 Create simple multimedia product that include all components
 Use standards software tools to develop multimedia components and integrate all
components as per the requirement
quirement

UNIT-WISE SYLLABUS

UNIT-I
Introduction to Multimedia, Identifying Multimedia Elements Text
Text, Images, Sound,
Sound Video and
Animation, Multimedia Applications in Education
Education, Entertainment. Advertising world & Media
industry etc.
Text - Concepts of Plain & Formatted Text Text, RTF & HTML Texts, Using Common Text
Preparation Tools, Conversion to and from of Various Text Formats
Formats, Using Standard Software,
Software
Object Linking and Embedding Concept
Concept, Fonts – Various types and uses.
UNIT-II
Sound - Sound and its Attributes
Attributes, Sound and its Effects in Multimedia, Representation of
Analog Signals, A/D: Sampling and quantization
quantization, Frequency, Sound Depth, Channels and its
Effects on Quality and Storage, Size Estimation of Space of a Sound File
File, Sound Card Standard
– FM Synthesis Cards, Introduction to MP3, WMA, WAV, MIDI etc. Audio file formats,formats 3D
Sounds, Recording and Editing Sound Using Sound Editors like Audacity
Audacity, Sound Forge etc.
Graphics- Importance of Images/graphics in Multimedia
Multimedia, Vector and Raster Graphics,
Graphics Regular
Graphicss Vs. Interlaced Graphics
Graphics, Image Capturing Methods - Scanner, Digital Camera etc.
Color Models-RGB, CYMK, HUE,, Saturation, and Brightness, Various Attributes of Images Size,
Size
Color, Depth etc, Various Image File Format BMP
BMP, TIFF, GIF, PNG and JPEG Format Their Th
Features and Limitations, Image Format Conversion
Conversion, Various Effects on Images. Create Images
Ima
Using Photoshop, CorelDrawor or other Open Source software
software, Apply Various Effects,
Effects Using
Layers, Channels and Masks in Images.

Page 36 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

UNIT-III
Video- frame rate and resolution
resolution, interlaced and non-interlaced video, colour planes (YCBCR,
(YCBCR
YUV), Video broadcast standards (PAL
(PAL, NTSC, SECAM), HD Video, 3D TV, Video representation:
AVI, MPEG, Quick Time, real video (.rm)
(.rm), Video Editing and Movie Making Tools,
Tools Converting
Formats of Videos, Recording and Editing Videos Using Video Editing Software Like Adobe
Premiere / Sony Vegas or Open Source software.
UNIT-IV
Animation and its Basic – Principals of Animation and its use in Multimedia
Multimedia, Computer System
Configuration and Peripherals
erals Requirements
Requirements, Software for Animation, Effects of Resolution,
Resolution
Pixel Depth, Image Size, on Quality and Storage
Storage, Types of Animation and Applications.
Introduction to Compression Technology - Concept of lossy and lossless compression, Concept
of rate-distortion
tortion characteristics
characteristics, Basics image compression (JPEG, JPEG 2000),
2000) Basics of
Audio compression (MP3, MP4),, Basics of Video Compression (MPEG, H.264)
UNIT-V
Multimedia Application Design - Content design, technical design, visual design,
design design
metaphors, example studies, interactivity.
Authoring Tools for Multimedia – Introduction to Various Types of Multimedia Authoring
systems, uses of an authoring system
system, Definition and function of Authoring Metaphor,
Metaphor Different
Metaphors, CD/DVD Based and Web Based T Tools, Features and Limitations,
Limitations Creating
Multimedia Package using
sing All Components.

TEXT &REFERENCE BOOKS

 Tay Vaughan-Multimedia:
Multimedia: Making It Work
Work, Tata Mc-Graw Hill.
 Ramesh Bangia-Introduction
Introduction to Multimedia
Multimedia- Laxmi Publications Pvt. Ltd.
 Satish Jain, Shashi Singh, Introduction To Multimedia - Based On Nielit O Level Syllabus
For Mat-O2.R0
O2.R0 1st Edition, , BPB Publications, ISBN: 9788183335355, 8183335357

Page 37 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

BRIDGE COURSE
DETAILED SYLLABUS

 For Those Students Who Have Passed Their Graduation Exam Without
Computer
omputer Subjects Specialization.

 This Course Of 100 Marks (80 Theory + 20 Internal) Must Be Passed With
MCA First Semester Examination.

UNIT – I
 Brief history of development of computers
 Computer system concepts
 Computer system characteristics
 Capabilities and limitations
 Types of computers Generations of computers
 Basic components of a computer system - Control unit, ALU, Input / Output functions and
characteristics
 Memory - RAM, ROM, EPROM, PROM and other types of memory
 Personal Computer (PCs) – evolution of PCs
 Configurations of PCs- Pentium and Newer, PCs specifications and main characteristics.
 Various Input / Output & Storage Units
 Storage fundamentals - Primary V/s Secondary Data Storage
 Data Retrieval methods - Sequential, Direct and Index Sequential
UNIT – II
 Software and its Need
 Types of Software - System software, Application software, System Software - Operating
System, Utility Program,
 Programming languages - Machine, Assembly, High Level, 4GL, their merits and demerits
 Assemblers, Compilers
ompilers and Interpreter, Single Pass & Multiple Pass Compiler
 Introduction to Operating System for PCs - DOS Windows, Linux, Macintosh
 Operating systems for mobile Devices - Symbian, Android, iMac etc.
 Application Software and its types - Word-processing, Spreadsheet, Presentation Graphics,
Database Management Software - characteristics, Uses, examples and area of applications
UNIT-III
 Algorithms Need, & Development Process, Flow Chart, Types of Flow Chart.
 Programming Methodologies - Procedural Programming, Object-oriented
oriented Programming,
Functional Programming, Logical Programming
 Top-down & Bottom-up
up approaches of software development
 Keywords, Constant & Variables
 Data Types - Integer, Float, Single, Double etc., Type Conversion
 Scope of variables - Locall & Global,
 Expression

Page 38 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - I

 Operators - Arithmetic, Logical, Relational, Conditional and Bit Wise Operators, Precedence
and Associativity of Operators.
 Array - Single & Multi-dimension,
dimension,
 Types of Statements - Iteration, Branching, Looping, Conditional. Exam
Examples
ples & Uses,
 Functions - Library & User defined,
UNIT- IV
 Introduction to Databases, Flat File Vs Database, Significance of Databases
 Types of Database Models - Hierarchical Data Model, Network Data Model, The Relational
Data Model, Advantages and Disadvantages of different Database Management systems,
Comparison between DBMS, RDBMS,
 Conceptual Design, Mapping Relational Mode
 Distributed and Centralized DB
 Database System Applications,
 Business Requirements Databases and Data Modeling
 Conceptual and Physical Data Models
 Entities and Attributes - Unique Identifiers
 Relationships
 Entity Relationship Modeling (ERDs)
 Relational Databases- Integrity Constraints, Functional Dependency, Multi
Multi-valued
Dependency
 Convert a Logical Model to a Relational Model Mapping to the Physical Model
 Mapping Entities and Attributes
 Primary, Secondary and Foreign Keys and their mapping
 Normalization of databases
 Data Definition Language (DDL)
 Data Manipulation Language (DML)
UNIT-V
 Data and Information – Types of informati
information,
on, requirements of information at different levels
of management, qualities of information.
 Software Development Life Cycle (SDLC) - Defining the Problem, Designing, Coding, Testing
and Debugging, Documenting, Deploying and Maintaining.
 Requirements determination
rmination – requirements specifications – feasibility analysis – final
specifications – hardware and software study –system design – system implementation –
system evaluation – system modification. Role of systems analyst – attributes of a systems
analyst – tools used in system analysis.
 Information gathering – strategies – methods – case study – documenting study – system
requirements specification.
 tools for prototype creation, data flow diagrams - leveling of DFDs – leveling rules – logical
and physical DFDs – software tools to create DFDs.
 Data input methods – coding techniques – requirements of coding schemes – error
detection of codes – validating input data – input data controls interactive data input.
 Designing outputs – output devices – designing output reports – screen design – graphical
user interfaces – interactive I/O on terminals.

Page 39 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

SEMESTER – II
2MCACCC2 - DATA MINING AND BUSI
BUSINESS
NESS INTELLIGENCE

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 4 1 0 5 80 20 0 100

COURSE OBJECTIVES
 Introduce the Basic Concepts of Data Base
Base, Data Warehouse and Data Mining
 Understand the Concept of Knowledge Discovery
 Understand the process of deriving Information from data with Different Perspectives
 Understand and apply Preprocessing Methods on Raw Data
 Discover Interesting and Useful Patterns and associations
associations, Analyze Supervised and
Unsupervised Models
 UnderstandBusiness
erstandBusiness Intelligence Life Cycle andTechniques Used in It
COURSE OUTCOMES
 Demonstrate an Understanding and knowledge of theData Warehousing
Warehousing, Data Mining and
Business Intelligence
 Explain the Data Analysis and Knowledge Delivery Stages.
 Organize and Prepare the Data Needed for Data Mining Using Pre Preprocessing Techniques
 Implement the Appropriate Data Mining Methods Like Association,
Association Classification,
Clustering
 Apply Data Mining Methods to Solve Practical Problems.(Analyze the Problem Domain,
Domain Data
Collection, Preprocessing, Apply Suitable Data Mining Method
Method, Interpret and Visualize the
Results and Provide Decision Support.)

UNIT-WISE SYLLABUS

UNIT-I
Data Ware Housing Definition,, Usage and Trends, DBMS Vs. Data Warehouse,
Warehouse Data Marts,
Metadata, Data Mining Definition & Application
Application, DBMS Vs. Data Mining, KDD Versus Data
Mining, Data Mining Techniques
Techniques, Business Intelligence Introduction, Cycle of a Business
Intelligence AnalysisData Preprocessing: Need
Need, Data Cleaning, Integration & Transformation
UNIT-II
Data Warehouse Process & Architecture
Architecture, OLAP and OLTP Definitions, Difference Between OLAP
and OLTP, Dimensional Analysis
Analysis, Multidimensional Data Mode, Data Cubes,, Drill-Down and
Roll-Up – Slice and Dice or Rotation
Rotation, Operations, Types of OLAP, ROLAP Vs. MOLAP,
MO Schemas
for Multidimensional Database: Stars
Stars, Snowflakes and Fact Constellations
Relation between BI and DW DW, the Business Intelligence User Types, Standard Reports,
Reports
Interactive Analysis and Ad Hoc Querying
Querying, Parameterized Reports and Self-Service
Service Reporting,
Repor
Dimensional Analysis, Alerts/Notifications
Alerts/Notifications, Visualization: Charts, Graphs, Widgets,
Widgets Scorecards
and Dashboards

Page 40 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

UNIT-III
Association Rule Mining, Single
Single-Dimensional
Dimensional Boolean Association Rules Apoiri Algorithm,
Algorithm FP
Growth, Multi-Level
Level Association Rules ffrom Transaction Databases
UNIT-IV
Classification and Prediction, Concepts of Decision Tree Induction and Bayesian Classification,
Classification
Cluster Analysis, Categorization of Methods
Methods, Partitioning Methods, K-Means
Means Algorithm,
Algorithm Outlier
Analysis, Hierarchical Methods
UNIT-V
Emerging Technologies - Machine Learning
Learning, Big Data: Introduction, Importance,
Importance Four Vs
Data Mining for Business Applications Like Fraud Detection
Detection, Market Segmentation,
Segmentation Retail
Industry, Telecommunications Industry
Industry, Banking & Finance and CRMetc.,
Spatial Databases, Multimedia Databases
Databases, Time Series and Sequence Data,, Text Databases,
Web Mining Concepts.

TEXT &REFERENCE BOOKS

 Jiawei Han, Michelinekamber, “Data Mining Concepts and Techniques”, Morgan

Kaufmann Publishers
 Arun K Pujari, “Data Mining Concepts and Techniques”, University Press
 G.K.Gupta, “Data Mining with Case Studies”, PHILtd

Page 41 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCACCC2 - WEB TECHNOLOGIES

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 2 0 6 5 50 20 30 100

COURSE OBJECTIVES
 Learn to Design and Develop a Web Page
 Design and Develop a Web Site Using Text
Text, Images, Links, Lists, and Tables for Navigation
and Layout.
 Style Your Page Using CSS, Internal Style Sheets
Sheets, and External Style Sheets.
 Learn to use JavaScript & XML in Web Design.
 Learn How to use Database in Web Design.
COURSE OUTCOME
 Describe the Concepts of WWW Including Browser and HTTP Protocol.
 List the Various HTML Tags and usethem to develop the user friendly web Pages.
 Define the CSSwithits Types and usethemtoprovide the Styles to the web pages at Various
Levels.
 Develop the Modern Web Pages Using the HTML and CSS Features with Different Layouts
as per Need of Applications.
 Use the JavaScript to Develop the Dynamic Web Pages.
 Use Server Side Scripting with PHP to Generate the Web Pages Dynamically Using the
Database Connectivity.
 Develop the Modern Web Applications Using the Client and Server Side Technologies and
the Web Design Fundamentals.

UNIT-WISE SYLLABUS

UNIT-I
Introduction to Web, Web Designing and Website Planning
Planning: Concept of WWW,
WWW Internet and
WWW, HTTP Protocol: Request and Response
Response, Web Browser and Web Servers, Website Hosting-
Hosting
Free vs. Paid, Linux Vs. Windows Hosting
Hosting, Concepts &use of Database & Mail Servers
Server
Associated with Web Sites, Features of Web 2.0Concepts of Effective Web Design,
Design Web Design
Issues Including Browser, Bandwidth and CacheCache, Display Resolution, Look and Feel of the
Website, Page Layout and Linking
Linking, User Centric Design, Sitemap, Planning and
an Publishing
Website, Designing
esigning Effective Navigation, Website Hosting Issues, FTP.
UNIT-II
Web Development withHTML: Basics of HTML HTML, Formatting and Fonts, Commenting Code,
Code
Color, Hyperlink, Lists, Tables,, Images, Forms, Meta Tags, Character Entities,
Entities Frames and
Frame Sets, Browser Architecture and Web Site Structure
Structure, use of HTML Code Editor &
WYSIWYG Editor.
Cascading Style Sheets (CSS): Style Sheets
Sheets: Need, Introduction, Basic Syntax and Structure,
Using CSS- Background Images
Images, Colors and Properties, Manipulating
lating Texts,
Texts Using Fonts,

Page 42 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Borders and Boxes, Margins,, Padding Lists, Positioning Using CSS, CSS2,
CSS2 Overview and
Features of CSS3
UNIT-III
Technologies for Web Applications JavaScript
JavaScript& XML: JavaScript:: Client Side Scripting
withJavaScript, Variables, Functions
Functions, Conditions, Loops and Repetition,, Pop Up Boxes,
JavaScript Objects, the Dom and Web Browser Environments
Environments, Manipulation Using Dom,
Dom Forms
and Validations, DHTML:: Combining HTML
HTML, CSS and JavaScript, Events and Buttons.
XML: Introduction of XML, Validationof
lidationof XML Documents
Documents, Ways to useXML, XML for Data Files,
Files
HTML vs.XML, Embedding XMLinto HTML Documents
Documents, Converting XML to HTML for Display,
Display
Displaying XML Using CSS and XSLXSL, Rewriting HTMLas XML, Relationship Between HTML,
HTML
SGML and XML, Web Personaliz
Personalization, Semantic Web, Semantic Web Services. Transforming
XML Using XSL and XSLT
UNIT-IV
Web Design with PHP: Introduction and Basic Syntax of PHP PHP, Decision and Looping with
Examples, PHP and HTML, Arrays
Arrays, Functions, Browser Control and Detection,
Detection String, Form
Processing, Files, Cookies and Sessions
Sessions, Object Oriented Programming with PHP
UNIT-V
Introduction to Database Driven Websites withPHP
withPHP, PHP and MYSQL, Basic Commands with
PHP Examples, Connection to Server
Server, Creating Database, Selecting a Database,
Database Listing
Database, Listing Table Names
Names, Creating a Table, Inserting Data, Altering Tables,
Tables Queries,
Deleting Database, Deleting
eting Data and Tables

TEXT &REFERENCE BOOKS

 Roger S.Pressman, David Lowe

Lowe, “Web Engineering”, Tata McGraw Hill Publication,
Publication 2007
 Achyut S Godbole and AtulKahate
AtulKahate, “Web Technologies”, Tata McGraw Hill
 Gopalan N P, Akilandeswari “Web Technology: a Developer S Perspective”,
Perspective” PHI
 Chris Bates Web Programming
Programming: Building Internet Applications Wiley
 Refter, Fawset- Beginning XML, Wiley India
 H.M. Deitel, P.J. Deitel, a.B. Goldberg
Goldberg-Internet
Internet & World Wide Web How to Program,
Program
Pearson Education, 3rd Edition
Edition,
 C. Xavier, “Web Technology &Design”
&Design”, Tata McGraw Hill.
 Ivan Bay Ross, “HTML, DHTML
DHTML, JavaScript, Perl CGI”, BPB.
 Developing Web Applications
Applications, Ralph Moseley and M. T. Savaliya, Wiley-India
India
 Web Technologies, Black Book
Book, Dreamtech Press
 HTML 5, Black Book, Dreamtech Press
 Joel Sklar-Web Design, , Cengage Learning
 Harwani-Developing
Developing Web Applications in PHP and Ajax
Ajax, Mcgrawhill

LIST OF OPEN SOURCE SOFT

SOFTWARE/LEARNING WEBSITE

 Browsers Like IE, Mozilla, Firefox Etc.

 Server Software Xampp/Wamp/Lamp

Page 43 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

 www.apachefriends.org
 www.w3.org
 www.w3schools.com
 www.php.net
 www.mysql.com
 www.phpmyadmin.net

LIST OF PRACTICAL

1. Write an HTML page with Javascript that takes a number from one text field in the range 0- 0
999 and display it in other text field in words.If the number is out of range,
range it should show
“out of range” and if it is not a number
number, it should show “not a number” message in the
result box.
2. Develop static pages (using only HTML) of an online Book store.
The pages should resemble: www.amazon.com. The website should consist the following
pages.
 Home page
 Registration and user Login
 User profile page
 Books catalog
 Shopping cart
 Payment by credit card Order Conformation
3. Write an HTML page that has one inputinput, which can take multi-line
line text and a submit
button. Once the user clicks the submit button
button, it should show the number of characters,
characters
lines and words in the text entered using an alert message.Words are separated with white
space and lines are separated with new line character.
4. Write an HTML page that contains a selection box with a list of 5 countries.
countries In this page
when the user selects a country
country, its capital should be printed next to the list,
list and add CSS
to customize the properties of the font of the capital.
5. Create an XML document that contains 10 users information. Write a script which takes
user id as input and returns the user details by taking the user information from XML
document.
6. Implement a userer validation web application
application, where user submits the login name and
password to server. These are checked against the data already available in database and if
the data matches a successful
ccessful login page is returned o
otherwise
therwise a failure message is shown
to the user.
7. A simple calculator web application that takes 2 numbers and an operator (+,
(+ -, *, /, %)
from an HTML page and returns the result page with the operation performed on the
operands.
8. A web application shows a start time at the right top corner of the page and takes a name
as inputand provides the logout button at bottom. Onn clicking logout button it should show
sho
a logout page with thank you message with the duration of Usage.

Page 44 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

9. A web application that takes name and age from an HTML page. If the age is less
le than 18, it
should send a page with “hello, and You are not authorized to visit this site” otherwise it
should send “You are welcome to this site” message.
10. Write a web application in which tthe
he user is first served a login page which
whic takes users
name and password.After
.After submitting the details the server checks these values against the
data from a database and takes the following decisions if name and password matches,
matches
serves a welcome page with user's full name
name.Iff name matches and password doesn't match
then
en serves password mismatch page
page.If name not found in database, serves a registration
page where users full name is asked and on submitting the full namename, it storesthe login
name, password and full name in the databa
database.
11. A web application that lists all coo
cookies
kies stored in thebrowser on clicking “list cookies”
button, add cookies if necessary

Page 45 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCACCE(A) - DATA STRUCTURES AND ALGORITHMS

ALGORITHM

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 4 0 2 5 80 20 0 100

COURSE OBJECTIVES
 Learn Basic Data Structures such as
as, Linked Lists, Stacks and Queues, Tree and Graph.
 Learn Algorithm for Solving Problems Like Sorting
Sorting, Searching, Insertion and Deletion of
Data
 Understand the Complexity of Various Algorithms.
 Introduce Various Techniques for Representation of the Data in in Memory.
COURSE OUTCOMES
 Understand and Explain Basic Data Structures Such as
as, Linked Lists, Stacks and Queues,
Queues
Tree and Graph.
 Selectand Apply Appropriate Data Structures to define the particular Problem statement.
 Implement Operations Like Searching/Sorting
Searching/Sorting, Insertion, and Deletion, Traversing on
Various Data Structures.
 Determine and Analyze the Complexity of GivenAlgorithms

UNIT-WISE SYLLABUS

UNIT-I
Algorithm Analysis and Complexity
Complexity, Data Structure- Definition, Types of Data Structures
Recursion: Definition, Linear and Binary Recursion
Recursion, Searching Techniques,, Linear Search,
Binary Search.
UNIT- II
Sorting Techniques: Basic Conc
Concepts, Sorting Algorithms: Insertion (Insertion Sort),
Sort) Selection
(Heap Sort), Exchange (Bubble Sort
Sort, Quick Sort), Distribution (Radix Sort) and Merging (Merge
Sort) Algorithms.
UNIT- III
Stacks and Queues: Stacks: Basic Stack Operations
Operations, Representation of a Stack Using Arrays,
Arrays
Stack Applications: Reversing List
List, Factorial Calculation, Infix to Postfix Transformation,
Transformation
Evaluating Arithmetic Expressions.
Queues: Basic Queue Operations
Operations, Representation of a Queue Using Array,, Implementation
ofQueue Operations Using Stack.Circular Queues
Queues, Priority Queues. Applications of Queues-
Queues
Round Robin Algorithm,
UNIT- IV
Linked Lists: Introduction, Single Linked List
List, Representation of a Linked List in Memory,
Memory
Operations on a Single Linked List
List, Circular Linked List, Double Linked List,, Advantages and
Disadvantages of Linked List.

Page 46 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

UNIT- V
Trees: Terms Related to Tree,, Binary Tree, Binary Tree Traversals, Creation of Binary Tree
fromIn-order, Pre-order
order and Post
Post-Order Traversals, Threaded BinaryTrees, Binary Search Tree,
Tree
BST Operations: Insertion, Deletion.
Graphs: Basic Concepts, Representations of Graphs: Using Linked List and Adjacency Matrix,
Matrix
Graph Algorithms.Graph Traversals (BFS & DFS)DFS), App1ications: Dijkstra’s Shortest Path,
Path
Minimum Spanning Tree Using Prim’s Algorith
Algorithm, Warshall’s Algorithm

TEXT &REFERENCE BOOKS

 R. S. Salaria- Data Structures and Algorithm

Algorithm-Khanna Publishing
 G. A. V. Pai,, Data Structures and Algorithms
Algorithms- TMH
 Debasis, Sarnanta- Classic Data Structures- PHI, 2009
 E.Horowitz, Sartaj Sahni and Susan A
Anderson, W. H. Freeman -Fundamentals
Fundamentals of Data
Structures in C
 Schaum's Series- Introduction of Data Structure
Structure-Prentice Hall of India

LIST OF PRACTICAL

1. Program to Maintain a Linked List.

2. Program to Add a New Node to the Ascending Order Linked List.
3. Program to Maintain a Doubly Linked List.
4. Program to Implement Stack as an Array.
5. Program to Implement Stack as a Linked List.
6. Program
rogram to convert an expression from Infix Form to Postfix Form.
7. Program to Evaluate an Expression Entered in Postfix Form.
8. Program to Implement Non-Recursive
Recursive Function for Factorial of a Number.
9. Program to Implement Recursive Function for Factorial of a Number.
10. Program to Implement a Queue as an Array.
11. Program to Implement a Queue as a Linked List.
12. Program to Implement a Circular Queue as a
an Array.
13. Program to Implement a Circular Queue as a Linked List.
14. Program to Implement a Dequeue Using an Array.
15. Program to Implement Linear Search in an Unsorted Array.
16. Program to Implement Binary Search in a Sorted Array.
17. Program to Implement Selection So
Sort.
18. Program to Implement Insertion
sertion Sort
Sort.
19. Program to Implement Bubble Sort.

Page 47 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

20. Program to Implement Quick Sort.

2MCACCE(B) - COMPUTER NETWORKS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 4 1 0 5 80 20 0 100

COURSE OBJECTIVES
 Build an understanding of the Fundamental Concepts of Computer Networking.
 Familiarize with the Taxonomy and Terminology of the Computer Networking Area.
 Introduce about various Networking Devices.
 Introduce about concept of Routing in networking.
 Preparing the Student for Entry Advanced Courses in Computer Networking.
COURSE OUTCOME
 Demonstrate the Basic Concepts of Networking, Networking Principles, Routing Algorithms,
IP Addressing, and Working of Networking Devices.
 Demonstrate the Significance, Purpose, and application of Networking Protocols and
Standards.
 Describe, compare, and contrast LAN, WAN, MAN, Intranet, Internet, AM, FM, PM, and
Various Switching Techniques.
 Explain the working of Layers
yers and apply the various protocols of the OSI & TCP/IP model.
 Analyze the Requirements for a Given Organizational Structure and Select the Most
Appropriate Networking Architecture and Technologies.
 Design the Network Diagram and Solve the Networking Pr
Problems
oblems of the Organizations with
Consideration of Human and Environment.
 Install and Configure Networking Devices.

UNIT-WISE SYLLABUS

UNIT-I
Introduction to Computer Networks
Networks, Types of Network - LAN, WAN, MAN, Internet,
Internet Network
Topologies, Transmission Media
Media, Communication Mode- Simplex, Half Duplex,
Duplex Full Duplex
Analog& Digital Signals, Base Band
Band, Broad Band, Error Detection and Correction,
Correction OSI Model:-
Functions of Each Layer, Services and Protocols
Protocols, Inter-Networking Devices,, Hub, Repeater,
Bridge, Switch, Modem, Routers Gateways.
UNIT- II
Multiplexing Multiplexer FDM,, TDM Statistical Multiplexing, Modulation AM, AM FM, PM,
Switching Technique, Message Switching
Switching, Circuit Switching, Packet Switching,
Switching Virtual Circuit,
IEEE Standards, 802.3, 802.4, 802.5. Fast Ethernet, FDDI Token Ring.
UNIT- III

Page 48 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Routing Algorithm:-Shortest
Shortest Path Routing
Routing, Distance Vector Routing, Unicast Routing,
Routing Multicast
Routing, Link State Routing, Broadcast Routing
Routing, Congestion Control, Traffic Shaping. TCP/IP:
Introduction, History of TCP/IP,, Architecture, Layers of TCP/IP, Comparison Between OSI and
TCP/IP Models, Transmission Control Protocol
Protocol, User Datagram Protocol, Internet Protocol
IPAddressing, IP Addressing Classes
Classes, Internet Protocols – IP Packet, ARP, RARP,
RARP ICMP,
UNIT- IV
Various Protocol, HTTP, Telnet,, FTP, SMTP, Mine, UDP, URL (Uniform Resource Locater),
Locater) ISDN
Channel, ISDN Services, Base Band ISDN ISDN, Broadband ISDN, Network Security:
Security Network
Security Issues, Firewalls – Need and Features of Firewalls
Firewalls, Types of Firewall Technology-
Technology
Network Level and Application Level
Level, IP Packets Filter Screening Routers,
Routers Limitations of
Firewalls.
UNIT- V
Introduction to Wireless Network
Network, Fundamentals of Cellular Systems, Mobile Ad-Hoc
Ad and
Sensor Networks, Wireless PAN/LAN/MAN
PAN/LAN/MAN, Multi-Path Propagation, Path Loss,
Loss Slow Fading,
Fast Fading, Frequency Reuse, Cell Splitting
Splitting, Cell Sectoring.

TEXT &REFERENCE BOOKS

 Andrew S.Tanenbaum -Computer

Computer Networks, Pearson Publishers
 Behrouza Forouzan- Data Communications and Networking -Global
 William a Shay - Understanding
nding Data Communications and Networks -Course
Course Technology
Inc
 Prakash C. Gupta -Data
Data Communications and Computer Networks, PHI
 William Stallings- Data and Computer Communications, Pearson Education India
 Larry L. Peterson and Bruce S. Davie, -Computer Networks – A Systems Approach,
 Morgan Kaufmann Publishers
 Thomas D. Nadeau & Ken Gray
Gray-Software
Software Defined Networks, O’reilly Publishers
 http://nptel.ac.in/video.php?subjectid=106105081

Page 49 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCACCE(C) - COMPUTER GRAPHICS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 4 1 0 5 80 20 0 100

COURSE OBJECTIVES
 Introduce Computer Graphics – Software, Hardware, Applications
 Understand the various object Drawing Algorithms
 Learn the Basic Principles of 2 Dimensional, 3
3-Dimensional
Dimensional Transformations
 Understand the Concepts of Curves and Surfaces
 Understand the Concepts of Viewing and Projection
 Learn and Understand the basic tools used in creation in Multimedia.
COURSE OUTCOMES
 Able to describe the Basic Concepts and terminologies used in Computer Graphics
 Apply and Analyze different Approaches/ Algorithms for Drawing various graphics objects
 Identify and Apply Various Geomet
Geometrical Transformations Approaches
 Implement Various Algorithms to Polygon Fill.
 Describe the Importance of Viewing and Projections.
 Identify Various Software Systems Used in design, the Creation and Implementation of
Multi-Media.

UNIT-WISE SYLLABUS

UNIT-I
Graphics Introduction, Application of Graphics
Graphics, Elements of Graphics Workstation,
Workstation Pixel,
Frame, Buffer, Resolution, Graphics Display Devices
Devices-Raster
Raster Scan System,
System Random Scan
System, Refresh CRT, Color CRT CRT, LCD Led Monitorand Plasma Panel, Hard Copy Devices:
Printers & Plotters, Input Devices
Devices: Mouse, Trackball, Light Pen, Scanner, Digital Camera
UNIT-II
Drawing Geometry: Point–Plotting
Plotting, Coordinate System, Point Plotting, Line Drawing–Line
Drawing
Segments, Line Drawing Algorithm: DDA AlgorithmAlgorithm, Bresenham’s Line Algorithm,
Algor Circle
Drawing, Ellipse Drawing, Polygon Representation Rectangle
Rectangle, Filling– Filled Area Primitives,
Primitives
Scan Line Polygon Fill Algorithm
Algorithm, Flood Fill Algorithm,
orithm, Boundary Fill Algorithm
UNIT-III
2D Geometric Transformation: Translation
Translation, Rotation, Scaling, Geometric Transformation,
Transformation
Coordinate Transform and Composite Transformation
Transformation, 2D Viewing Transformation & Clipping:
World Coordinate System (WCS)
(WCS), Normalized Device Coordinate System, Point Clipping,
Clipping Line
Segment Clipping, Cohen–SutherlandLine
SutherlandLine Clipping
UNIT-IV

Page 50 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

3D Geometric Transformation 3D Geometric Transformation: Translation

Translation, Rotation,
Rotation Scaling,
Composite Transformation, 3D Display Methods – Parallel Projection, Perspective Projection
Curve Representation, Bezier and B
B-Spline Methods
UNIT-V
Multimedia Basics, Multimedia Applications
Applications, Multimedia: Text – Font, Faces,, Animating Text,
Hyper Text. Sound: Midi, Digital Audio Basics
Basics, File Formats Image - Bitmap,, Vector Drawing,
Color Palate, Image File Formats (BMP
(BMP, JPG), Video – Broadcast Video Standards (NTSC,
(NT PAL),
Integrating Computer and Television
Television, Compression and Decompression (JPEG, (JPEG MPEG)
Animation: Principle of Animation
Animation, Cell Animation, Kinematics, Morphing

TEXT &REFERENCE BOOKS

 D. Hearn & M. Baker, “Computer Graphics”

Graphics”, Prentice Hall
 D. F. Rogers, J. A. Adams, “Mathematical Elements for Computer Graphics”,
Graphics” TMH
 Multimedia Systems, J.F.K,, Buford, ACM Press, (ISBN 0-201-53258-1).
 Tay Vaughan, Multimedia: Makin
Making It Work, McGraw HillEducation
 Ranjan Parekh,
ekh, Principles of Multimedia, McGraw Hill Education

Page 51 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCASEC(A) - PROGRAMMING IN PYTHON

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVES
 To Introduce Python Programming Language and its Features and Applications.
 To Learn Installing Python.
 To Practice Basic Language Features of Python.
 To Implement Oops Concepts Using Python.
 To Work with Files in Python
COURSE OUTCOMES
 Install and use Python on Various Platform.
 Understand and Explain the features of Python language
 Build package and modules in Python with object
object‐oriented concept.
 Design and Develop Python applications for data analysis
 Write programs for Reading and Writing files in Python.

UNIT-WISE SYLLABUS

UNIT-I
Environment Setup of Python Application Area
Area, Interactive Mode and Script Mode Data Types,
Types
Mutableand Immutable Variables
Variables, Expressions and Statements, Variables and Keywords,
Keywords
Operators and Operands, Expressions and Statements, Taking Input andDisplaying Output.
Functions: Importing Modules,, Invoking Built in Functions, Defining Functions,
Functions Invoking
Functions, Scope, Passing Parameters
Parameters, Scope of Variables, Returning Values,
Values Recursion,
Conditional and Looping Construct
Construct,
UNIT- II
Strings: String Operators, Comparing Strings Using Relational Operators; String Functions &
Methods, Regular Expressions and Pattern MatchingLists: Concept of Mutable Lists,
Lists Creating,
Initializing and Accessing the Elements
Elements, Traversing, Appending, Updating and Deleting
Elements, Composition, Lists as Arguments, List Operations, ListFunctions and Methods,
Methods
Dictionaries: Concept of Key-Value
Value Pair
Pair, Creating,
ing, Initializing and Accessing, Traversing,
Appending, Updating and Deleting Elements
Elements, Dictionary Functions and Methods,
Methods Tuples:
Immutable Concept, Creating, Init
Initializing and Accessing Elements, Tuple Assignment,
Assignment Slices,
Indexing, Functions.
UNIT- III
Concept of Object Oriented Programming: Data Hiding
Hiding, Data Encapsulation, Class and Object,
Object
Polymorphism, Inheritance, Advantages of Object Oriented Programmi
Programmingng over Earlier
ProgrammingMethodologies

Page 52 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Classes: Defining Classes, Creating Instance Objects

Objects, Accessing Attributes andMethods,
andMethods
Constructor Methods in a Class
Class, Private Attributes (Limited Support), Importance of "Self"(Acts
as a Pointer to Current Calling Object) Operator Overloading with Methods
UNIT- IV
Inheritance: Concept of Base Class and Derived Class: Single Single, Multilevelandmultiple
Inheritance-Overriding
Overriding Methods
Methods, Using Super() in Derived Class to Invoke Init() Or Overridden
Methods of ParentClassData, File: Need for Non Non-Bold for Data File, Types of Data File-Text
File and
Binary, Opening and ClosingFiles
ClosingFiles- Open(), Close(), Access Modes (Output, Input,
Input Default), File
Object, Access_Modes, Reading andWriting a File Read() Read(), Readline(), Readlines(),
Readlines() Write(),
Writeliness, File Positions (Seek()
(Seek(), Tell()), Renaming and Deleting a File, Flush()
UNIT- V
Implementation of Basic File Operations on Text and Binary File in Python: Creating/Writing
Data intoFile, Reading and Displaying Data from File
File, Searching for Particular
icular Data from a File,
File
Insertion andDeletion of Data from an Already Existing File
File, Modification of Data in FileError
and Exceptions: Nameerror,, Indexerror, Typeerror, I/O Error, Importerror,
Importerror Valueerror,
Eoferror, Generator Function Using Yield

TEXT &REFERENCE BOOKS

 Mark Lutz Learning Python,, 5th Edition O’reilly Publication

 Fabrizio Romano Learning Python - Download Link – Https://Www.Packtpub.Com/
Packt/Free-Ebook/Learning--Python
 Mark Lutz Learning Python (Fourth Edition) –Download Link
Http://Freebook.Qiniudn.Com/Learning%20python
Http://Freebook.Qiniudn.Com/Learning%20python, %204th%20edition.Pdf
 Https://Docs.Python.Org/3/Tutorial/Index.Html

LIST OF PRACTICAL

1. Program to demonstrate basic data type in python

2. A cashier has currency notes of denominations 1010, 50, and 100.If the amount to be
withdrawn isinput
input through the keyboard using input() function in hundreds,
hundreds find the
total number of currency notes of each denomination the cashier will have to give to the
withdrawer
3. Program to demonstrate list and tuple in python
4. Write a program in n Python
Python, A library charges a fine for every book returned late. For
first 5 days the fine is 50 paisa
paisa, for 6-10
10 days fine is one rupee and above 10 days fine
is 5 rupees. If you return the book after 30 days your membership will be cancelled.
Write a program
ram to accept the number of days the member is late to return the book
and display the fine or the appropriate message
5. Write a program to calculate overtime pay of 10 employees. Overtime is paid at the rate
ofRs.12.00 per hour for every hour worked above 4 40
0 hours. Assume that employee do
not work forfractional part of an hour
hour.
6. Two numbers are entered through the keyboard
keyboard, write a program to find the value of
one numberraised to the power of another

Page 53 Dr. C.P.Agrawal

Master of Computer Applications (MCA) - 2020 Semester - II

7. Write a function that receives marks received by a student in 3 subjects and returns the
averageand percentage of these marks. Call this function from main() and print the
result in main
8. Write a program to read a file and display its contents
9. Write a program to demonstrate database connectivity in python

Page 54 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCASE
2MCASEC(B) - NOSQL DATABASES

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVES
 To give knowledge about the four types of NoSQL Databases - Document-oriented,
Document
KeyValue Pairs, Column-oriented
oriented and Graph
Graph.
 To understand the detailed architecture, define objects, load data, query data and
performance tune Column-oriented
oriented NoSQL databases.
 To describe architecture, define objects, load data, query data and performance tune
Document-oriented
oriented NoSQL databases.
 To acquire skills to define objects, load data, query data and performance tune Key-Value
Key
Pair NoSQL databases.
 To acquire skill to use MongoDB
COURSE OUTCOMES
 Define, compare and use the four ty types of NoSQL Databases - Document-oriented,
Document
KeyValue Pairs, Column-oriented
oriented and Graph.
 Demonstrate an understanding of the detailed architecture, define objects, load data, query
data and performance tune Column
Column-oriented NoSQL databases.
 Explain the detailed
ed architecture, define objects, load data, query data and performance
tune Document-oriented
oriented NoSQL databases.
 Demonstrate an understanding of the detailed architecture, define objects, load data, query
data and performance tune Key
Key-Value Pair NoSQL databases.
 Explain the detailed architecture, define objects, load data, query data and performance
tune Graph NoSQL databases.
 Perform hands-on
on NoSql database lab assignments with MongoDB.

UNIT-WISE SYLLABUS

UNIT - I
Review of the Relational Model, ACID Properties, Distributed Databases: Sharding and
Replication, Consistency, The CAP Theorem, NoSQL Data Models
Introduction to NoSQL Database
Database, Architecture, Characteristics and Significance,
Significance NoSQL
database classification – Key value Stores
Stores, Column family Stores, Document store,
store XML
Database, Graph Database, Introduction to MongoDB
MongoDB, Installation, Mongo DB Shell.
UNIT -II
Data Types, Data Modeling: Designing the Database
Database, Drilling Down on Collections,
Collections Using
Documents, Creating the _id Field
Field, Building Indexes, Impacting
mpacting Performance with Indexes,
Indexes
Working with data: Navigating Your Databases
Databases, Inserting Data into Collections,
Collections Querying for
Data, Using the Dot Notation.

Page 55 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

UNIT - III
UsingSort, Limit, and Skip Functions Working with Capped Collections
Collections, Retrieving a Single
Singl
Document, Using the Aggregation Commands
Commands, Working with Conditional Operators,
Operators Leveraging
Regular Expressions, Updating Data Data, Updating with update(), Updating Information
Automatically, Specifying the Position of a Matched Arra
Array,
UNIT 4
Atomic Operations, Modifying and Returning a Document At Atomically,
omically, Renaming a Collection,
Removing Data, Referencing Data
Data, Implementing Index-Related Functions, Surveying Index-
Index
Related Commands, Forcing a Specified Index to Query Data
Data, Constraining Query Matches.
UNIT 5
Working with GridFS, Getting Started with the Command
Command-Line Tools, Using the _id Key,Key
Working with Filenames, Determining a File’s Length
Length, Working with Chunk Sizes,
Sizes Tracking the
Upload Date, Hashing Your Files
Files, Using the search Command, Deleting,, Retrieving Files from
MongoDB.

TEXT AND REFERENCE BOOKS

OOKS

 NoSQL For Dummiesby Adam FowlerA Wiely brand

 MongoDB Documentation online available at https://docs.mongodb.com/
 Mongo DB Basics by David Hows
Hows, Peter Membrey, EelcoPlugge.: Apress.
 https://www.amazon.com/NoSQL
https://www.amazon.com/NoSQL-Distilled-Emerging-Polyglot-
Persistence/dp/0321826620 (Kindle edition)
 https://www.tutorialspoint.com/mongodb/mongodb_tutorial.pdf
https://www.tutorialspoint.com/mongodb/mongodb_tutorial.pdf.
 http://www.ccs.neu.edu/home/kathleen/classes/cs3200/20
http://www.ccs.neu.edu/home/kathleen/classes/cs3200/20-NoSQLMongoDB.pdf
NoSQLMongoDB.pdf
 MongoDB Quick start Guides
des by Doug Bierer, Packet Publisher, ISBN
ISBN- ISBN 978-1-78934-
978
353-3

LAB EXERCISES USING MONGODB

1. Download and install MongoDB

2. Create a MongoDB database to store a collection of documents
3. Load a large amount of document
document-based data into the collection
4. Query the document collection to research a topic and answer questions

For Lab Assignment 3 and 4

Structure of 'restaurants' collection:

{
"address": {
"building": "1007",
"coord": [ -73.856077,
73.856077, 40.848447 ],
"street": "Morris Park Ave",

Page 56 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

"zipcode": "10462"
},
"borough": "Bronx",
"cuisine": "Bakery",
"grades": [
{ "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 },
{ "date": { "$date": 1378857600000 }, "grade": "A", "score": 6 },
{ "date": { "$date": 1358985600000 }, "grade": "A", "score": 10 },
{ "date": { "$date": 1322006400000 }, "grade": "A", "score": 9 },
{ "date": { "$date": 1299715200000 }, "grade": "B", "score": 14 }
],
"name": "Morris Park Bake Shop",
"restaurant_id": "30075445"
}
You may download the compressed file ((https://www.w3resource.com/mongodb
https://www.w3resource.com/mongodb-
exercises/restaurants.zip)) and uncompress it to find the collection used in our exercises. The
collection comprises of 3772 documents.
1. Write a MongoDB query to display all the documents in the collection restaurants.
2. Write a MongoDB query to display the fields restaurant_id, name, borough and cuisine for
all the documents in the collection restaurant.
3. Write a MongoDB query to display the fields restaurant_id, name, borough and cuisine, but
exclude the field _id for all the documents in the collection restaurant.
4. Write a MongoDB query to display the fields restaurant_id, name, bo borough
rough and zip code,
but exclude the field _id for all the documents in the collection restaurant.
5. Write a MongoDB query to display all the restaurant which is in the borough Bronx.
6. Write a MongoDB query to display the first 5 restaurant which is in the b
borough
orough Bronx.
7. Write a MongoDB query to display the next 5 restaurants after skipping first 5 which are in
the borough Bronx.
8. Write a MongoDB query to find the restaurants who achieved a score more than 90.
9. Write a MongoDB query to find the restaurants tthat
hat achieved a score, more than 80 but
less than 100.
10. Write a MongoDB query to find the restaurants which locate in latitude value less than -
95.754168.
11. Write a MongoDB query to find the restaurants that do not prepare any cuisine of
'American' and their grade score more than 70 and latitude less than -65.754168.
65.754168.
12. Write a MongoDB query to find the restaurants which do not prepare any cuisine of
'American' and achieved a score more than 70 and located in the longitude less than -
65.754168. (Note : Do this query
uery without using $and operator.)
13. Write a MongoDB query to find the restaurants which do not prepare any cuisine of
'American ' and achieved a grade point 'A' not belongs to the borough Brooklyn. The
document must be displayed according to the cuisine in descending order.
14. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which contain 'Wil' as first three letters for its name.
15. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which contain 'ces' as last three letters for its name.

Page 57 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

16. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which contain 'Reg' as three letters somewhere in its name.
17. Write a MongoDB query to find the restaurants which belong to the borough Bronx and
prepared either American or Chinese dish.
18. Write a MongoDB query to find the restaurant Id, name, borough and cuisine
cuisin for those
restaurants which belong to the borough Staten Island or Queens or Bronxor Brooklyn.
19. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which are not belonging to the borough Staten Island or Queens
Queen or Bronxor
Brooklyn.
20. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which achieved a score which is not more than 10.
21. Write a MongoDB query to find the restaurant Id, name, borough and cuisine for those
restaurants which prepared dish except 'American' and 'Chinees' or restaurant's name
begins with letter 'Wil'.
22. Write a MongoDB query to find the restaurant Id, name, and grades for those restaurants
which achieved a grade of "A" and scored 11 on an ISODa
ISODate "2014-0808-11T00:00:00Z"
among many of survey dates..
23. Write a MongoDB query to find the restaurant Id, name and grades for those restaurants
where the 2nd element of grades array contains a grade of "A" and score 9 on an ISODate
"2014-08-11T00:00:00Z".
24. Write a MongoDB query to find the restaurant Id, name, address and geographical location
for those restaurants where 2nd element of coord array contains a value which is more
than 42 and upto 52..
25. Write a MongoDB query to arrange the name of the restauran
restaurants
ts in ascending order along
with all the columns.
26. Write a MongoDB query to arrange the name of the restaurants in descending along with all
the columns.
27. Write a MongoDB query to arranged the name of the cuisine in ascending order and for that
same cuisine
e borough should be in descending order.
28. Write a MongoDB query to know whether all the addresses contains the street or not.
29. Write a MongoDB query which will select all documents in the restaurants collection where
the coord field value is Double.
30. Write a MongoDB query which will select the restaurant Id, name and grades for those
restaurants which returns 0 as a remainder after dividing the score by 7.
31. Write a MongoDB query to find the restaurant name, borough, longitude and attitude and
cuisine for those
ose restaurants which contains 'mon' as three letters somewhere in its name.
32. Write a MongoDB query to find the restaurant name, borough, longitude and latitude and
cuisine for those restaurants which contain 'Mad' as first three letters of its name.

Page 58 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCASEC(C)
ASEC(C) - DIGITAL MARKETING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 40 10 0 50

UNIT - I
Digital Marketing - Introduction, Key terms and concepts, understanding marketing strategy,
The building blocks of marketing strategy, Crafting a digital marketing strategy, Case study:
Nike digital strategy
Market Research - Introduction, importance of market research, K Key
ey terms & concepts in
market research, Online research methodologies, Justifying the cost of research, Tools of the
trade, Advantages and challenges, Case Study: Rocking the Daisies – 2011 & 2012
Content Marketing Strategy - Introduction, Defining Content marketing, Key terms and
concepts, Strategic building blocks, Content creation, Content channel distribution, Tools of
the trade, Advantages and challenges, Case study : Coca
Coca-Cola Company
UNIT - II
User Experience Design - Introduction, Key terms and con concepts,
cepts, Understanding UX design,
Core principles of UX design, Mobile UX, Step in UX design, Tools of the trade, Case study: Rail
Europe
Web Development and Design - Introduction, Key terms and concepts, Web design, Web
development, Mobile development, Step
Steps in building a website, Case study – The Boston Globe
Writing for Digital - Introduction, Key terms and concepts, Writing for your audience, Types of
web copy, HTML for formatting, SEO copywriting, Best practices for online copywriting, Tools of
the trade,, Case study: Encyclopaedia Britannica Online
UNIT - III
Customer Relationship Management - Introduction, Key terms and concepts, A CRM model,
Understanding customers, CRM and data, The benefits of CRM, Social CRM, Steps in
implementing a CRM strategy, Tools of the trade, Case study: Fuji Xerox
Search Engine Optimisation (SEO) - Introduction, Key terms and concepts, Understanding
SEO, Search engine friendly website structure, SEO and key phrases, Link popularity, User
insights, What not to do, Tools of the trade, Benefits and challenges, Case study:
Viewpoints.com and the Panda update
Search Advertising - Introduction, Key terms and concepts, Advertising in search, The
elements of a search ad, Targeting options, Bidding and ranking for search ads, Tracking,
Planning and setting up a search advertising campaign, Tools of the trade, Advantages and
challenges, Case study – ‘Sister Act’ on Broadway
UNIT - IV
Online Advertising - Introduction, Key terms and concepts, Online advertising objectives, The
key differentiator, Types of display adverts, Payment models for display advertising, Getting

Page 59 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

your ads
ds online, Targeting and optimising, Tracking, Steps in online advertising, The future of
online advertising, Advantages and challenges, Case study: Toyota Prius
Affiliate Marketing - Introduction, Key terms and concepts, The building blocks of affiliate
marketing, Setting up a campaign, Tools of the trade, Advantages and challenges, Case study.
Video Marketing - Introduction, Key terms and concepts, Video content strategy, Video
production step by step, Video promotion, Tools of the trade, Advantages and challenges, Case
study – Woolworths: ‘Cook like a MasterChef’ for MasterChef South Africa
UNIT - V
Social Media Channels - Introduction, Key terms and concepts, Social media channels, Social
networking, Content creation, Bookmarking and aggregating, Locat Location
ion and social media,
Tracking social media campaigns, Social media marketing: Rules of engagement, Tools of the
trade, Advantages and challenges, Case study – Col’Cacchio #PriceSlice
Social Media Strategy - Introduction, Key terms and concepts, Using soci social
al media to solve
business challenges, Step-by-step
step guide to creating a social media strategy, Documents and
processes, Dealing with opportunities and threats, Step
Step-by-step
step guide for recovering from an
online brand attack, Social media risks and challenges
challenges, Case study – Super Bowl Social Media
Command Center
Email Marketing - Introduction, Key terms and concepts, Email strategy and planning, Step-
Step
by-step
step process, Tools of the trade, Advantages and challenges, Case study – Zando
Mobile Marketing - Introduction,
tion, Key terms and concepts, The role of mobile in personal
communication, Mobile messaging channels, Location and mobile, Mobile commerce,
Integrating mobile into online marketing, Augmented reality, Mobile analytics, Advantages and
challenges, Case study – Carling Black Label’s “Be the Coach”

TEXT & REFERENCE BOOKS

 eMarketing : The Essential Guide to Marketing in a digital world

world, 5th Edition, Rob
Stokesand the Minds of Quirk, Availbale online at
https://www.redandyellow.co.za/content/uploads/woocommerc
https://www.redandyellow.co.za/content/uploads/woocommerce_uploads/2017/10/emar
e_uploads/2017/10/emar
keting_textbook_download.pdf
 Ryan Deiss, Russ Henneberry
Henneberry- “Digital Marketing for Dummies”, John Wiley & Sons.
 AhujaVandana- “Digital Marketing”, Oxford University Press.
 Ira Kaufman, Chris Horton- “Digital Marketing: Integrating Strategy and Tactics with
Values, A Guidebook for Executives, Managers, and Students”, Routledge,
 Matt Chiera- “Digital Marketers Sound Off: Tips, Tactics, Tools, and Predictions from 101
Digital Marketing Specialists”, Matt Chiera,
 Puneet Bhatia- “Fundamentals of Digital Marketing”, Pearson India
 Dan Zarrella- “The Social Media Marketing Book”, O'Reilly Media.
 Krista Neher- “Visual Social Media Marketing: Harnessing Images, Instagram,
Infographics
s and Pinterest to Grow Your Business Online”, Boot Camp Digital.
 Damian Ryan, Understanding Digital Marketing Strategies for Engaging the Digital
Generation

Page 60 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCAOE(A) - STATISTICAL METHODS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 1 0 3 40 10 0 50

COURSE OBJECTIVES
 To develop the students ability to deal with quantitative & statical data
 To enable the use of statistical methods &techniques wherever relevant.
 To have a proper understanding of various Statistical techniques for solving problems
COURSE OUTCOMES
 Describe and discuss the key terminology, concepts tools and techniques used in
Statistical analysis
 Critically
ritically evaluate the underlying assumptions of analysis tools
 Understand and critically discuss the issues surrounding sampling
sampling,, estimation and
regression
 Discuss critically the uses and limitations of statistical methods
 Solve a range of problems usin
using the techniques covered

UNIT-WISE SYLLABUS

UNIT-I
Statistics and Data Analysis: Statistical Inference
Inference, Samples, Populations, and the Role of
Probability, Sampling Procedures; Collection of Data
Data, Measures of Location: The Sample Mean
and Median, Measures off Variability
Variability, Discrete and Continuous Data, Statistical Modeling.
Probability: Sample Space, Events
Events, Counting Sample Points, Probability of an Event,
Event Additive
Rules, Conditional Probability, Independence
Independence, and the Product Rule, Bayes‟ Rule.
UNIT-II
Random Variables and Probability Distributions: Concept of a Random Variable,Variable Discrete
Probability Distributions, Continuous Probability Distributions
Distributions, Joint Probability Distributions.
Mathematical Expectation: Mean of a Random Variable
Variable, Variance and Covariance of
o Random
Variables, Means and Variances of Linear Combinations of Random Variables,
Variables Chebyshev‟s
Theorem.
UNIT-III
Some Continuous Probability Distributions: Continuous Uniform Distribution,
Distribution Normal
Distribution, Areas under the Normal Curve
Curve, Applications of the Normal Distribution,
Distribution Normal
Approximation to the Binomial
Binomial, Gamma and Exponential Distributions,
Distributions Chi-Squared
Distribution, Beta Distribution,, Lognormal Distribution.
UNIT-IV

Page 61 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Fundamental Sampling Distributions and Data Descriptions: Random Sampling, Sampling

Distributions, Sampling Distribution of Means and the Central Limit Theorem, Distribution of
S2, t –Distribution, F-Distribution.
Distribution.
One and Two-Sample
Sample Estimation Problems: Introduction
Introduction, Statistical Inference,
Inference Classical
Methods of Estimation, Single SamSample: Estimating the Mean, Standard Error of a Point
Estimate, Prediction Intervals,, Tolerance Limits, Two Samples: Estimating the Difference
between Two Means, Paired Observations
Observations, Single Sample: Estimating a Proportion,
Proportion Two
Samples: Estimating the Differe
Difference between Two Proportions, Single Sample: Estimating the
Variance, Two Samples: Estimating the Ratio of Two Variance.
UNIT-V
Multiple Linear Regression and Certain Nonlinear Regression Models: Introduction,
Introduction Estimating
the Coefficients, Linear Regression Model Using Matrices, Properties of the Least Squares
Estimators, Inferences in Multiple Linear Regression
Regression, Choice of a Fitted Model through
Hypothesis Testing, Categorical or Indicator Variables
Variables, Sequential Methods for Model Selection,
Selection
Cross Validation, Other Criteria for Model Selection
Selection, Special Nonlinear Models for Non ideal
Conditions.

TEXT &REFERENCE BOOKS

 Ronald E. Walpole, Raymond H. Myers, Sharon L. Myers, Keying Ye, Probability & Statistics
for Engineers & Scientists, PearsonPublishers.
 S C Gupta and V K Kapoor, Fundamentals of Mathematical Statistics, Khannapublications.
 T.T. Soong, Fundamentals of Probability and Statistics For Engineers,
neers, John Wiley & Sons
Ltd.
 Sheldon M Ross, Probability and Statistics for Engineers and S
Scientists, AcademicPress.
AcademicPress
 S. D. Sharma, Operations Research
Research, Kedarnath and Ramnath Publishers, Meerut,
Meerut Delhi

Page 62 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCAOE(B) - VIRTUAL REALITY

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

UNIT - I
Introduction - The Three I’s of Virtual Reality, A Short History of Early Virtual Reality, Early
Commercial VR Technology, The five Classic Components of a VR System, Advantages of using
VR
VR Input Devices - Trackers, Navigation, and Gesture - Interfaces, Three-Dimensional
Dimensional Position
Trackers, Tracker Performance Parameters, Mechanical Trackers, Magnetic Trackers,
Ultrasonic Trackers, Optical Trackers, Hybrid Inertial Trackers, Navigation and Manipulation
Interfaces, Tracker-Based
ed Navigation/Manipulation Interfaces, Trackballs, Three
Three-
Dimensional Probes, Gesture Interfaces, The Pinch Glove, The 5DT Data Glove, The
DidjiGlove, The CyberGlove
VR Output Devices: Graphics, Three
Three-Dimensional - Sound, and Haptic Displays, Graphics
Graphi
Displays, The Human Visual System, Personal Graphics Displays, Large
Large-Volume
Volume Displays,
Sound Displays, The Human Auditory System, The Convolvotron, Speaker-Based
Speaker Three-
Dimensional Sound, Haptic Feedback, The Human Haptic System, Tactile Feedback Feedbac
Interfaces, Force Feedback Interfaces
UNIT - II
Computing Architectures for VR - The Rendering Pipeline,The Graphics Rendering Pipeline,The
Haptics Rendering Pipeline,PC Graphics Architecture,PC Graphics Accelerators,Graphics
Benchmarks,Workstation-Based
Based Architectures,The Sun Blade 1000 Architecture,The SGI
InfiniteReality Architecture,Distributed VR Architectures,Multi
Architectures,Multi-pipeline
pipeline Synchronization,Co-
Synchronization,Co
located Rendering Pipelines,Distributed Virtual Environments
VR Modeling - Geometric
ric Modeling,Virtual Object Shape,Virtual Object Appearance,Kinematics
Modeling,Homogeneous Transformation Matrices,Object Position,Transformation
Invariants,Object Hierarchies,Viewing the Three
Three-Dimensional
Dimensional World,Physical
Modeling,Collision Detection,Surfa
Detection,Surface
ce Deformation,Force computation,Force Smoothing and
Mapping,Haptic Texturing,Behavior Modeling,Model Management,Level
Management,Level-d-Detail
Management,Cell Management
UNIT - III
VR Programming - Toolkits and Scene Graphs,WorldToolKit,Model Geometry and
Appearance,The WTK Scene Graph,Sensors and Action Functions,WTK Networking,Java
3D,Model Geometry and Appearance,The Java 3D Scene Graph,Sensors and Behaviors,Java
3D Networking,WTK and Java 3D Performance Comparison,General Haptics Open Software
Toolkit,GHOST Integration n with the Graphics Pipeline,The GHOST Haptics Scene
Graph,Collision Detection and Response,Graphics and PHANToM Calibration,PeopleShop,DI-
Calibration,PeopleShop,DI
Guy Geometry and Path,Sensors and Behaviors,PeopleShop Networking
UNIT - IV

Page 63 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Human
uman Factors in VR,Methodology and Termi Terminology,Data
nology,Data Collection and Analysis,Usability
Engineering Methodology,User Performance Studies,Testbed Evaluation of Universal VR
Tasks,Influence of System Responsiveness on User Performance,Influence of Feedback
Multimodality,VR Health and Safety Issues,D Issues,Direct
irect Effects of VR Simulations on
Users,Cybersickness,Adaptation and Aftereffects,Guidelines for Proper VR Usage,VR and the
Society,Impact on Professional Life,Impact on Private Life,Impact on Public Life
UNIT - V
Traditional VR Applications - Medical Applications
lications of VR,Virtual Anatomy,Triage and
Diagnostics,Surgery,Rehabilitation,Education, Arts, and Entertainment,VR in Education,VR
and the Arts,Entertainment applications of VR,Military VR Applications,Army Use of VR,VR
Applications in the Navy,Air Force Use of VR
Emerging Applications of VR - VR Applications in Manufacturing,Virtual Prototyping,Other VR
Applications in Manufacturing,Applications of VR in Robotics,Robot Programming,Robot
Teleoperation,Information Visualization,Oil Exploration and Well Mana
Management,Volumetric
gement,Volumetric Data
Visualization

TEXT & REFERENCE BOOKS

 Virtual Reality Technology, Second Edition, by GRIGORE C. BURDEA, PHILIPPE COIFFET,

Wiley,
 Virtual Reality BYLaValle, Steven M.
 Fundamentals of Computer Graphics by Shirley, Peter, Michael Ashikh
Ashikhmin,
min, and Steve
Marschner, CRC Press (2009)
 Visual Perception from a Computer Graphics Perspective by Thompson, William, Roland
Fleming, Sarah Creem-Regehr,
Regehr, Jeanine K. Stefanucci, CRC Press

Page 64 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

2MCAOE(C) - ANGULAR JAVA SCRIPT

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 Implement single-page
page applications
applications, Build Angular Forms
 Understand the use of Modules
Modules, Controllers and Directives
 Understand the concept and implementation of Dependency Injection
 Master AngularJS expressions
expressions, filters, and scopes
COURSE OUTCOMES
 Build real client apps with Angular on your own
 Troubleshoot common compile
compile-time and run-time errors
 Write clean and maintainable code like a professional
 Apply best practices when building Angular apps

UNIT-WISE SYLLABUS

UNIT - I
JavaScript Introduction, The Basics of AngularJS - Why We Need Frameworks, What Is a
Framework?, Downloading and Installing AngularJS, Browser Support, Your First AngularJS
Application, Declarative vs. Procedural Programming, Directives and Expressions - What Is a
Directive?, What Are Expressions ?
JavaScript Primer - Including Scripts on a Page, Statements, Functions, Parameters and
Return Values, Types and Variables, Primitive Types – Booleans, Strings, Numbers, Undefined
and Null, JavaScript Operators, Equality vs. Identity, Pre
Pre- vs. Post- Increment,
Increment Working with
Objects - Creating Objects, Reading and Modifying an Objects Properties, Adding Methods
M to
Objects, Enumerating Properties
Properties, Control Flow – Loops, Conditional Statements,
Statements Working with
Arrays - Array Literals, Enumerating and Modifying Array Values, Callbacks, JSON
UNIT - II
Introduction to MVC - Design Patterns, Model View Controller – Model, View, Controller, A
Separation of Concerns, Why MVC Matters, MVC the AngularJS Way Way, Filters and Modules -
Introduction to Filters, Built-in
in Filters, The Number Filter
Filter, The Date Filter, The limitTo Filter,
AngularJS Modules - What Is a Module?
Module?, Bootstrapping
trapping AngularJS, Creating a Custom Filter
UNIT - III
Directives - The Basics of Directives, Using Directives, Built
Built-in Directives - ngBind, ngCloak,
ngInclude, ngShow and ngHide, ngRepeat, Event Event-Handling
Handling Directives, Using the API
Documentation, Creating a Custom Directive - The restrict Option, The template Option, The
link Option

Page 65 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - II

Working with Forms - HTML Forms Overview, The form Element

Element, The input Element – button,
submit, text, checkbox, password, radio
radio, The textarea Element, The select Element, The label
l
Element, Model Binding, AngularJS Forms, Validating Forms
UNIT - IV
Services and Server Communication
Communication- Using Services, The $window Service,
Service The $location
Service, The $document Service, Why Use Services?
Services?, Creating Services – Promises, Server
Communication, Handling Returned Data - Accessing Returned Data, Handling Errors
Organizing Views - Installing the ngRoute Module, Using URL Routes - Defining Routes, Route
Parameters, Eager vs. Conservative Routes, Route Configuration Options
Options, HTML5 Mode
UNIT - V
AngularJS Animation - Installing the ngAnimate Module, CSS Animation Overview -
Transforms, Transitions, Applying Animations
Animations, Deployment Considerations – Configuration,
Testing, Error Handling, Hide Unprocessed Templates, Minification and Bundling, Managing
Managin
the Build Process, Deployment

TEXT &REFERENCE BOOKS

 AngularJS Essentials- Rodrigo Branas, Packt Publishing Ltd Open Source

 AngularJS:Novice To Ninja - Sandeep Panda, Sitepoint Pty. Ltd, Download link http://
www.longevity.co.uk/media/1008/ang
www.longevity.co.uk/media/1008/angularjs-novice-to-ninja.pdf

Page 66 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCACCC1 - SOFTWARE ENGINEERING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 4 1 0 5 80 20 0 100

COURSE OBJECTIVES
 Understand, Learn and Apply the Theoretical and Practical Knowledge of Software
Development Such as Software Development Paradigms
Paradigms, Process, Models,
Models Tools and
Techniques.
 Understand and Learn the Process of Software Requirements Identification,
Identification Analysis,
Review, and also Learn Recording Requirements in theIEEE Format of the SRS Document.
 Understand the Various Types and Levels of Software Testing and Basic Approaches of Test
Case Designing.
 Gain the Knowledge
ge of the Various Models of Software Quality
Quality, Estimation,
Estimation Quality
Assurance and Control.
COURSE OUTCOMES
 Identify, Analyze, Review and Validate the Requirement of SoftwareComponents and
System, and Also Prepare Software Requirement Specification (SRS) Document
Docu Using
Relevant Standards, Tools and Methodologies.
 Manage a Software Project by Applying Project Management Concepts Such as Planning,
Planning
Scheduling and Risk Management for Developing Qualitative and Economic Software.
 Work Effectively in Various Profiles of Software Developing Team Such as Software Analyst,
Analyst
Architecture, Programmer, Tester
Tester, Quality Assurance and Control officer,, Project Manager
and Leaders.
 Communicate and Coordinate Competently by Listening
Listening, Speaking, Reading and Writing
Software Documents
 Apply Coding Standards & Guidelines
Guidelines, and Quality Norms in Coding of Software Systems to
Satisfy the Requirements and Quality.
 Design Test Cases and Optimize the Test Suite for UNIT
UNIT, Integration and System-Level
System
Testing using various Techniques a and
nd Tools for Adequately Testing the Software
Components and Systems.

UNIT-WISE SYLLABUS

UNIT-I
Software: Software Characteristics
Characteristics, Components, and Applications, Software Engineering
Layered Technology, Software Development Life Cycle
Cycle, Software Process Models-
Mode Linear
Sequential Model, Prototype & RAD Model
Model, Incremental and Evolutionary Process Models.
Introduction of Agile Software Development
Development, CBSD(Component Based Software Development )
Aspect Oriented Paradigm (AOP) and Green Software Development
Development, Process and Product
Metrics.

Page 67 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

UNIT-II
Analysis Concept and Principles: Requirement Analysis
Analysis, Analysis Principles,
Principles Requirement
Elicitation, Information Gathering Techniques
Techniques, Requirements Specification,
Specification Requirements
Verification and Validation, Requirements Management. Requirements Modeling: Scenarios,
Scenarios
Information and Analysis Classes
Classes, Flow and Behavioral Modeling, Documenting Software
Requirement Specification (SRS) Characteristics of SRS
SRS, Format of SRS,, Software Project
Planning: Objectives, Decomposition T Techniques, and Empirical Estimation Models. Project
Metrics: Software Measurement––Size Oriented, Function Oriented Metrics.
UNIT-III
Design Concepts and Principles: Design Process
Process, Design Concepts, Design Principles,
Principles Effective
Modular Design, Human Compute
Computer Interface Design, Interface Design Guidelines. System
Design: Design Models for Architecture
Architecture, Component, Data and User Interfaces; Problem
Partitioning, Abstraction, Cohesiveness
Cohesiveness, Coupling, Top Down and Bottom Up Design
Approaches; Functional Versus Obje
Object Oriented Approach, Design Specification. Coding:Top-
Coding:Top
Down and Bottom-Up Up Structure Programming
Programming, Information Hiding, Programming Style,
Style and
Internal Documentation, Verification.
UNIT-IV
Software Testing: White and Black Box Testing
Testing, Levels of Testing, Unit, Integration,
Integration System
Testing, Functional Testing, Structural Testing
Testing, Test Plan, Software Testing Strategies,
Strategies
Verification & Validation, Incremental & Non
Non-Incremental Testing, Top Down and Bottom Up
Integration Testing, Alpha & Beta Testing
Testing, White Box and Black Box Test Case Design
Techniques, Debugging Techniques. Software Quality
Quality, Quality Models, Quality Control and
Quality Assurance, ISO, SEI Capability Maturity Model (CMM) and Comparison between ISO&
SEI CMM.
UNIT-V
Agile Methodology: Introduction and background, Values of Agile, Stakeholders,
Stakeholders Challenges,
Agile Manifesto andPrinciples,,
,, Twelve Practices of XP, Overview of Scrum,, Need of scrum,
working of scrum, advanced Scrum Applications
Applications, Scrum and the Organization,
Organization scrum values,
Framework of Scrum, Extreme Programming
Programming, Feature Driven development,
development Lean Software
Development, Agile project management
management, Design and development practices in Agile projects,
projects
Refactoring, Pair Programming,, User Stories, Characteristics and contents of User stories,
stories
Backlog Management, Agile Risk Management
Management, Scrum roles, Agile Tools, Agile Metrics and
Measurements, Agile Design Practice
Practice, Refactoring Techniques, Agile Testing,
Testing Test-Driven
Development (TDD), x Unit framework and tools for TDD TDD, Agile Configuration Management,
Management
Continuous
inuous Integration /Continuous Delivery (CI/CD)
(CI/CD), and DevOps

TEXT &REFERENCE BOOKS

 Roger S. Pressman, Software Engineering

Engineering-a Practitioner’s Approach, McGraw Hill
International Edition,
 K. K. Aggarwal, Yogesh Singh
Singh, Software Engineering,
 Ian Sommerville, Software
oftware Engineering
Engineering, Addison-Wesley
Wesley Publishing Company,
Company
 James F. Peter, Software Engineering - an Engineering Approach, John Wiley,
Wiley
 Fairley Richard Software Engineering Concepts
Concepts, Tata McGraw Hill

Page 68 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

 ScrumKenSchawber, Mike Beedle

Beedle-Agile Software Development with Publisher: Pearson.
Pearson
 Lisa Crispin, Janet Gregory Agile Testing: A Practical Guide for Testers and Agile Teams
Publisher: Addison Wesley.
 Kenneth S. Rubin, Essential Scrum: A Practical guide to the most popular agile process
 Robert C. Martin, Agile Software Development
Development, Principles, Patterns and Practices,
Practices
Publisher: Prentice Hall

Page 69 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCACCC2 - JAVA PROGRAMMING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 3 0 4 5 50 20 30 100

COURSE OBJECTIVES
 Introduce and Learn the Usage of the Java SDK Environment to Create, Debug and Run
Java Programs.
 Understand Fundamentals of Java Programming Such as Character Set, Variables, Data
Types, and Control Structures, Array, Class and Methods.
 Understand the Concepts of (OOPs) and Learn Implementation in Java Defining Classes,
Invoking Methods, Using Class Libraries.
 Introduce Strings, Vectors, Interfaces, Packages and Threads Handling in Java.
 Gain the Knowledge of Java Applets, AWT, Swings, Servlet.
 Understand the GUI Application, Web Applications, N
N-Tier Architecture.
 Develop the Understanding of the Basic Knowledge of File Handling, Database Connectivity,
Java Servlets and Web Application.
COURSE OUTCOMES
 Explain and Apply the Object
Object-Oriented Concepts for Solving Real Problem.
 Use the Java SDK Environment to Create, Debug and Run Simple Java Programs.
 Apply Java Technology to Develop the Small Applications, Utilities, and Web Applications.
 Apply
ply Events Management and Layout Managers Using AWT, Swing,, JDBC and Servlet for
Developing the Software for Various Problems.

UNIT-WISE SYLLABUS

UNIT-I
Basics of Java: History and Basics of Java, Java Environment, JDK Tools, Java Virtual
Machine, Java Program
gram Structure, Java Language
Language- Tokens, Keywords, Constants, Variables,
and Data Types. Operators and Expressions, Statements - Decision Making, Branching and
Looping, Labeled Loops Statement, Jump Statements: Break, Continue, and Return, Command
Line Argument.
UNIT-II
Classes and Objects: Classes, Objects, Defining a Class, Adding Variables and Methods,
Creating Objects, Accessing Class Members, Constructors, Static Members, Nesting of
Methods, Inheritance and Polymorphism: Basics Types, Extending a Class, Using Super,
Method Overloading, Method Overriding, Final Variables and Methods, Final Classes, Finalize
Method, Abstract Methods and Classes, Visibility Control.
UNIT-III
One and TwoDimension Arrays, String Array, String and String Buffer Classes, Vectors,
Vectors
Wrapper Classes. Interfaces: Defining Interfaces, Extending Interfaces, Implementing

Page 70 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

Interfaces, Accessing Interface Variables, Packages: System Packages, Naming Conventions,

Creating Packages, accessing a Package, Using Package, Adding a Class to a Package,
Pack Hiding
Classes. Exception Handling: Introduction to Exception Handling, Try
Try-Catch,
Catch, Finally, Throws,
JavaThread Model:: Life Cycle of a Thread, Thread Class, Runnable Interface
UNIT-IV
Applet Programming: Creating and Executing Java Applets, Inserting Applets in a Web Page,
Applet Tag, Local and Remote Applets, Applets Vs. Applications, Applets Life Cycle. AWT
Classes, Swing Classes, Event Handling, AWT Programming: Working with Windows, Graphics
and Text, Using AWT Controls, Layout Managers and Menus, Handling Image, Animation,
Sound and Video. Java Swing: Japplet, Icons and Labels, Text Fields, Buttons, Radio Buttons,
Check Boxes, Combo Boxes, List Boxes, Tabbed and Scroll Panes, Tables. Event Handling:
UNIT-V
I/O Stream:Introduction of I/O Stream, T
Types
ypes of Streams, Stream Class Hierarchy, Using File
Class, Byte Streams Vs Character Streams, TextfileVs Binary File, Standard I/O Streams, and
Random-Access File, Serialization.
Database Programming Using JDBC: Introduction to JDBC, JDBC Drivers, Types of
o JDBC
Drivers, Connecting with Database.
J2EE: Introduction ofJ2EE, Web Application Basics, Architecture and Challenges of Web
Application, Servlet,, Servlet Life Cycle, Developing and Deploying Servlets.

TEXT &REFERENCE BOOKS

 E. Balagurusamy, "Programmin
"Programming with Java, a Primer",TMH, ISBN-13:
13: 978-0-07-061713-
978
1, ISBN-10: 0-07-061713-9.
9.
 Patrick Naughton and Herbert Schildt, "Java: the Complete Reference", TMH Publication,
ISBN 0-07-463769-X.
 Yashavant Kanetkar,
anetkar, "Let us Java", BPB Publications.
 Ivan Bayross, "Web Enabled Commercial Application Development Using HTML, DHTML,
JavaScript,, Perl CGI",BPB Publications
 Cay Horstmann, "Big Java", Wiley Publication
 Peter Norton, "Java Programming", Techmedia Publications.
 Joseph Weber, "Using Java 1.2", P
PHI, ISBN -81-203-1558-8.

LIST OF PRACTICAL

1. Write a Program in Java to Calculate the Simple Interest.

2. Write a Program in Java to Calculate Sum of Two Numbers Input from Command Line
Argument.
3. Write a Program in Java to Calculate Area of Circle Using Scanner Class.
4. Write a Program in Java to Calculate Square Root of a Number.
5. Write a Program in Java to Display Name, Age, Calendar and Salary of a Person Input from
the Keyboard.

Page 71 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

6. Write a Program in Java to Display Grading of Student When His Percentage is Input from
Keyboard.
7. Write a Program in Java to Display Odd Number from 1 to 100.
8. Write a Program in Java to Display the Following Pattern
Patterns using Functions..
(a) (b) (c) (d)
1 1 1 1
22 22 12 23
333 333 123 456
4444 4444 1234 7 8 9 10
55555 55555 12345 11 12 13 14

9. Write a Program in Java to Calculate the Factorial of a Number.

10. Write a Program in Java to Determine Whether a Number Input from Keyboard is Prime
Number Or Not.
11. Write a Program in Java to Display the Prime Numbers from 1 to 500 Using Function.
12. Write a Program in Java to Show Accessing Class Members and use a Dot(.).
13. Write a Program in Java to S
Show Multilevel Inheritance.
14. Write a Program in Java to Show Single Inheritance.
15. Write a Program in Java to Concatenate Two Strings Without Using Library Function.
16. Write a Program in Java to Make First Alphabet Capital of Each Word in a String.
17. Write a Program
ram in Java to Get the Last Index of Any Given Character in a String.
18. Write a Program in Java to Reverse Words of a String.
19. Write a Program in Java to Find Occurrences of Each Character in a String.
20. Java Program to Get String and Count Number of Words in P
Provided
rovided String.
21. Write a Program in Java to Check Given String is Palindrome String Or Not in Java.
22. Write a Program in Java to Reverse Each Word of Given String.
23. Write a Program in Java to Get Sub String from a Given String.
24. Java Program to Convert String to Lowercase and Uppercase.
25. Create a Java Applet and Show the use of Drawstring() Function.
26. Create a Java Applet to Show How to use Various Methods of Applet Class and Graphics
Class in a Java Applet.
27. Write a Program in Java to Show the use of Interface.
28. Create
reate a Java GUIApplication Using Labels and Textfields.
29. Create a Java GUI Application Using Radiobuttons.
30. Create a Java GUI Application Using Checkboxes.
31. Create a Java GUI Application Using Comboboxes.

Page 72 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

32. Create a Java GUI Application Using Listboxes.

33. Create Two Html Pages with Links to Navigate from One Page to Other Page.
34. Write a Servlet to Display Current Date and Time of Server on
n Client : Date Servlet
35. Write a Servlet to Display Natural Numbers from 1 to 100 : Numberservlet
36. Create a JSP to Display Natural Numbers from 1 to 50 :Number.Jsp and Write Down the
Process of Running It Step b
by Step.
37. Create a JSP to Display Current Date and Time of Server onClient
Client :Date.JSP and Write
Down the Process of Running iit Step by Step.
GROUP ASSIGNMENT
1. Scientific Calculator Utility
2. Chat Application
3. Time Table System
4. Student Attendance System
5. Steganography & Data Encryption System Java
6. Student Information System
7. Survey Tool System
8. Text Editor Like Notepad/Wordpad
9. Game / Puzzle Like Luddo Game
10. Game / Puzzle Like Snake Game
11. Paint Application

Page 73 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCACCE(A) - THEORY OF COMPUTATION

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 4 1 0 5 80 20 0 100

COURSE OBJECTIVES
 Learn and Understand FSA,, DFA, NDFA, Turing Machine, Regular Expression,
Expression Push Down
Automaton.
 Learn and Understand Properties of Languages
Languages, Grammars and Automata.
 Gain knowledge of Computing and Mathematics to Solve Problems.
COURSE OUTCOMES
 Demonstrates Models, Turing Machine
Machine, Regular Expression, Push Down Automaton.
 Model, Compare and analyze different Computational Models.
 Apply and Prove properties of Languages
Languages, Grammars and Automata.
 Apply Knowledge of Computing and Mathematics to SolveProblem
 Apply Mathematical Foundations
Foundations, Algorithmic Principles and Computer Science Theory to
the Modeling

UNIT-WISE SYLLABUS

UNIT-I
Introduction to Theory of Computation: Basic Computational Constructs: Finite State Systems,
Systems
Non Deterministic Finite Automata (NDFA)
(NDFA), Deterministic Finite Automata
ta (DFA),
(DFA) Equivalence
of DFA and NDFA, Finite Automata with E E-Moves, Limitations of FSM, Minimization of Finite
Automata, Moore and Mealy Machines
Machines, Equivalence of Moore and Mealy Machines.
UNIT- II
Regular Sets, Closure Properties of Regular Sets
Sets, Pumping Lemma, Applications of Pumping
Lemma. Regular Expression, Laws for Regular Expression
Expression, Equivalence of Finite Automata and
Regular Expression, Introduction to Regular Grammar.
UNIT- III
Introduction to Context Free and Context Sensitive Grammar
Grammar, Ambiguity,
Ambiguity Parse Tree
Representation of Derivations,, Simplification of Context Free Grammar,, Normal Forms
(Chomsky Normal Form (CNF) and Griebach Normal Form (GNF)).
UNIT- IV
Definition, Deterministic Push Down Automaton (DPDA)
(DPDA), Non-Equivalence
Equivalence of PDA& DPDA,
DPDA
Equivalence of CFG and PDA, Pumping Lemma for CFL’s
CFL’s, Closure Properties of CFL,
CFL Non-CFL.
UNIT- V
Turing Machine(TM): Introduction
Introduction, Types of Turing Machine, Universal Turing Machine and
Other Modifications, Construction of Tm for Simple Problems
Problems, Turing Machine as Enumerators,
Relation Between Languages of Classes
Classes, Computational Complexity Theory. Computable

Page 74 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

Functions: Partial, Total, Constant Functions

Functions, Primitive Recursive Function, Regular Function,
Function
Recursive Functions.

TEXT &REFERENCE BOOKS

 John E Hopcroft, Rajeev

v Motwani
Motwani, Jeffrey D. Ullman.Introduction to Automation Theory,
Theory
Languages & Computation
 Mishra &Chandrasekaran-Theory
Theory of Computer Science (Automata
(Automata, Languages and
Computation PHI ISBN-81-203
203-1271-6
 Lewis & Papadimitriou Elements of the Theory of Computati
Computation, PHI ISBN 81-203-1016-0
81
 John C. Martin -Introduction
Introduction to Languages and Theory of Computation ISBN-
ISBN 0-07-
463722-3
 Bernard M. Moret Pearson --Theory of Computation ISBN-81-7808-550
 Raymond Greenlaw& H. James Hoover (Harcount) - Fundamentals of Theory of
ComputationISBN: 81-7867
7867-036-4

Page 75 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCACCE(B) - BIG DATA

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 3 0 4 5 80 20 0 100

COURSE OBJECTIVES:
 Familiarize the students with most important information technologies used in
manipulating, storing, and analyzing big data
data.
 This course gives students all around learning of the big data framework using Hadoop and
spark, including yarn, HDFS and MapReduce
 Itprovide an overview of approach
approaches
es facilitating data analytics on huge datasets.
datasets
COURSE OUTCOME:
 Ability to identify the characteristics of datasets and compare the trivial data andbig data
for various applications.
 Demonstrate an ability to useHadoopframeworkto efficiently store retrieve and process Big
Data for Analytics.
 Implement several Data Intensive tasks using the MapReduce Paradigm

UNIT -WISE SYLLABUS

UNIT - I
Big Data- Introduction, Characteristics
Characteristics, Types, Elements, Traditional vs. Big Data Business
Approach, Big Data Analytics, Advantages
Advantages, Applications, Distributed & Parallel Computing for
Big Data, Components in Big Data Architecture
Architecture, Virtualization Approaches.
UNIT - II
Statistics and Probability: Sampling Techniques - Data Classification, Tabulation,
Tabulation Frequency
and Graphic Representation, Measures of Central Value - Mean, Mode, Median,Median Random
Variable and Probability Theory..
UNIT - III
Hadoop- Introduction, Features
Features, Advantages, Versions, Key Considerations of Hadoop,
Hadoop
RDBMSVsHadoop, Hadoop Ecosystem
Ecosystem, HDFS - Architecture, Features, Commands,
Commands Processing
Data withHadoop, Hadoop Yarn..
UNIT - IV
MapReduce Framework, Features
Features, Uses, WorkingonMapReduce, MapReduce
educe Input and Output
Operations, Exploring Map and Reduce Functions
Functions, MapReduce
educe Optimization Technique,
Technique
HBASE Introduction, Architecture
Architecture, HBASE in Hadoop Applications.
UNIT - V
Processing Data withMapReduce
educe, Task Execution & Environment – Installation of Eclipse,
Eclipse
Hadoop, Java Development Kit and Linux Ubuntu OS OS, MapReduce
educe Program Steps to Obtain
Word Count, Functionality of Input Format
Format- Inputsplit, Recordreader, Fileinputformat,
Fileinputformat Output

Page 76 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

Process of Fileoutputformat – Outputformat, Recordwriter, Role of Combiner,

Combiner Partitioner,
Debugging MapReduce.

REFERENCE BOOKS

 Rob Kitchin The Data Revolution: Big Data Open D

Data
ata Data Infrastructures and
theirConsequences
heirConsequences SAGE Publications Ltd
 Croll and B. YoskovitzLean Analytics: Use Data to Build a Better Startup Faster o'reilly
 Mayer-Schönberger and K. CukierBig Data: A Revolution That Will Transform How We
Live Work and Think
 E. Siegel-Predictive
Predictive Analytics: The Power to Predict Who Will Click Buy Lie or Die
 Bernard Marr-Big
Big Data in Practice Wiley publication
publication.

Page 77 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCACCE(C) - DEVELOPMENT AND OPER

OPERATIONAL
ATIONAL TOOLS (DEVOPS)
(DEVOP

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 3 0 4 5 50 20 30 100

COURSE OBJECTIVES
 Understand the principles of continuous development and deployment.
 Understand and use AWS Services.
 Concepts of version control and using Git for version control
 Understand and use the container Technology
 Using
sing DevOps tools like Git, Docker etc. in various aspects of DevOps delivery model.
COURSE OUTCOME
 Explain the principles of continuous development and deployment of software.
 Using AWS Services
 Using Git for version control
 Use container Technology in Software development
 Using DevOps tools like Git, Docker etc in various aspects of DevOps delivery model.

UNIT-WISE SYLLABUS

UNIT-I
What is DevOps?, Why is DevOps is Needed?, How is DevOps different from traditional IT?,
Why is DevOps used?, DevOps Lifecycle, DevOps Work Flow, DevOps Vs Agile, DevOps
Principles, Roles, Responsibilities, and Skills of a DevOps Engineer, Various DevOps Tools
Amazon Web Services - Cloud Computing
Computing, Advantages, Types of Cloud Computing,
Computing Amazon
Web Services Cloud Platform Overview, Features of Elastic Compute Cloud (EC2),(EC2) AWS
Services, AWS Management Console, AWS Command Line Interface, Region, availability Zone
and edge location, Amazon EC2 root device volume
volume, Creating and Launching EC2 windows and
Linux Instances, Connecting to Linux and Windows Instances
Instances, Managing Security Group,
Group
Identity access Management (IAM)
(IAM), Create IAM users and Group, Assign policy to IAM users
and Groups, Configure IAM roles to access AWS resources
UNIT - II
Version Control with Git - About Version Control
Control, Local Version Control Systems,
Systems Centralized
Version Control Systems, Distributed Version Control Systems
Systems, What is Git?, A Short History of
Git, difference between Git and any other V
VCS, The Three States of Git - modified, staged, and
committed, Why Git for your organization
organization, Install and Using Git, Common commands in Git, Git
Working with Remote Repositories
UNIT - III
Container Technology - Introduction to Containers?, Benefits of Contain
Containerization,
erization, How Do
Containers Work?, Virtual Machines vs Containers, brief intro to Container Terminology,

Page 78 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

Overview of Container Architecture

Architecture, Installing Container engine tool, Creating Containerized
Services, Provisioning Containerized Services
UNIT - IV
Managing Containers - What is Container management, Benefits of Container management,
Container management strategy
strategy, Pull Docker images from Docker hub, Managing the Life Cycle
of Containers, Attaching Persistent Storage to Containers
Containers, Accessing containers, Managing
Container Images - Accessing Registries (public and Private)
Private), Manipulating Container Images

UNIT - V
Creating Custom Container Images - Designing Custom Container Images, Building Custom
Container Images with Dockerfile
Configuration Management with Ansible - Introduction to Ansible, Ansible Installation,
Installation
Configuring Ansible Roles, Write Playbooks
Playbooks, working with playbooks, manage ansible variables,
Executing adhoc command, Ansible Variables

PRACTICAL LAB

UNIT - I
 Create AWS Account
 Launch Linux and Windows Instances
 Connecting to Linux and Windows Instances
 Create IAM users and Groups
 Manage IAM Policy and Roles
UNIT - II
 Create github account
 Create public and private repository
 Working with github repository
UNIT - III
 Installation of Docker / Podman / Rocket
 Creating Containerized Services (Database and webserver instances)
 Maria DB / My Sql / Nginx / Httpd
UNIT - IV
 Persisting a MYSQL Database
 Managing a MYSQL Container
 Managing Images (tags)
UNIT – V
 Creating Custom Container Images
 Install ansible on control node
 Execute adhoc command
 Working with playbooks
 Manage ansible variables

Page 79 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

TEXT & REFERENCE BOOKS

DevOps For Dummies 2ndIBMLimitedEdition by Sanjeev Sharma and Bernie Coyne.

Coyne
DevOps_Revealed_by_International_DevOps_Certification_Academy
DevOps_Revealed_by_International_DevOps_Certification_Academy.
Effective DevOps by Jennifer Davis & Katherine Daniels
Daniels.
The DevOps Handbook_ How to Create World
World-Class Agility, Reliability, and Security in
Technology Organizations.

Page 80 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCASEC(A) - PROGRAMMING WITH R

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVES:
 Provide the knowledge of Basic R Programming Language to Students
Students.
 Prepare Students for Role of Professional Data Analyst
Analyst.
 Learn about Concepts of R Programming like Control Structures
Structures, Functions,
Functions Arrays.
 This course will teach students
students, How to develop workflows going from raw data to graphics
and statistical analysis, Using the Programming Language and Statistical Environment R.
R
 Over the Course of the Semester
Semester, Students will Learn the Skills to Write Scripts to
automate data formatting and analysis
analysis, making their studies replicable.
 Student will be able Apply Programming Knowledge to Develop R Programs Based
onSimulation.
COURSE OUTCOMES:
 Learn and apply the features ofR Programming Tool to Carry out Statistical Analysis of data
 Write, Compile and Execute the Programs Written in R Programming Language
 Implement Intelligent Algorithms in R to Solve Statistical and Decision Making Problems
Prob

COURSE OUTCOME:

1. Understand the basics in R programming in terms of constructs

constructs, control statements,
statements string
functions
2. Understand the use of R for Big Data analytics
3. Learn to apply R programming for Text processing
4. Able to appreciate and apply the R programming from a statistical perspective

UNIT -WISE SYLLABUS

UNIT - I
OVERVIEW— Evolution of R, Features of R
ENVIRONMENT SETUP— Try it Option Online
Online, Local Environment Setup
BASIC SYNTAX—R
R Command Prompt
Prompt, R Script File, Comments
DATA TYPES—Vectors, Lists, Matrices
Matrices, Arrays. , Factors, Data Frames
VARIABLES—Variable
Variable Assignment
Assignment, Data Type of a Variable, Finding Variables,
Variables Deleting
Variables
OPERATORS—Types
Types of Operators
Operators, Arithmetic Operators, Relational Operators,
Operators Logical
Operators, Assignment Operators
Operators, Miscellaneous Operators
DECISION MAKING—If
If Statement
Statement, If- Else Statement, The if. else if. else Statement,
Statement Switch
Statement

Page 81 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

LOOPS—Repeat Loop, While Loop

Loop, For Loop, Loop Control Statements, Break Statement,
Statement Next
Statement
UNIT - II
FUNCTION—Function Definition ition, Function Components, Built- In
n FunctionUser-defined
FunctionUser
Function, Calling a Function, Lazy Evaluation of Function
STRINGS—Rules
Rules Applied in String Construction
Construction, String Manipulation
VECTORS—Vector Creation, Accessing Vector Elements
Elements, Vector Manipulation
LISTS—Creating a List, Naming List Elements
Elements, Accessing List Elements, Manipulating List
Elements, Merging Lists, Converting List to Vector
MATRICES—Accessing
Accessing Elements of a Matrix
Matrix, Matrix Computations
ARRAYS—Naming
Naming Columns and Rows Rows, Accessing Array Elements, Manipulating Array
Elements, Calculations Across Array Elements
Elements,
FACTORS—Factors
Factors in Data Frame
Frame, Changing the Order of Levels, Generating Factor Levels
DATA FRAMES—Extract
Extract Data from Data Frame
Frame, Expand Data Frame
UNIT - III
PACKAGES – Introductions,
ns, Uses, Install R Package
DATA RESHAPING, —Joining
Joining Columns and Rows in a Data Frame
Frame, Merging Data Frames,
Frames
Melting and Casting, Melt the Data
Data, Cast the Molten Data
CSV FILES—Getting
Getting and Setting the Working Directory
Directory, Input as CSV File, Reading a CSV File,
File
Analyzing the CSV File, Writing into a CSV File
EXCEL FILE—Install
Install xlsx Package
Package, Verify and Load the "xlsx" Package, Input as xlsx File,
File
Reading the Excel File, 21. BINARY FILES
FILES, Writing the Binary File, Reading the Binary File,
File
XML FILES, Input Data, Reading XML File
File, Details of the First Node, XML to Data Frame
JSON FILE—Install
Install rjson Package
Package, Input Data, Read the JSON File, Convert JSON to a Data
Frame
WEB DATA
DATABASES—RMySQL
RMySQL Package
Package, Connecting R to MySql, Querying the Tables,
Tables Query with
Filter Clause, Updating Rows in the Tables
Tables, Inserting Data into the Tables, Creating Tables in
MySql, Dropping Tables in MySql
UNIT - IV
PIE CHARTS—Pie
Pie Chart Title and Colors
Colors, Slice Percentages and Chart Legend,, 3D Pie Chart,
BAR CHARTS—Bar
Bar Chart Labels
Labels, Title and Colors, Group Bar Chart and Stacked Bar Chart
BOXPLOTS—Creating
Creating the Boxplot
Boxplot, Boxplot with Notch,
HISTOGRAMS—Range
Range of X and Y values
LINE GRAPHS—Line Chart Title,, Color and Labels, Multiple Lines in a Line Chart
SCATTERPLOTS—Creating
Creating the Scatterplot
Scatterplot, Scatterplot Matrices
UNIT - V
MEAN, MEDIAN & MODE—Mean
Mean, Applying Trim Option, Applying NA Option, Median,
Median Mode
LINEAR REGRESSION—Steps
Steps to Establish a Regressionlm() Functionpredict() Function
MULTIPLE REGRESSION—lm()
lm() FunctionExample
LOGISTIC REGRESSION—Create
Create Regression Model
NORMAL DISTRIBUTION—dnorm()pnorm()qnorm()rnorm()
dnorm()pnorm()qnorm()rnorm()

Page 82 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

BINOMIAL DISTRIBUTION—dbinom()
dbinom() pbinom() qbinom() rbinom()
Poisson Regression, Analysis off Covariance
TIME SERIES ANALYSIS—Different
Different Time Intervals
Intervals, Multiple Time Series
Nonlinear Least Square, Decision Tree Install R Package
RANDOM FOREST—Install
Install R Package
Package, Survival Analysis, Chi Square Test

TEXT &REFERENCE BOOKS

 The Art of R Programming: A Tour of Statistical Software Design

Design, by Norman Matloff,
Matloff No
Starch Press, 2011
 R for Everyone:
e: Advanced Analytics and Graphics by Jared P
P. Lander, Addison-Wesley
Addison
Data & Analytics Series, 2013
2013.
 Beginning R – The Statistical Programming Language
Language, by Mark Gardener,, Wiley, 2013
 Introductory R: A Beginner's Guide to Data Visualisation
Visualisation, Statistical Analysis
alysis and
Programming in R, by Robert Knell
Knell, Amazon Digital South Asia Services Inc,
Inc 2013
 W. N. Venables, D. M. Smith
Smith, an introduction to R, r-core team, 2015
 Alain F. Zuur, Elena n. Ieno
Ieno, and Erik Meesters. A beginner’s guide to R. Use R.
Springer, 2009. ISBN: 978--0-387-93836-3.
 Roger D. PengR Programming for Data Science
Science, , https://leanpub. com/rprogramming
 John Verzani, chapman -Using
Using R for introductory statistics
statistics, , ISBN- 1584884509
 Https://www. r-project. org/doc/bib/r
org/doc/bib/r-books. html

LIST OFPRACTICAL

1. Write a program that prints ‘Hello World’ to the screen

screen.
2. Write a program that asks the user for a number n and prints the sum of the numbers
1 to n.
3. Write a program that prints a multiplication table for numbers up to 12.
12
4. Write a function that returns tthe largest element in a list.
5. Write a function that computes the running total of a list
list.
6. Write a function that tests whether a string is a palindrome
palindrome.
7. Implement the following sorting algorithms: Selection sort
sort, Insertion sort,
sort Bubble Sort.
8. Implement linear search..
9. Implement binary search
search.
10. Implement matrices addition
addition, subtraction and Multiplication.

Page 83 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCASEC(B) - INTERNET OF THINGS

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVES
 To impart necessary and practical knowledge of components of Internet of Things
 To introduce the latest microcontrollers with application development
development, productdesign and
prototyping.
 Learn and Understand Various Protocols used in Wireless Sensor Network
Network..
 Develop
evelop skills required to build real
real-life IoT based projects
COURSE OUTCOMES
 Understand the Concepts of Internet of Things and the Application Areas of IoT
 Understand IOT’s hardware and software components
 Interface I/O devices, sensors & communication modules
 Remotely monitor data and control devices
 Develop real life IoT based projects

UNIT – WISE SYLLABUS

UNIT-I
Introduction to IoT, Architectural Overview
Overview, Design principles and needed capabilities,
capabilit IoT
Applications, Sensing, Actuation
Actuation, Basics of Networking, M2M and IoT Technology
Fundamentals- Devices andgateways
andgateways, Data management, Business processes in IoT, IoT
Everything as a Service(XaaS), Role ofCloud in IoT
IoT, Security aspects in IoT.
UNIT-II
Elements of IoT, Hardware Components
Components- Computing (Arduino, Raspberry Pi),, Communication,
Sensing, Actuation, I/O interfaces
interfaces.
Software Components- Programming API’s (using Python/Node
Python/Node. js/Arduino) for
communicationProtocols-MQTT,, ZigBee, Bluetooth, CoAP, UDP, TCP.
UNIT-III
IoT Application Development:: Solution framework for IoT applications- Implementation of
Device integration, Data acquisitionand integration
integration, Device data storage- Unstructured data
storage on cloud/local server, Authentication
Authentication, authorization of devices.
UNIT-IV
IoT case studies and mini projects based on Home Automation
Automation, Industrial automation,
automation
Transportation etc.
UNIT-V
IoT case studies and mini projects based on Agriculture
Agriculture, Healthcare, logistics etc.

Page 84 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

TEXT & REFERENCE BOOKS

 Vijay Madisetti,
i, Arshdeep Bahga, Ïnternet of Things, “A Hands on Approach”, University
Press
 Dr. SRN Reddy, Rachit Thukral and Manasi Mishra, “Introduction to Internet of Things: A
practical Approach”, ETI Labs
 Pethuru Raj and Anupama C. Raman, “The Internet of Things: Enabling Technologies,
Platforms, and Use Cases”, CRC Press
 Jeeva Jose, “Internet of Things”, Khanna Publishing House, Delhi
 Adrian McEwen, “Designing the Internet of Things”, Wiley
 Raj Kamal, “Internet of Things: Architecture and Design”, McGraw Hill
 Cuno Pfister, “Getting Started with the Internet of Things”, O Reilly Media

LIST OF PRACTICALS

 Familiarization with Arduino/Raspberry Pi and perform necessary software installation.

installation
 To interface LED/Buzzer with Arduino/Raspberry Pi and write a program to turn ON
LEDfor 1 sec after every 2 seconds
seconds.
 To interface Push button/Digital sensor (IR/LDR) with Arduino/Raspberry Pi and write
aprogram to turn ON LED when push button is pressed or at sensor detection.
detection
 To interface DHT11 sensor with Arduino/Raspberry Pi and write a program to
printtemperature and humidity readings
readings.
 To interface motor using relay with Arduino/Raspberry Pi and write a program to turn
ONmotor when push button is pressed
pressed.
 To interface OLED with Arduino/Raspberry Pi and write a program to print temperature
andhumidity readings on it..
 To interface Bluetooth with Arduino/Raspberry Pi and write a program to send sensor
datato smartphone using Bluetooth
Bluetooth.
 To interface Bluetooth with Arduino/Raspberry Pi and write a program to turn LED
ON/OFFwhenhen ‘1’/’0’ is received from smartphone using Bluetooth
Bluetooth.
 Write a program on Arduino/Raspberry Pi to upload temperature and humidity data
tothingspeak cloud.
 Write a program on Arduino/Raspberry Pi to retrieve temperature and humidity data
fromthingspeak cloud.
 To install MySQL database on Raspberry Pi and perform basic SQL queries
queries..
 Write a program on Arduino/Raspberry Pi to publish temperature data to MQTT broker.
broker
 Write a program on Arduino/Raspberry Pi to subscribe to MQTT broker for temperature
dataand print it.
 Write a program to create TCP server on Arduino/Raspberry Pi and respond with
humiditydata to TCP client when requested
requested.
 Write a program to create UDP server on Arduino/Raspberry Pi and respond with
humiditydata to UDP client when reque
requested.

Page 85 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCASEC(C) - USER INTERFACE DESIGN

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 0 10 40 50

COURSE OBJECTIVS
 To Understand Importance of Good Interface Design.
 To Know evaluation process in User Interface Design.
 To Indentify design issues in Virtual Environment.
 To Know basic interface design issues for various environment
environment.
 To Know documentation and Online help in UID.
COURSE OUTCOMES
 The Student will gain
ain insight into the basic theories in user
user-centered
centered interaction design.
 Analyze the new technologies that provide interactive devices and interfaces.
 Apply the guidelines to develop the UID
UID, development methodologies with an analysis of the
social impact.
 Understand Direct Manipulation and Virtual Environment
 Persuade user documentations and information search.

UNIT-WISE SYLLABUS

UNIT - I
Introduction, Importance of User Interface Design
Design, Good and Bad Design, principles of UID,
UID
Usability of Interactive Systems:
stems: Introduction
Introduction, Usability Goals and Measures,
Measures Usability
Motivation, Universal Usability
Usability, Managing Design Processes: Introduction,
Introduction Organizational
Design to support Usability,, The Four Pillars of Design, Development methodologies:
Ethnographic Observation, Participatory Design
Design, Scenario Development,, Social Impact
statement for Early Design Review.
UNIT - II
Evaluating Interface Design - Introduction
Introduction, Expert Reviews, Usability Testing and Laboratories,
Laboratories
Survey Instruments, Acceptance tests
tests, Evaluation during Active Use, Controlled Psychologically
Oriented Experiments
UNIT- III
Direct Manipulation and Virtual Environments:Introduction
Environments:Introduction, Examples of Direct Manipulation,
Manipulation
Discussion of direct manipulation
manipulation, 3D Interfaces, Tele-operation, Virtual and Augmented
Reality Menu Selection, Form Filling and Dialog Boxes: Introduction
Introduction, Task-Related
Task Menu
Organization, Single Menus, Combination of Multiple Menus
Menus, Content Organization,
Organization Fast
Movement Through Menus, Data Entry With Menus Menus, Form Filling, Dialog Boxes and
Alternatives, Audio Menus and Menus for Small Displays
UNIT - IV

Page 86 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

Design Issues : Quality of Service: Introduction

Introduction, Models of Response-Time
Response Impacts,
Expectations and Attitudes, User Productivity
Productivity, Variability in Response time,
time Frustrating
Experiences Balancing
ng Function and Fashion: Introduction
Introduction, Error Messages,
Messages
Nonanthropomorphic Design, Display design
design, Mobile andweb page design,, Window Design,
Color
UNIT - V
User Documentation and Online Help :Introduction, Online versus paper documentation,
documentation
Reading from paper
er versus Displays
Displays, Shaping the content of the Manuals,
Manuals Accessing the
Documentation, Online Tutorials
and animated demonstrations,, Online Communities for User Assistance, The Development
Process.
Information Search and Visualization
Introduction, Search in Textual Documents and Database Querying
Querying, Multimedia document
searches, Advanced filtering and Search Interfaces
Interfaces, Information Visualization: Introduction,
Introduction
Data tyoe by task taxonomy, Challenges for information visualization.

TEXT&REFERENCE BOOKS

 Ben Shneiderman, Plaisant,, Cohen, Jacobs: Designing the UserInterface,, 6th Edition,
Pearson, Education.
 About Face The essentials of User Interface Design Alan Coopar.
 Don’t Make me Think Steve Crug
 Wilber O Galitz: The Essential Guide to User Interface Design Wiley publication.
 Alan Dix, Janet Finalay, Gregory D AbiwdmRusselBealel: Human
Human-Computer
Computer Interaction,
Interaction
III Edition, Pearson, Education
Education, 2008.
 Eberts: User Interface Design
Design, Prentice Hall, 1994

PRACTICAL LIST (ADOB

(ADOBE XD LIST OF EXPERIMENTS)

1. Design a Menu Screen.

2. Prototype design Login page.
3. Build multiple screens of different sizes.Create a transition between screens
4. Design a Welcome Splash Screen.
5. Design e commerce site of minimum 3 Page with
a. Create and import graphics
b. Add text and effects
c. Create multiple screen layouts
d. Designed for mobile
e. Use grid repeating elements
6. Create a sign up page, modal
modal, form, or app screen related to signing up for something. It
could be for a volunteer event
event, contest registration, a giveaway, or anything you can image.
7. Design a calculator.
alculator. Standard
Standard, scientific, or specialty calculator for something such as a
mortgage? Is it for a phone, a tablet
tablet, a web app?

Page 87 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

8. Design a credit card checkout form or page. Don’t forget the important elements such as
the numbers, dates, security numbers
numbers, etc.

Page 88 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCAOE(A) - SOCIAL MEDIA MINING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 Provide a strong foundation knowledge in social media mining, and Understand the
importance of social media mining
 Learn the various features of python tool for social media data mining.
 Provide the basic knowledge of graph theory to represent social media data.
 Learn and understand the basic concepts of data mining, such as Knowledge Discovery in
Databases (KDD), Data Quality
Quality, Data Preprocessing
 Understand the Supervised Learning and Unsupervised Learning algorithm
COURSE OUTCOMES
 Explain basic concepts of data mining of social media and its importance.
 Apply python tool for social media data mining.
 Explain the Knowledge Discovery in Databases (KDD)
(KDD), Data Quality, Data Preprocessing
 Collect and preprocess the data of social media and identify the pattern and
association/friendships, analyze behavior
behavior, perform recommendations, classify user profile
using Supervised Learning and Unsupervised Learning algorithm.
 Analyze data from data from social media and provide relevant information for business
development, product reviews
reviews, Find and analyze communities in social media,
media trend
ofinformation propagation in social media

UNIT-WISE SYLLABUS

UNIT I
Social Media – introduction, challenges and opportunities
opportunities, Social Media Mining,
Mining Python tools
for data science
UNIT II
Graph Essentials, Graph Basics
Basics- Nodes, Edges and Degree, Graph Representation,
Representation Types of
Graphs, Connectivity in Graphs
Graphs-Walk, Path, Trail, Tour and Cycle, Trees and Forests,
Forests
Graph/Tree Traversal- Depth-First
First Search (DFS) and Breadt
Breadth-First
First search (BFS),
(BFS) Shortest Path
Dijkstra’s Algorithm
UNIT III
Network Measures, Centrality-Degree
Degree Centrality
Centrality, Transitivity and Reciprocity,
Reciprocity Balance and
Status, Similarity- Structural Equivalence
Equivalence, Properties of Real-World Networks
UNIT IV
Data Mining- Knowledge Discovery in Databases (KDD) (KDD), Dataset, Data Quality,
Quality Data
Preprocessing, Supervised Learning
Learning- Naive Bayes Classifier, Unsupervised Learning,
Learning distance
measure, Partitional Algorithm- K-means algorithm

Page 89 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

UNIT V
Community Analysis, Social Communities
Communities, Community Detection Algorithms,
Algorithms Member-Based
Community Detection- Node Degree
Degree, Node Reachability, Node Similarity
Information Diffusion in Social Media
Media, Elements of diffusion process, intervention,
intervention Local and
Global Dependence, introduction of information diffusion types

TEXT &REFERENCE BOOKS

 Reza Zafarani, Mohammad Ali Abbasi

Abbasi, Huan Liu, Social Media Mining: An Introduction,
Introdu
Cambridge University Press
 Marco Bonzanini, Mastering Social Media Mining with Python, Packt Publishing,
Publishing ISBN
978-1-78355-201-6
 Matthew A. Russell, Published
Published, Mining the Social Web, O’Reilly Media, Inc.,
Inc. ISBN: 978-1-
449-36761-9

Page 90 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCAOE(B) - SERVICE ORIENTED ARCHITECTURE

HITECTURE

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 To learn fundamentals of XML
 To provide an overview of Service Oriented Architecture and Web services and their
importance
 To learn web services standards and technologies
 To learn service-oriented analysis and design for developing SOA based applications
COURSE OUTCOMES
 Understand XML technologies
 Understand service orientation, benefits of SOA
 Understand web services and WS standards
 Use web services extensions to develop solutions
 Understand and apply service modeling, service
service-oriented
oriented analysis and design for
application development

UNIT-WISE SYLLABUS

UNIT I
XML: XML document structure – Well-formed and valid documents – DTD – XML Schema –
Parsing XML using DOM, SAX – XPath – XML Transformation and XSL – Xquery
UNIT II
SERVICE ORIENTED ARCHITECTURE (SOA) BASICS: Introduction - Fundamental SOA, SOA
Characteristics of contemporary SOA
SOA, Misperception about SOA,, Comparing SOA with Client-
Client
Server and Distributed architectures, Tangible benefits of SOA, An SOA timeline,
timeline Continuing
evolution of SOA, Roots of SOA Service orientation and object
object-orientation,, SOA Standards
Stack, SOA with Web Services, Key Principles of SOA
SOA, Service layers
UNIT III
WEB SERVICES (WS) AND STANDARDS: Web Services Platform – Service descriptions – WSDL
– Messaging with SOAP – Service discovery – UDDI – Service-Level
Level Interaction Patterns –
Orchestration and Choreography
UNIT IV
WEB SERVICES EXTENSIONS: WS-** Specifications: Message Exchange Pattern,
Pattern Coordination,
Atomic Transactions, BusinessActivities
BusinessActivities, Orchestration, Choreography, WS-Addressing
Addressing, WS-
Reliable Messaging, WS-Policy
Policy (including WS
WS-Policy Attachments and WS-Policy
Policy Assertions),
Assertions)
WS-Metadata Exchange, WS-Coordination
Coordination – WS -Transactions , WS-Security
Security (including XML-
XML
Encryption, XML-Signature, and SAML)
SAML), various examples

Page 91 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

UNIT V
SERVICE ORIENTED ANALYSIS AND DESIGN: Service Life Cycle, Service Creation, Service
Design and Build, Service Deployment, SOA delivery strategies – Service oriented analysis –
Service Modelling – Service oriented
riented design – Standards and composition guidelines — Service
design – Publish Web service, Business process design – Case Study

TEXT&REFERENCE BOOKS

 Thomas Erl, ― Service Oriented Architecture: Concepts, Technology, and Design,

Pearson Education, 2005
 Sandeep
andeep Chatterjee and James Webber, ―Developing Enterprise Web Services: An
Architect’s Guide, Prentice Hall, 2004
 James McGovern, Sameer Tyagi, Michael E Stevens, Sunil Mathew, ―Java Web Services
Architecture, Elsevier, 2003.
 Ron Schmelzer et al. ― XML a
and
nd Web Services, Pearson Education, 2002.
 Frank P. Coyle, ―XML, Web Services and the Data Revolution, Pearson Education, 2002

LIST OF PRACTICAL

1. Develop DTD and XSD for University Information System having exam enrollment from
beginning of semester, along with exam registration and marks submission by teachers to
university from various colleges and results sheets generation by University on online
report
2. Develop Mark sheet XML Document and display Mark sheet based on CSS and XSL
presentation Format
3. Develop Java based program using JAXP or XML API in reading XML file for Students
Information and Display HTML Table
4. Develop Java Based web Service using REST and SOAP Based web service in Netbeans for
University Course List and Search Course based Cours
Coursee Title and Course ID
5. Create DTD file for student information and create a valid well
well-formed
formed XML document to
store student information against this DTD file
file.
6. Create XMS schema file for student information and create a valid well-formed
well XML
document to store
ore student information against this DTD file
file.
7. Create web calculator service in
in. NET Beans and create Java client to consume this web
service.
8. Develop same web service using JX
JX-WS
9. Create web calculator service in
in. NET and Pr. 9 Create java client to consume web service
developed using Apache AXIS
AXIS.
10. Using WS –GEN and WS- Import
mport develop the java web service & call it by Java Client.
Client

Page 92 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

3MCAOE(C) - SOFTWARE TESTING AND QUALITY ASSURANCE

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 1 0 3 40 10 0 50

COURSE OBJECTIVES
 Understand, Learn and Apply the Theoretical and Practical Knowledge of Software Testing.
 Introduce Quality Models,, Factors Affecting Quality, Various Characteristics and
Relationship, Quality Metrics
Metrics, Estimation Techniques, Quality Assurance and Control,
Control and
Certification.
 Understand, Learn and Analyze the Code by Applying Code Inspection,
Inspection Review and
Structured Walkthrough Approaches for Static Testing Software Product.
 Understand the Key Concepts of Software Testing Such as Types Types,, Levels, Process,
Strategies and Metrics of Software Testing and Defect Management.
 Learn the Various Testing Techniques and Hands on Testing Tool for Designing,
Designing Exercising
the Test Case onset and Auditing the Results.
 Introduce, Understand and Learn Features and Working of Various Tools of Software
Testing and Apply on Different Software Artifacts.
COURSE OUTCOMES
 Explain and Apply Knowledge of Key Concepts of Software Testing
Testing, Quality and Testing
Tools.
 Draw the DD Graph and Identify the Various Test Cases from Paths of Flow Graph of
Software Testing Problem and Determine the Complexity of Software.
 Design Test Cases and Develop Test Suite
Suite, Write Test Scripts, Set Environmental
Environmenta Variables
for Carrying Out the Various Levels of Testing Manually and Automatically.
 Manage Software Defects, and Risks Within a Software Project.
 Work Effectively in Profile of Software Tester
Tester, Quality Assurance and Control officer,
officer Project
Manager and Leaders.

UNIT-WISE SYLLABUS

UNIT-I
Software Testing Process, Objectives
Objectives, Testing Techniques, Software Testing Life Cycle,
Cycle Concept
of Testing, Types of Errors, Stubs and DriversVerification and Validation
Validation, Different Types of
Verification & Validations Mecha
Mechanisms, Concepts of Software Reviews, Code Inspection and
Code Walkthrough, Testingof Component Based Software System System, Energy Efficient Testing,
Testing
Mobile Application Testing.
UNIT-II
Software Testing Methods, Testing Fundamentals
Fundamentals, Test Case Design, White Box Testing and its
Types, Black Box Testing and its Types
Types, Software Testing Strategies, Strategic Approach to
Software Testing, UNIT Testing,, Integration Testing, Validation Testing, System Testing,
Testing Test
Planning, Budgeting and Scheduling.

Page 93 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - III

UNIT-III
SoftwareTesting Metrics, Concept and Developing Testing Metrics
Metrics, Different Types of Metrics,
Metrics
Complexity Metrics, Defect Management
Management, Definition of Defects, Defect Management Process,
Process
Defect Reporting, Metrics Related to Defects
Defects, Using Defects for Process Improvement.
provement.
UNIT-IV
Software Quality, Factors Affecting Software Quality
Quality, Quality Models, Software Quality
Estimation, Quality Metrics, Quality Assurance
Assurance, SQA Activities, Software Reviews,
Reviews Formal
Technical Reviews, Quality ControlQuality Management
Management, and, SQA A Plan. Quality Improvement,
Improvement
Pareto Diagrams, Cause-Effect
Effect Diagrams
Diagrams, Scatter Diagrams, Run Charts,
Charts Total Quality
Management, Statistical Quality Assurance
Assurance, Software Reliability, the ISO 9001 Quality
Standard, Six Sigma, Informal Reviews.
UNIT-V
Quality Costs, Quality Cost Measurement
Measurement, Utilizing Quality Costs for Decision--Making. Manual
Vs Automatic Testing, Basics of Automated Testing
Testing, Drawback of Manual Testing,
Testing Advantages
of Automation of Testing, Factors for Automation Testing
Testing, Types Automation of Testing
Testin Tools,
Introduction to QTP, QTPIDE,, Basic Components in QTP, QTP Framework,
Framework Write Scripts,
Introduction to Winrunner, and Rational Robot.

TEXT &REFERENCE BOOKS

 Roger S. Pressman, Software Engineering – a Practitioners Approach, McGraw Hill

Education;1 April 2009.
 K.K. Aggarwal&Yogesh Singh
Singh, “Software Engineering”, New Age International Publishers,
Publishers
New Delhi, 2005.
 KshirsagarNaik, PriyadarshiTripathy
PriyadarshiTripathy, Software Testing and Quality Assurance Theory and
Practice, Wiley-Spektrum;August
Spektrum;August 1818, 2008.
 Donna C. S. Summers, Quality Management
Management, Pearson; April 26, 2008
 Yogesh Singh, Software Testing
Testing, Cambridge University Press, 2012
 William Perry, “Effective Methods for Software Testing”
Testing”, John Wiley & Sons,
Sons New York,
1995
 Louise Tamres, “Software Testing”
Testing”, Pearson Education Asia, 2002
 CemKaner, Jack Falk, Nguyen Quoc
Quoc, “Testing Computer Software”, Second Edition,
Edition Van
Nostrand Reinhold, New York
York, 1993.
 Boris Beizer, “Black-Box
Box Testing – Techniques for Functional Testing of Software and
Systems”, John Wiley & Sons Inc.
Inc., New York, 1995.

Page 94 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

SEMESTER-IV
4MCACCC1 - CLOUD COMPUTING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 3 0 4 5 50 20 30 100

COURSE OBJECTIVES
 To get Introduced to various Computing Paradigms
 To Learn Fundamentals of Cloud Computing and managements.
 To Know Various Cloud Computing Technologies
 To Understand and implement Virtualization
 To study Technological Drivers for Cloud Computing
 To learn Data Storage in Cloud
 To Learn Elements and Services in Cloud Computing
 To Learn and implement Application Platform for Cloud Applications.
 To understand Various Cloud Services.
 To Know and implement
ment Tools of Cloud Computing
COURSE OUTCOMES
 Describe the Key concepts, Advantages
Advantages, Limitations and Applications of Cloud Computing
 Explain the various Models and services of Cloud.
 Understand and Describe the Core Issues and challenges of cloud computing Such as
Security, Privacy, and Interoperability.
 Select and Apply Suitable Technologies
Technologies, Tools and Applications in the Cloud Computing
Driven Systems
 Design and develop the efficient solutions of the Cloud Computing problems and issues
with consideration
ideration of environment and sustainable development.
 Analyze the interface requirement for deploying the Applications in Cloud

UNIT-WISE SYLLABUS

UNIT – I
Introduction to Computing Paradigms
Paradigms: High-Performance Computing, Parallel Computing,
Computing
Distributed Computing, Cluster Computing
Computing, Grid Computing, Cloud Computing,
Computing
Biocomputing, Mobile Computing
Computing, Quantum Computing, Optical Computing, Nano-computing,
Nano
Network Computing.
Cloud Computing Fundamentals:Motivation
Fundamentals:Motivation, Need, Definition, Principles, Characteristics,
Characteristics Four
Cloud Deployment Models, Three Service Offering Models
Models, Cloud Ecosystem, Requirements for
Cloud Services, Cloud Computing Architecture
Architecture- User/Client Layer, Network Layer,
Layer Cloud
Management Layer, Hardware Resourc
Resource Layer, Network Connectivity in Cloud Computing,
Compu
Public Cloud Access Networking
Networking, Private Cloud Access Networking.

Page 95 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

UNIT – II
Cloud Computing Management:Cloud Application
Applications, Managing the Cloud, Managing the Cloud
Infrastructure, Managing the Cloud Application
Application, Migrating Application to Cloud,
Cloud Cloud
Deployment Models: Private Cloud,
oud, Outsourced Private Cloud, Community Cloud,Clou On-Premise
Community Cloud, Hybrid rid Cloud. Cloud Service Models
Models:Infrastructure
e as a Service, Platform as
a Service, Software as a Service,, Introduction to Open Source Tools for IaaS, Paas& SaaS.
UNIT – III
Technological
cal Drivers for Cloud Computing
Computing:SOA and Cloud, SOA and SOC,, Benefits of SOA,
Multicore Technology:Multicore Processors and VM Scalability
Scalability, Memory and Storage
Technologies, Cloud Storage Requirements
Requirements, Networking Technologies, Web 2.0:Characteristics,
2.0:Characteristics
Difference from Web 1.0,, Applications, Social Media, Marketing, Education, E Web
3.0:Components, Semantic Web
Web, Web Services, Characteristics, Convergence of Cloud and Web
4.0, Connecting
onnecting Information: Facebook, Agile Software Models: els: Agile SDLC for Cloud
Computing, Features of Cloud SDLC
SDLC, Agile Software Development Process, Advantages of Agile,
Agile
Cloud Application Development Platforms:Windows Azure
Azure,, Google App Engine, Forcecom, IBM
Cloud Computing API
UNIT – IV
Virtualization: Full Virtualization
Virtualization, Para virtualization, Hardware-Assisted
Assisted Virtualization,
Virtualization
Hypervisor, OS S Virtualization
Virtualization, Server Virtualization, Memory Virtualization,
Virtualization Storage
Virtualization, Network Virtualization
Virtualization, Application Virtualization, Processor Virtualization,
Virtualization
Memory Virtualization, Storage Virtualization
Virtualization, Network Virtualization, Data Virtualization,
Virtualization
Application Virtualization, Hypervisors
Hypervisors, Types of Hypervisors, Security Issues and
Recommendations, From Virtualization to Cloud Computing
Computing, VMware, Microsoft Hyper-V,
Hyper Open
Virtualization (Ovirt) overview
UNIT – V
Cloud Service Providers: EMC, EMC ITIT, Captiva Cloud Toolkit, Google, Cloud Platform,
Platform Cloud
Storage, Google Cloud Connect,, Google Cloud Print, Google App Engine, Amazon Web Services,
Services
Amazon Elastic Compute Cloud
Cloud, Amazon Simple Storage Service, Amazon Simple Queue
Service, Microsoft Azure, Microsoft Assessment and Planning Tool Toolkit,
kit, SharePoint, IBM
SmartCloud, Security in Cloud Compu
Computing, Cloud General Challenges.

TEXT &REFERENCE BOOKS

 Essentials of CLOUD COMPUTING,

UTING, K Chandrasekaran, CRC Press [ISBN: 3: 978--4822-
978
0544-2 ]
 Raj Kumar Buyya, James Broberg, and RezeiM Goscinski
Goscinski- Cloud Computing: Principles
and Paradigms-Wiley.
 Srinivasan, J.Suresh, -Cloud
Cloud Computing – A Practical Approach for Learning and
Implementation,
tion, Pearson India, [ISBN 978131776513]
 Toby Velte, Anthony Velte, Robert Elsenpeter
Elsenpeter- Cloud Computing, A Practical Approach -
McGraw Hill, ISBN: 0071626948
 Greg Schulz -Cloud
Cloud and Virtual Data Storage Networking, Auerbach Publications, ISBN:
978-1439851739.
 Marty Poniatowski- Foundations of Green IT, ISBN: 978
978-0137043750.
 Learning Spring Application Development, Ravi Kant Soni, Packt Publishing.

Page 96 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

 Michael Miller, Cloud Computing.

 Judith Hurwitz, Robin Bllor, Marcia Kaufman, Fern Halper, Cloud Computing for
Dummies.
 Borko Furht, Armando Escalante, Handbook of Cloud Computing, Springer, 2010.
2010

LIST OF PRACTICAL

Suggested Practical for development of applications for following tasks/tools:

 Install Virtual Machine
 Create Virtual Machine
 Manage Virtual Machine Images
ages
 Installing and Configuring Ovirt
 Creating Managing Datacenters and Clusters
 Adding Physical Hosts (Configure Hypervisors)
 Managing User Accounts and Roles
 Managing Red Hat Virtualization Storage
 Deploying and Managing Virtual Machines
 Managing Virtual Machine Images
 Automating Virtual Machine Deployment

Page 97 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCACCC2 - PROJECT WORK

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CC 0 2 6 5 0 20 80 100

4MCACCC2 - PROJECT WORK - PROJECT GUIDELINES FOR

OR MCA

WILL BE ANNOUNCED AT THE STARTING OF THIRD

D SEMESTER

Page 98 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCACCE(A) - MANAGEMENT THEORY & PRACTICES

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 5 0 0 5 80 20 0 100

COURSE OBJECTIVES
 To help the students gain understanding of the functions and responsibilities of managers.
 To provide them fundamental knowledge of Management theories and take cognizance of
the importance of management principles.
 Acquire the knowledge of different Planning, strategies, decision making and forecasting
techniques and implement them to solve organizational problems
problems.
 Learn and develop the management skills such communication, presentation, leadership
and motivation
otivation skills for team building
building.
 To help the students to learn budgetary control, inventory control and quality control
Theory with the help of case study.
COURSE OUTCOMES
 Explain the fundamental knowledge of Management theories and practice them to
investigate and solve the organizational.
 Design, Develop and Implement Plans and Strategies, and take decisions to solve
organizational problems.
 Demonstrate the management skills through effective communication, presentation,
leadership skills and motiv
motivate
ate team members for obtaining targets of organization and
individual team member.
 Explain and apply budgetary control, inventory control and quality control Theory with the
help of case study.

UNIT-WISE SYLLABUS

UNIT–I
Management practices- Meaning and FFunctions, Development of Management Thought,
Thought F.W.
Taylor andHerryFayol’s Theories of Management
Management, Qualities of an Efficient Management,
Management
Management Principles of Modern Times (Empowerment
(Empowerment, Kaizen, Quality Circles,
Circles and Total
Quality Management.
UNIT–II
Planning-Plan, policies, strategies and programs
programs, steps in planning & decision making,
making
forecasting, qualities of an effective planner
planner, relevant case study
UNIT–III
Organizing-Organizational
Organizational Design
Design, Organizational Structure, Centralization & Decentralization,
Decentralization
Delegation, Gantt chart and PERT/CPM
PERT/CPM, Relevant Case Study

Page 99 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

UNIT–IV
Directing-Motivation
Motivation and teambuilding
teambuilding, theories of motivation, factors affecting motivation.
Leadership, leadership styles, theories of leadership
leadership, qualities of an effective leader,
leader effective
communication and presentation skills
skills, relevant case studies

UNIT-V
Controlling Meaning and basic principles
principles, types of controls, budget and budgetary control,
control
inventory control and quality control relevant case studies.

TEXT &REFERENCE BOOKS

 Joseph L. Massie, Essentials of Management

Management, Prentice Hall of India
 BiswajeetPatanayak, Human Resource Management
Management, Prentice Hall of India
 Gomes-Mejia, Balkin& Hardy
Hardy, Managing Human Resource, Prentice Hall of India
 Lesslic W. RueLlyodByurs, Management
Management, Tata McGraw Hill
 Joseph M. Putti, Harold Koontz
Koontz, Essentials of Management, An Asian Perspective,
Perspective Tata
McGraw hill
 David Boddy, Management: An Introduction
Introduction, , Pearson
 Laurie J. Mullins with Gill Christy
Christy, Management&OrganisationalBehaviour,, Pearson

Page 100 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCACCE(B) - ARTIFICIAL
FICIAL INTELLIGENCE & MACHINE LEARNING

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 4 0 2 5 80 20 0 100

COURSE OBJECTIVES
 To Understand the Concepts of Artificial Int
Intelligence
elligence and Machine Learning such as
supervised and unsupervised learning, knowledge representation, Possibility and
probability theory and also get update about current and futuristic trends of AI problems
and solutions.
 To Gain Knowledge of search spa space
ce and search strategies, different algorithms of
Supervised and Unsupervised Learning
 Understand the various architectures and activation functions, training and testing
approach used in Artificial Neural Network and also acquire knowledge of expert systems.
syste
 Understand the concepts of Fuzzy Logic, Genetic Algorithms, and applythem to solve the
real-life problems.
COURSE OUTCOMES
 Demonstrate Artificial Intelligence Techniques
Techniques, Various Types of Production Systems,
Systems and
Characteristics of Production Systems.
 Design and implement Neural Networks usinglayers, various activation functions
f and
Various Algorithms to solve real life problems.
 Analyze fuzzy nature problem and Design, implement and test the Fuzzy Inference Systems
for vague nature real life problem
problem.
 Explain
xplain Genetic Algorithms theory, Design and validate the Genetic Algorithms based
systems for search space driven problems.

UNIT-WISE SYLLABUS

UNIT-I
AI Introduction, The AI problems
problems, AI technique, Characteristics of AI Applications,
Applications Current
Trends in AI. Machine Learning: Machine Learning Overview
Overview, Design of a Learning system,
system
Types of machine learning, Applications of machine learning
learning, Variables and probabilities -
Probability Theory, Probability distributions
UNIT-II
Problem Solving, General Problem Sol
Solving, Production Systems, Control Strategies Forward
and Backward Chaining, Searching:Searching for Solutions
Solutions, Uniformed Search Strategies –
Breadth First Search, Depth First Search. Heuristic Search, Greedy Best First Search,
Search
Knowledge Representations Map
Mapping & Issues
UNIT-III
Soft Computing: Introduction to Soft Computing
Computing, Soft Computing vs. Hard Computing,
Computing Various
Types of Soft Computing Techniques
Techniques, Applications of Soft Computing. Basic Concepts of Neural
Network, Human Brain- Biological Neural Network
Network, Evolution of Artificial Neural Network,
Network

Page 101 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

Structure and Function of a Single Neuron

Neuron, Difference Between ANN and Human Brain,
Brain
Characteristics and Applications of ANN
ANN, Learning Methods, Activation Function,
Function Neural
Network Architecture.
UNIT-IV
Supervised Learning:
ing: Perceptron learning
learning, - Single layer, multilayer, Back propagation network,
network
Unsupervised Learning Neural Networks – Competitive LearningNetworks – Kohonen Self-
Organizing Networks
UNIT-V
Introduction to expert system and application of expert systems
systems, case studies, MYCIN
Fuzzy Logic: Fuzzy Set Theory,, Crisp Set, Fuzzy Set, Operations on Fuzzy Sets: Compliment,
Compliment
Intersections, Unions, Product, Difference
Difference, Properties of Fuzzy set
Genetic Algorithm: Fundamentals
Fundamentals, Basic Concepts, Working Principle, Encoding,
Encoding Fitness
Function, Reproduction,, Crossover, Mutation

TEXT &REFERENCE BOOKS

 Elaine Rich and Kevin Knight “Artificial Intelligence” - Tata McGraw Hill.
 Dan W. Patterson “Introduction to Artificial Intelligence and Expert Systems”,
Systems” Prentice
India.
 Nils J. Nilson
lson “Principles of Artificial Intelligence”
Intelligence”, Narosa Publishing House
 Christopher Bishop, “Pattern Recognition and Machine Learning”
Learning”, Springer
 Kevin P. Murphy, “Machine Learning: A Probabilistic Perspective”
Perspective”, MIT Press
 EthemAlpaydin, “Introduction to Machine Learning”, MIT Press
 Tom Mitchell, "Machine Learning"
Learning", McGraw-Hill
 Stephen Marsland, “Machine Learning - An Algorithmic Perspective”, Chapman
andHall/CRC Press
 S, Rajasekaran& G.A. VijayalakshmiPai
VijayalakshmiPai, Neural Networks, Fuzzy Logic & Genetic
Algorithms, Synthesis & Applications
Applications, PHI publication.
 S.N. Sivanandam&S.N.Deepa
Sivanandam&S.N.Deepa, Principles of Soft Computing, Wiley Publications.

Page 102 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCACCE(C) - MOBILE APPLICATION DEVELOPMENT

EVELOPMENT

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
CE 3 0 4 5 80 20 0 100

COURSE OBJECTIVES
 To introduce Android platform and its architecture.
 To learn activity creation and Android UI designing.
 To be familiarized with Intent, Broadcast receivers and Internet services.
 To work with SQLite Database and content providers.
 To integrate multimedia, camera and Location based services & REST full web Services in
Android Application.
 To explore publishing process of Android Application
COURSE OUTCOMES
 Describe Android platform, Architecture and features.
 Design User Interface and develop activity for Android App.
 Use Intent, Broadcast receivers and Internet services in Android App.
 Design and implement Database Application and Content providers.
 Use multimedia, camera and Location based services in Android App.
 Discuss various stages in Android App publishing.

UNIT-WISE SYLLABUS

UNIT - I
Various mobile platforms, introduction to android, hist
history
ory and versions of android, android
API, android architecture, android runtime, dal vik virtual machine, features of android,
introduction and installation of eclipse and ADT plugin and/or introduction and installation of
android studio, requirements and installation of android SDK, SDK manager, emulator, avd,
android virtual device manager, google play account, installing android app from google play,
APK file.
UNIT - II
Setting up Development Environment, Installing Packages using SDK Manager, Android Project
Pr
Structure, Creating Hello Android App, Deploy it on USB
USB-connected
connected Android device, Setting up
an Emulator, Android Tool Repository, Manifest File, DDMS, File Explorer, Installing and
Running Android - Hello App, Activity Life Cycle and its methods, Lo Logcat,
gcat, Components of an
Android App – Activity, Service, Broadcast Receiver, Content Provider
UNIT - III
Layout – Linear Layout, Relative Layout, Scroll View Layout, Table Layout, Frame Layout, UI
Resources – Layout Resources, UI Elements, Views – Text view,, Edit Text, Button, Check Box,
Radio Button, Image Button, Spinner, Navigating between Activities – Intent, Exchanging Data
between Activities, Action Bar, Event Handling, Listeners, Notifying the User –Toast.
Toast.

Page 103 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

UNIT - IV
Using Threads, Image View, Exception Handling, Multimedia - Playing Audio using an Intent,
Playing Video using an Intent, Playing Audio using Media Player, Playing Video using Video
View, Fragment, Fragment Life Cycle.
UNIT - V
SQLite database, creation of database and tables, CRUD operations – create, retrieve, update
and delete operations, Cursor, list view,
Introduction – REST full web Services, JSON, Google Play Services, location services,
publishing apps.

TEXT &REFERENCE BOOKS

 Michael Burton, Donn Felker, "Android Application Development for Dummies",

Dummies, ISBN : 9788126538775
 Pradeep Kothari, " Android Application Development (with Kitkat Support)", Kogent
Learning Solutions Inc., Black Book, DreamTech Press, ISBN : 9789351194095
 W. Frank Ableson, Robi Sen, Et. Al., " And
Android
roid in Action", Manning, ISBN :
9789350042915
 Charlie Collins, Michael Galpin, Et. Al., " Android in Practice", Manning, ISBN :
9789350042397
 Anubhav Pradhan, Anil V Deshpande, "Composing Mobile App, Learn | Explore | Apply
using Android", Wiley, ISBN : 9
9788126546602
 James C. Sheusi, " Android Application Development For Java Programmers", Cengage
Learning, 2013.
 Wallace Jackson, "Android Apps for Absolute Beginners", Apress, ISBN : 9788132211372
 http://www.developer.android.com

PRACTICAL LIST ON MO
MOBILE APPLICATION DEVELOPMENT
ENT

1. Installing Android Environment

2. Create “Hello World” application. That will display “Hello World” in the middle of the screen
in the emulator. Also display “Hello World” in the middle of the screen in the Android
Phone.
3. Create an application
pplication with login module. (Check username and password).
4. Create spinner with strings taken from resource folder (res >> value folder) and on
changing the spinner value, Image will change.
5. Create a menu with 5 options and selected option should appear in text box.
6. Create a list of all courses in your college and on selecting a particular course teacher-in-
teacher
charge of that course should appear at the bottom of the screen.
7. Create an application with three option buttons, on selecting a button color of the
th screen
will change.

Page 104 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

8. Create and Login application as above. On successful login, pop up the message.
9. Create an application to Create, Insert, update, Delete and retrieve operation on the
database.
10. Create a Simple Application using Android Resources.
11. Create
eate a Simple Application using Layouts.
12. Create a Simple Application using Intents.
13. Create a Simple Application using user interfaces.
14. Create a Simple Application for playing Audio and Video files.

Page 105 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCASEC(A) - CYBER SECURITY

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 To understand the importance of taking a multi
multi-disciplinary
disciplinary approach to cyber security
 To understand the cyber threat landscape, both in terms of recent emergent issues and
those issues which recur over time
 To understand the roles and influences of governments, commercial and other
organisations, citizens and criminals in cyber security affairs
 Identify general principles
rinciples and strategies that can be applied to systems to make them more
robust to attack
 Understand key factors in cyber security from different disciplinary views including
computer science, management, law, criminology, and social sciences
 Identify various issues surrounding privacy, anonymity and pervasive passive monitoring
 Understand how to manage security incidents, including digital forensic principles
COURSE OUTCOMES
 Understand the importance of cyber security
 Understand various cyber security threats
 Understand the roles and responsibilities of governments, commercial and other
organisations, citizens and criminals in cyber security affairs
 Apply general principles and strategies to systems to make them more robust to attack
 Identify various key
ey factors in cyber security from different disciplinary views including
computer science, management, law, criminology, and social sciences
 Identify various issues surrounding privacy, anonymity and pervasive passive monitoring
 Manage & response simple se
security incidents.

UNIT – I
Concepts and Definitions - Difference between IT Security, Information Security and Cyber
Security, Assets, Cyber Security threats & Vulnerabilities, Likelihood, Consequence and
Risk, Cyber Threats — Cyber Warfare-Cyber
Impact, Inherent Risk, Current Risk and Residual Risk Warfare
Crime-Cyber Terrorism-Cyber
Cyber Espionage, Need for a Comprehensive Cyber Security Policy,
Policy
Ethical Hacking, Anonymity in Cy
Cyberspace
Cyber Security Strategy - Supporting Business Goals and Objectives, Cyber Security Policy
Framework, Awareness, Training and Education
Risk Management Concepts - Risk Avoidance, Mitigation, Transfer and Acceptance, Risk
Appetite and Risk Tolerance
Threats and Opportunities - Assessing the current threat landscape, Advanced Persistent
Threats, Bring Your Own Device or Technologies, The Internet of Things, Insourcing and
Outsourcing, Controls and Enablers, Business Impact Analysis

Page 106 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

UNIT – II
Security Architecture - The key role of security architecture, Concepts and Definitions,
Security Architecture Frameworks. Security Architecture Design Principles, Service Models —
sourcing, Managed Services, Cloud Services, OSI and TCP/IP Models, Cryptography —
In-sourcing,
Symmetric, Asymmetric and Hashing Algorithms, Non Non-Repudiation, Real-world
world Use Cases,
Overview of Firewalls - Types of Firewalls, User Management, VPN Security, Security Protocols:
- security at the Application Layer
Layer- PGP and S/MIME, Security at Transport Layer- SSL and
TLS, Security at Network Layer-IPSec.
IPSec.
UNIT - III
Implementing Security - Network Security — Routers, switches, firewalls, intrusion detection
and prevention, Endpoint Security — Servers, desktop systems, laptops, tablets and mobile
devices, Application Security — Software Development Lifecycle, OWASP Top 10, Web
Application Firewall, Data Security — Data owners, data classification, labelling, Access
control, Data governance and lifecycle, Data remanence
UNIT - IV
Cyberspace and the Law - IntIntroduction,
roduction, Cyber Security Regulations, Roles of International
Law, the state and Private Sector in Cyberspace, Cyber Security Standards. The INDIAN
Cyberspace, National Cyber Security Policy 2013.
Cybercrime – Various types of cybercrimes
cybercrimes, Privacy & Anonymity issues
UNIT - V
Business Continuity and Disaster Recovery Planning - Business Continuity Planning,
Disaster Recovery Planning, BCP/DRP Training and Awareness, Testing and Maintenance of
the BCP/DRP, Security Assurance — Vulnerability Assessments and Penetration
netration Testing,
Minimum Security Baselines
Incident Response - Detection — Auditing, logging and security technologies, Security
Information and Event Management System (SIEM), Prevention — Authorisation, encryption,
anti-malware, Response — Security events and incidents, Legal
firewalls, intrusion prevention, anti
aspects, Incident Response Process, Incident Management Team, Computer Forensics, CERT-CERT
In — Roles & Responsibilities.

TEXT & REFERENCE BOOKS

 Mayank Bhushan, Rajkumar Singh Rathore, Aatif Jamshed, Fundamentals of Cyber

Security, BPB Publications, ISBN: 9789386551559
 Mark Merkow , Information Security: Principles and Practices, Pearson Education, ISBN-
ISBN
9788131712887
 Nina Godbole, Sunit Belapure, Cyber Security,, Wiley India, ISBN: 9788126521791
 Matt Bishop, Introduction to Computer Security, Pearson Education, ISBN:8177584251
 Kumar K -Cyber
Cyber Laws: Intellectual Property & E Commerce, Security, Dominant
Publisher
 Information Security Policy & Implementation Issues, NIIT, PHI
 Marine R.C.- Cyber Crime Impact in the New Millennium, Auther Press

Page 107 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCASEC(B) - AGILE & SCRUM

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 1 0 3 40 10 0 50

COURSE OBJECTIVES
 Introduce Concept and Practices of Agile Methodology in software development
 Gain knowledge of the different Agile methodologies and frameworks
 To understand the benefits and pitfalls of working in an Agile team
 Understand the key roles, events and artefacts of agile
 Work as a team to apply the tools and techniques of the Agile project lifecycle to a
simulated project
 Practice Scrum and enhance ability to develop and deliver high quality software.
COURSE OUTCOMES
 Become familiar with Agile Concepts and practice.
 Become competentin
in Scrum terminologies and their applications
 Perform iterative software development
evelopment processes: how to plan them, how to execute them.
 Facilitate daily scrums, user stories
stories, sprint planning, and sprint reviews

UNIT-WISE SYLLABUS

UNIT - I
Introduction to Agile, Theories for Agile Management, Agile Software Development, Traditional
Model vs. Agile Model, Classification of Agile Methods, Agile Manifesto, What makes agile
unique, What the enticing factors of Agile are, Why agile is the trend?
Why Agile? Myths and facts about Agile? Benefits of Agile, How Agile is addressing the current
issues, Why an organisation should consider Agile
UNIT - II
Principles of agile, building blocks of Agile, What to take note of, whenever Agile is going to be
planned, Agile
le Project Management, Agile Team Interactions, Ethics in Agile Teams, Agility in
Design, Testing, Agile Documentations, Agile Drivers, Capabilities and Values
UNIT - III
Introduction to the Scrum, Agile vs. SCRUM, Scrum Origins, History of Scrum, the foundation
fou
of Scrum & where Scrum sits, Scrum methodology, Why do companies move to Scrum?,
Comparison overview of all methodologies, Why scrum?
Scrum Pillars and Scrum Principles, Scrum Values and Scrum Resources, Scrum Aspects and
Scrum Strengths, Description
on of the different facets of Scrum, Considerations for implementing
Scrum.

UNIT - IV

Page 108 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

Quality in Scrum and Change in Scrum, How to manage Quality in Scrum, Risk in Scrum,
Managing Risk in your projects with Scrum, What is Scrum for? , Customer Management,
Management Cost
Management in Scrum, Some real world, real life applications of Scrum.
Scrum Planning Principles, Multilevel Planning
Planning, Portfolio Planning, Product Planning,
Planning Release
Planning,
UNIT - IV
Scrum Rituals and Scrum Roles - Product owner, Scrum master, Developmentelopment team, Product
vision statement, User story creation, Estimation, Review, Retrospective, Daily Scrum
Sprint, Sprint planning, Sprint Review.
Documenting in Scrum, Delivering and Improving in Scrum, Tools you can use on your Scrum
Projects

TEXT &REFERENCE BOOKS

 Denise Canty,, Agile for project managers, CRC Press

 Rama Bedarkar, Agile Scrum Wiley Emerging Technology Series.
 Keneth S Rubin, Essential Scrum : A practical Guide to the Most popular Agile process,
pearson publication.
 Charle G Cobb, Making
ng Sense of Agile project Management by Wiely
 https://theagiledirector.com/images/IntroductiontoScrum
https://theagiledirector.com/images/IntroductiontoScrum-coursenotes.pdf
coursenotes.pdf

Page 109 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCASEC(C) - DATA VISUALIZATION

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
SE 2 1 0 3 40 10 0 50

COURSE OBJECTIVES
 Acquire and develop the skills for both design and critique visualizations through
Conducting Exploratory and Explanatory analysis of data using visualization.
 Understand the importance data visualization, type of data and its impacts on data
visualization.
 Understand and learn the principles of perception for Crafting visual presentations of data
for effective communication and evaluation of visual design alternatives.
COURSE OUTCOMES
 Prepare data for visualization and analysis.
 Demonstrate and apply Exploratory and Explanatory analysis skills for data visualization
and evaluation of visual alternatives.
 Explain the importance data visualization, type of data and its impacts on data
visualization.
 Demonstrate the color palettes, principles of perception and cognition and apply them for
crafting visual presentations of data for effective communication and evaluation of visual
design alternatives.

UNIT-WISE SYLLABUS

UNIT I
Introduction to data visualization,
sualization, The data visualization process, Importan
mportance of data
visualization, Model of communication systems, Types of Communication Problems-
Problems technical,
semantic and effectiveness, Data types, relationships, and visualization formats, formats Basic
principles for data visualization - Principles of Communicating Data- Know your goal, use the
right data, select suitable visualizations, design for aesthetics, choose an effective medium and
channel, check the results, Data s storytelling
torytelling for social and market communication,
communica Trends in
market research and data visualization dashboards
UNIT II
Tableau - Introduction, Features, Tableau Products, Tableau Architecture, Download and
Installation of Tableau, Using Workspace Control, Tableau User Interface
Interface, Workspace, Toolbar,
Menu,
enu, Sheets, Dashboards, Data Window, Data Types, File Types
UNIT III
Data Connection with Data Sources like Text File and Microsoft Excel
Tableau Calculation-Function,
Function, Field, Operator, Literal, Parameter, and Comment, Tableau
Operators- General operators, Arithmetic operators, Relational operators and Logical operators

Page 110 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

Tableau functions- Number functions, String functions, Date functions, Logical functions and
Aggregate functions, Tableau Basic Filters
UNIT IV
Visual displays of information- Simple text, T
Tables,
ables, Graphs, Points, Lines, Bars, Area
Tableau Charts& Graphs- Bar Chart, Line, Pie, Bubble, Bump, Gantt, Crosstab, Motion,
Scatterplot, Heatmap, Waterfall Etc.
UNIT V
Clutter, Gestalt Principles of Visual Perception
Perception-proximity,
proximity, similarity, enclosure, closure,
c
continuity, and connection
Types of visual clutter- Lack of visual order, Alignment, White space and Non‐strategic
Non use of
contrast, preattentive attributes.

TEXT & REFERENCE BOOKS

 Visualize It!: A Comprehensive Guide to Data Visualization by Netquest Available online

at https://www.netquest.com/en/download
https://www.netquest.com/en/download-ebook-data-visualization
 Data Visualization Techniques Angie Ficek Available online at
https://www.cehd.umn.edu/OLPD/MESI/spring/2015/Ficek
https://www.cehd.umn.edu/OLPD/MESI/spring/2015/Ficek-DataVis.pdf
 Ben Jones, Communicating Data with Tableau O’Reilly Media, Inc.Publication, ISBN:
I
978-1-449-37202-6
 Claus O. Wilke, Fundamentals of Data Visualization: A Primer on Making Informative and
Compelling Figures, O’Reilly Media, Inc.Publication, ISBN - 9781492031086
 Cole Nussbaumer-knaflic,
knaflic, Storytelling with Data, John Wiley Publication, ISBN
9781119002062 (ePub)
 Interactive Data Visualization - Foundations, Techniques, and Applications by Matthew
Ward, Georges Grinstein, Daniel Keim, CRC Press, Taylor & Francis Group

Page 111 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCAOE(A) - BLOCKCHAIN TECHNOLOGY

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

OBJECTIVE
 To provide conceptual understanding of how blockchain technology
 To
o provide conceptual understanding of how blockchain technology can be used to innovate
and improve business processes
processes.
 To acquire skills to develop
evelop blockchain based solutions and write smart contract using
Hyperledger Fabric and Ethereum frameworks.
 To develop & integrate
ntegrate ideas from various domains and implement the
themm using block chain
technology in different perspectives
OUTCOMES
 Understand block chain technology
technology.
 Develop blockchain based solutions and write smart contract using Hyperledger Fabric and
Ethereum frameworks.
 Build and deploy block chain application for on premise and cloud based architecture.
 Integrate ideas from various domains and implement them using block chain technology in
different perspectives

UNIT-WISE SYLLABUS

UNIT I
Distributed computing introducti
introduction, Electronic Cash System introduction, The shortcomings of
current, transaction systems,
Overview of Block chain, Public Ledgers, Bitcoin, Smart Contracts, Block in a Block chain,
Transactions, Distributed Consensus, Public vs Private Block chain, Understanding
Under Crypto
currency to Block chain, Permissioned Model of Block chain, Overview of Security aspects of
Block chain
UNIT II
Cryptography- encryption and decryption model model, services-Confidentiality
Confidentiality, Integrity,
Authentication, Non-repudiation
repudiation and Account
Accountability, Symmetric cryptography,
cryptography Asymmetric
cryptography, Cryptographic Hash Function, Properties of a hash function, SHA-256, Hash
pointer and Merkle tree, Digital Signature, Public Key Cryptography, A basic cryptocurrency.
UNIT III
Bitcoin and Block chain:Creation
in:Creation of coins, Payments and double spending, Bitcoin Scripts,
Bitcoin P2P Network, Transaction in Bitcoin Network, Block Mining, Block propagation and
block relay.
Working with Consensus in Bitcoin
Bitcoin: Distributed consensus in open environments, Consensus
Conse
in a Bitcoin network, Proof of Work (PoW) – basic introduction, Hashcash PoW, Bitcoin PoW,

Page 112 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

Attacks on PoW and the monopoly problem, Proof of Stake, Proof of Burn and Proof of Elapsed
Time, The life of a Bitcoin Miner, Mining Difficulty, Mining Pool.
UNIT IV
Permissioned Block chain:Permissioned model and use cases
cases, Design issues for Permissioned
block chains, Execute contracts
contracts, State machine replication, Overview of Consensus models for
permissioned block chain- Distributed consensus in closed environment,
environment Paxos, RAFT
Consensus, Byzantine general problem
problem, Byzantine fault tolerant system, Lamport-Shostak-
Lamport
Pease BFT Algorithm, BFT over Asynchronous systems
systems.
Enterprise application of Block chain: Cross border payments
payments, Know Your Customer (KYC),
(KYC)
Food Security, Mortgage over Block chain
chain, Block chain enabled Trade, We Trade – Trade
Finance Network, Supply Chain Financing
Financing, Identity on Block chain
UNIT V
Hyperledger Fabric- Architecture
Architecture, Identities and Policies, Membership and Access Control,
Control
Channels, Transaction Validation
Validation, Writing smart contract using Hyperledger Fabric,
Fabric Writing
smart contract using Ethereum,, Overview of Ripple and Corda

TEXT &REFERENCE BOOKS

 Mastering Blockchain by Imran Bashir

Bashir, Packt Publishing Ltd. ISBN 978-1--78883-904-4
 Mastering Bitcoin by Andreas M
M. Antonopoulos, O’Reilly Media, Inc. ,
 Blockchain For Dummies, IBM Limited Edition by Manav Gupta
Gupta, John Wiley & Sons,
Sons Inc. ,
ISBN: 978-1-119-37123-66 (pbk); ISBN: 978
978-1-119-37139-7 (ebk)
 BLOCKCHAIN E-BOOK
BOOK by Cybrosys Limited Edition
 Melanie Swan, “Block Chain: Blueprint for a New Economy”
Economy”, O’Reilly, 2015
 Josh Thompsons, “Block Chain: The Block Chain for Beginners
Beginners- Guide to Block
chainTechnology and Leveraging Block Chain Programming”
 Basics”, Apress; 1stedition, 2017
Daniel Drescher, “Block Chain Basics”
 Anshul Kaushik, “Block Chain and Crypto Currencies”
Currencies”, Khanna Publishing House,
House Delhi.
 Imran Bashir, “Mastering Block Chain: Distributed Ledger Technology
Technology, Decentralization
and Smart Contracts Explained”
Explained”, Packt Publishing
 Ritesh Modi, “Solidity
ity Programming Essentials: A Beginner’s Guide to Build Smart
Contracts for Ethereum and Block Chain”
Chain”, Packt Publishing
 Salman Baset, Luc Desrosiers
Desrosiers, Nitin Gaur, Petr Novotny, Anthony O’Dowd,
O’Dowd Venkatraman
Ramakrishna, “Hands-OnOn Block Chain with Hyperledger
Hyperledger:: Building Decentralized
 Applications with Hyperledger Fabric and Composer”
Composer”, Import, 2018

LIST OF PRACTICALS

1. Install and understand Docker container

container, Node. js, Java and Hyperledger Fabric,
Fabric Ethereum
and perform necessary software installation on local mac
machine/create
hine/create instance on Cloud to
run.
https://github.com/hyperledger/
https://docs.docker.com/get-started/
started/
https://console.ng.bluemix.net/docs/services/blockchain/index.html

Page 113 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

https://console.bluemix.net/docs/containers/container_index.html#container_index
2. Create
reate and deploy a block chain network using Hyperledger Fabric SDK for Java
Set up and initialize the channel
channel, install and instantiate chaincode, and perform invoke and
query on your block chain network
https://developer.ibm.com/patterns/create-and-deploy-blockchain-network-using-fabric--sdk-java/)
(https://developer.ibm.com/patterns/create
3. Interact with a block chain network. Execute transactions and requests against a block
chain network by creating an app to test the network and its rules
https://developer.ibm.com/patterns/interacting-with-a-blockchain-network/)
(https://developer.ibm.com/patterns/interacting
4. Deploy an asset-transfer
transfer app using block chain. Learn app development within a
Hyperledger Fabric network
(https://developer.ibm.com/patterns/deploy
(https://developer.ibm.com/patterns/deploy-an-asset-transfer-app-using-bl
blockchain/)
5. Use block chain to track fitness club rewards
Build a web app that uses Hyperledger Fabric to track and trace member rewards
(https://developer.ibm.com/patterns/fitness
(https://developer.ibm.com/patterns/fitness-club-rewards-points-iot-and-retail
retail-
integration/)
6. Car auction network: A Hello lo World example with Hyperledger Fabric Node SDK and IBM
Block chain Starter Plan. Use Hyperledger Fabric to invoke chaincode while storing results
and data in the starter plan
https://developer.ibm.com/patterns/car-auction-network-hyperledger-fabric-node-sdk-starter
(https://developer.ibm.com/patterns/car starter-plan/)
7. Develop an IoT asset tracking app using Block chain
chain. Use an IoT asset tracking device to
improve a supply chain by using Block chain
chain, IoT devices, and Node-RED
(https://developer. ibm. com/patterns/develop
com/patterns/develop-an-iot-asset-tracking-app-using-block
block chain/)
chain/
8. Secure art using block chain digital certificates
certificates. Node. js-based
based auction application can
help democratize the art market( art-using-blockchain-
market(https://developer.ibm.com/patterns/securing-art
digital-certificates/)
9. Mini projects such as :
 Block chain for telecom roaming
roaming, fraud, and overage management. See how communication
service providers use block chain to enhance their value chains
chains.

https://developer.ibm.com/patterns/blockchain
https://developer.ibm.com/patterns/blockchain-for-telecom-roaming-fraud-and-overagemanagement/
overagemanagement/
 Use IoT dashboards to analyze data sent from a Block chain network
network. Build an IoT app and IoT
dashboards with Watson IoT Platform and Node
Node-RED
RED to analyze IoT data sent from a Block chain
network

https://developer.ibm.com/patterns/iot
https://developer.ibm.com/patterns/iot-dashboards-analyze-data-blockchain-network/
network/)
 Create an Android app with Block chain integration
integration. Build a Block chain enabled health and
fitness app with Android and Kubernetes

https://developer.ibm.com/patterns/creat
https://developer.ibm.com/patterns/create-an-android-app-with-blockchain-integration/
integration/

Page 114 Dr. C.P.Agrawal

Master of Computer Applications (MCA) - 2020 Semester - IV

 Create a global finance block chain application with IBM Block chain Platform Extension for VS
Code. Develop a Node. js smart contract and web app for a Global Finance with block chain use
case

https://developer.ibm.com/patterns/global
er.ibm.com/patterns/global-financing-use-case-for-blockchain/
 Develop a voting application using Hyperledger and Ethereum
Ethereum. Build a decentralized
app that combines Ethereum's Web3 and Solidity smart contracts with Hyperledger's
hosting Fabric and Chaincode EVM
https://developer.ibm.com/patterns/voting
https://developer.ibm.com/patterns/voting-app-hyperledger-ethereum/
 Create a block chain app for loyalty points with Hyperledger Fabric Ethereum Virtual Machine.
Machine
Deploy Fabric locally with EVM and create a proxy for interacting with a smart contract through
t
a Node. js web app

https://developer.ibm.com/patterns/loyalty
https://developer.ibm.com/patterns/loyalty-points-fabric-evm/

Page 115 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCAOE(B) - PROGRAMMING WITH GO

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 1 0 4 3 40 10 0 50

COURSE OBJECTIVES
 To learn the fundamental programming concepts and methodologies which are essential to
building good Go language programs.
 To Install and run the Go language environment on a PC &Create and execute Go language
programs
 To practice the fundamental programming methodologies in the Go programming language
via laboratory experiences.
 To code, document, test, and implement a well
well-structured, robust computer program using
the Go programming language.
 To write Go Packages for reuse.
COURSE OUTCOMES
 Install and run the Go language environment on a PC
 Create and execute programs using basic data structures available in Go Language.
 Able to make Go language programs using functions
functions, pointers, Structs and Methods.
 Demonstrate to develop program for file handling
handling, databases and socket in Go language.
 Able to write reusable packages in Go language and use various programming concepts to
solve different problems.
UNIT-WISE SYLLABUS
UNIT- I
Development Environment - Installation
Installation, Development Tools, Go Packages
Go Programming Language –Hello Hello world in Go, Common Rule, Variables - Declaring &
Assigning Variables, Comment, Arithmetic Operations
Operations, Mathematical Functions,
Functions Increment and
Decrement, Getting Input from Keyboard
Keyboard, Comparison Operators, Logical Operators,
Operators Decision,
if..then, switch..case, Iteration - for, Iteration - while, break and continue
Arrays, Slices and Maps - Array,, Slice, Map
UNIT- II
Functions - Creating A Simple Function
Function, Function with Parameters, Function with Returning
Value, Function with Multiple Returning Values
Values, Function with Multiple Parameters and
Returning Value, Closure Function
Function, Recursion Function, Testing
Pointers - Pointer in Go, Structs and Methods
String Operations, - Concatenating Strings
Strings, String To Numeric, Numeric to String,
String String
Parser, Check String Data Length
Length, Copy Data, Upper and Lower Case Characters,
Characters Testing A
Program
UNIT- III

Page 116 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

File Operations, Writing Data Into A File

File, Reading Data From A File, Writing All
Error Handling and Logging - Error Handl
Handling, defer, panic(), and recover(), try..catch,
try..catch Logging
Building Own Go Package - Creating Simple Module
Module, Building Own Package
UNIT- IV
Concurrency, Goroutines, Synchronizi
Synchronizing Goroutines, Channels
Encoding, Encoding Base64, Hexadecimal
Hexadecimal, JSON, XML, CSV
Hashing and Cryptography, Getting Started
Started, Hashing, Hashing with MD5,
MD5 Hashing with
SHA256, Hashing with Key Using HMAC
HMAC, Testing, Cryptography - Symmetric Cryptography,
Cryptography
Asymmetric Cryptography
UNIT-V
Database Programming- Database for Go
Go, MySQL Driver for Go, Testing Connection,
Connection Querying
Socket Programming - Socket Module
Module, Client/Server Socket, Server Socket,
Socket Client Socket,
Testing

TEXT &REFERENCE BOOKS

 GuneyTarikHands-On
On Go Programming by Paperback, Packt Publishing Limited,
Limited SBN:
9781789531756, 9781789531756
 Alan A. A. Donovan, Brian W. Kernighan
Kernighan, The Go Programming Languageby Paperback,
Paperback
Pearson, ISBN: 9789332569713
9789332569713, 9332569711
 Vivien Vladimir,, Learning Go Programming by Paperback, Packt Publishing Limited,
Limited
ISBN: 9781784395438, 9781784395438
 Caleb Doxsey, An Introduction
oduction to Programming in GO, Online available at -
https://www.golang-book.com/public/pdf/gobook.3186517259.pdf
book.com/public/pdf/gobook.3186517259.pdf
 Alan Donovan and Brian Kernighan
Kernighan, The Go Programming Language, Addison-Wesley
Addison
Professional Computing Series) Kindle Edition
 Agus Kurniawan, Go Programming by Examples
Examples, Kindle Edition, PE Press
 William Kennedy, Go In Action
Action, Paperback, Manning Publications
 Mark Summerfield, Programming in Go
Go, Paperback, Addison Wesley

ONLINE RECOURSES

 Go Language Download Page - https://golang.org/

 Go Language Official Documentation Page - https://golang.org/doc/
 Golang Tutorial – Learn Go Programming Language -
https://www.geeksforgeeks.org/golang
https://www.geeksforgeeks.org/golang-tutorial-learn-go-programming-language/
language/
 https://www.tutorialspoint.com/go/index.htm
 https://gobyexample.com/
 http://www.golangbootcamp.com/book
 https://www.cosmiclearn.com/go/

Page 117 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

PRACTICAL LIST – PROGRAMMING WITH GO LANGUAGE

1. Create a program with comments that shows your name and address
2. Create a program that holds your name in a string.
3. Get a number and a string
ring from the console and check if the numbers is between 1 and 10
and the string length is not greater than 10.
4. Create a program that calculates the average weight of 5 people.
5. Create an array with the number 0 to 10
6. Create an array of strings with names
7. Make a program with loop that counts from 1 to 10.
8. Check if a file exists on your local disk or on an external disk?
9. Create a new file containing names and read it into an array
10. Write a list of cities to a new file.
11. Write a program which uses the package h
has the rename function.
12. Create a struct house with variables no
no, Rooms, price and city
13. Create a method that sums two numbers
14. Create a method that calls another method.
15. Write a program that uses a goroutine

Page 118 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCAOE(C) - SOFTWARE PROJECT MANAGEMENT

AGEMENT

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 2 0 2 3 40 10 0 50

COURSE OBJECTIVES
 Understand the Software Project Planning and Evaluation techniques.
 Plan and manage projects at each stage of the software development life cycle (SDLC).
 Learn about the activity planning and risk management principles.
 Manage software projects and control the software deliverables.
 Learn the management of activities of various phases involved in project management and
also learn how to allocate the right job to right people.
COURSE OUTCOMES
 Gain extensive knowledge about the basic project management concepts
concepts,, framework and
the process models.
 Demonstrate and apply the Project Management principles while developing software.
 Explain and Apply software project metrics to estimate the software Efforts,
Efforts Duration, Cost,
and Staff Size, using various estimation techniques.
 Identify, Analyze, categorize
categorize, Estimate and Manage the risks involved in various project
p
activities.
 Learn and practice the staff selection process and the issues related to people management.

UNIT-WISE SYLLABUS

UNIT I
Project Evaluation And Project Planning
Planning: Importance of Software Project Management –
Activities Methodologies – Categor
Categorization of Software Projects – Setting objectives –
Management Principles – Management Control – Project portfolio Management – Cost-benefit
evaluation technology – Risk evaluation – Strategic program Management – Stepwise Project
Planning.
UNIT II
Projectt Life Cycle And Effort Estimation
Estimation: Software Process
rocess and Process Models – Choice of
Process models - mentall delivery – Rapid Application Development – Agile methods – Extreme
Programming – SCRUM – Managing interactive processes – Basics of Software estimation
estimat –
Effort and Cost estimation techniques – COSMIC Full function points - COCOMO II,
II Parametric
Productivity Model - Staffing Pattern.
UNIT III
Activity Planning And Risk Management
Management: Objectives of Activity planning – Project schedules –
Activities – Sequencing
encing and scheduling – Network Planning models – Forward Pass & Backward
Pass techniques – Critical path (CRM) method – Risk identification – Assessment – Monitoring –

Page 119 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

PERT technique – Monte Carlo simulation – Resource Allocation – Creation of critical patterns
pa –
Cost schedules.
UNIT IV
Project Management And Control : Framework for Management and control – Collection of data
Project termination – Visualizing progress – Cost monitoring – Earned Value Analysis-
Analysis Project
tracking – Change control- Software C Configuration Management – Managing contracts –
Contract Management.
UNIT V
Staffing In Software Projects: Managing people – Organizational behavior – Best methods of
staff selection – Motivation – The Oldham
Oldham-Hackman
Hackman job characteristic model – Ethical and
Programmed concerns – Working in teams – Decision making – Team structures – Virtual
teams – Communications genres – Communication plans.

TEXT &REFERENCE BOOKS

 Bob Hughes, Mike Cotterell and Rajib Mall: Software Project Management,
Management Tata McGraw
Hill, New Delhi, 2012.
 Robert K. Wysocki “Effective Software Project Management” – Wiley Publication,
Publication 2011.
 Walker Royce: “Software Project Management”
Management”- Addison-Wesley, 1998.
 Gopalaswamy Ramesh, “Managing Global Software Projects” – McGraw Hill Education
(India), Fourteenth Reprint 2013.

Page 120 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

4MCAOE(D) - ENTERPRISE RESOURCE PLANNING (ERP) & CRM

End-Term
CC/CE Continuous End-Term
Term
Theory Total
/SE L T P Credit Evaluation Practical
Exam Marks
/OE Marks Exam Marks
Marks
OE 3 0 0 3 40 10 0 50

UNIT-I
ERP Overview, Benefit, Common myths and evolving realities, Business Process Reengineering,
Data ware Housing, Data Mining, LAP, Supply chain Management, ERP Drivers, Decision
support system, ERP Domain.
UNIT-II
ERP -A A Manufacturing Perspective, ERP Module, ERP Market, ERP implementation life cycle,
Options of various paradigms, Identification of suitable platforms, Role of SDLC/SSAD, Object
Oriented architecture. Framework for evaluating ERP acquisition, Analytical Hierarchy
Processes (AHP), Applications
ions of AHP in evaluating ERP, Selection of Weights, Role of
consultants, vendors and users in ERP implementation; Implementation vendors evaluation
criterion, ERP Implementation approaches and methodology, ERP implementation strategies,
ERP Customization
UNIT-III
Critical success and failure factors for implementation, Model for improving ERP effectiveness,
ERP implementation, Hidden costs, ERP success inhibitors and accelerators, Management
concern for ERP success, Strategic Grid: Useful guidelines for ER ERPP Implementations,
Technologies in ERP Systems
UNIT-IV
Introduction to CRM, Definitions - Concepts and Context of relationship Management –
Evolution - Transactional Vs. Relationship Approach – CRM as a strategic marketing tool –
CRM significance to the stakeholders
Understanding Customers, Customer information Database – Customer Profile Analysis -
Customer perception, Expectations analysis – Customer behavior in relationship perspectives;
individual and group customer’s - Customer life time value – Selection of Profitable customer
segments
UNIT-V
CRM Structures, Elements of CRM – CRM Process – Strategies for Customer acquisition –
Retention and Prevention of defection – Models of CRM – CRM road map for business
applications
CRM Planning and Implementation, Strategic CRM planning process – Implementation issues –
CRM Tools- Analytical CRM – Operational CRM – Call center management – Role of CRM
Managers

Page 121 Dr. C.P.Agrawal

 Master of Computer Applications (MCA) - 2020 Semester - IV

TEXT & REFERENCE BOOKS

 Lexis Leon, “Enterprise Resource Planning”, TMH

 Brady, Manu, Wegner, “Enterprise Resource Planning”, TMH
 Prof. Antony Lawrence, “Customer Relationship Management”, Himalaya Publishing
House

Page 122 Dr. C.P.Agrawal