Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

Semester I
PPR501MJ: Python Programming
Teaching Scheme: Credit: 03 Examination Scheme:
Theory Sessions: Total 45 Internal (TH): 25 Marks
Hours External (TH): 50 Marks
Total :75 Marks
Prerequisites: Object oriented Concepts.
Course Objectives:
 To understand and use the basics of python.
 To understand advanced concepts of python and be able to apply it for solving
complex problems.
 To understand the development of real-world applications using OOP concepts in
python.
 To understand basic database concepts in python.
 To understand web application development using python and Django framework.
Course Outcomes: On completion of the course, learners should be able to
CO# Cognitive Course Outcomes
Domain
CO1 Apply To learn and apply basic constructs of python such as data, operations,
conditions, loops, data types.
CO2 Apply To understand advance concepts of python and apply it for solving the
complex problems.
CO3 Apply To develop Python programs that incorporate OOPS concept, regular
expressions and multithreading for complex problem-solving and
performance enhancement.
CO4 Apply To implement various types of database operations in MongoDB.
CO5 Apply To develop comprehensive web applications using Django
Framework.

Unit Contents Weightage No of

No. in % Sessions
1 Fundamentals of Python
1.1 Introduction
1.2 Keywords, Identifiers, Literals, Operators
1.3 Data Types- Number, Strings, Lists, Tuples,
Dictionaries, Sets
1.4 Understanding Python blocks
15 9
1.5 Control flow- if, else, elif
1.6 Loops- while, for, continue, break
1.7 Loop manipulation using pass, continue, break and else
1.8 For loop using ranges, string, list and dictionaries
1.9 Programming using Python conditional and loops
block

Page 11/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

1.10 Comprehensions on List, Tuple, Dictionaries

*Mapping of Course Outcomes for Unit 1: CO1
2 Functions, Modules & Packages, Exceptional Handling
2.1. Function Basics-Scope, nested function, non-local
statements
2.2. Built-in functions
2.3. Types of functions, Anonymous Function: lambda
2.4. Decorators and Generators
2.5. Modules: Module basic usage, Creating, importing
modules.
2.6. Importing functions and variables from different
modules.
2.7. Python built-in modules - math, random, datetime, etc. 20 9
2.8. Package: import basics
2.9. Python namespace packages
2.10. User defined modules and packages
2.11. Exception Handling
2.11.1 Avoiding code break using exception handling
2.11.2 Safeguarding file operation using exception
handling
2.11.3 Handling multiple and user defined exception
2.11.4 Handling and helping developer with error code
2.11.5 Programming using Exception handling.
*Mapping of Course Outcomes for Unit 2: CO2
3 Python Object Oriented Programming
3.1 Concept of class, object and instances, method call, Real
time use of class in live projects
3.2 Constructor, class attributes and destructors
3.3 Inheritance, super class, method overriding
3.4 Overloading operators
3.5 Static and Class methods
3.6 Delegation and containership
3.7 Python Regular Expression
25 9
3.7.1 Pattern matching and searching using regex in python
3.7.2 Real time parsing of data using regex
3.7.3 Applications of Regex-Password, email, URL
validation
3.8 Multithreading
3.8.1 Understanding threads
3.8.2 Synchronizing the threads
3.8.3 Programming using multithreading

*Mapping of Course Outcomes for Unit 3: CO3

Page 12/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

4 Python database interaction using MongoDB

4.1. Introduction to NoSQL database
4.2. Types of NoSQL
4.2.1 Document Based: MongoDB
4.2.2 Key-Value Database – Couchbase
4.2.3 Wide-column Databases: Cassandra
4.2.4 Graph/node Databases: Neo4j
20 9
4.3. SQL Vs NoSQL
4.4. Introduction to MongoDB with python
4.5. Installing MongoDB on Windows
4.6. Exploring Collections and Documents
4.7. Performing CRUD Operations
4.8. Commit, Rollback and Cursor operation
4.9. Handling errors.
*Mapping of Course Outcomes for Unit 4: CO4
5 Web Development using Django
5.1 Introduction to Web Development and Django
5.2 Django Project Structure and Django Models
5.3 Django Views and Django Templates
5.4 Django URLs and Django Forms
20 9
5.5 Django Authentication and Advanced Django Features
5.6 Django Rest Framework (DRF) and Testing in Django
5.7 Deployment and Performance Optimization
5.8 Building a real-world Django application with Django
Channels for WebSockets
*Mapping of Course Outcomes for Unit 5: CO5

Learning Resources

Text Books:
 Introduction to Python Programming, By Gowrishankar S,
 Introduction to Python Programming by UDAYAN DAS, SAINT MARY'S COLLEGE
OF CALIFORNIA AUBREY LAWSON, WILEY
 Python Crash Course: A Hands-On, Project-Based Introduction to Programming

Reference Books:
 Learning Python 5th ed. by Mark Lutz
 Python: The Complete Reference by Martin C. Brown
 Python Data Analytics: With Pandas, NumPy, and Matplotlib 2nd ed. Edition by
Fabio Nelli
 Core Python Programming by Wesley J. Chun Publisher: Prentice Hall
 Python Programming: A modular approach by Taneja Sheetal, Kumar Naveen
 Beginner's Guide to Python Programming: Learn Python 3 Fundamentals, Plotting and

Page 13/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

Tkinter GUI Development Easily by Serhan Yamacli

 Programming Python, O’reilly, by Mark Lutz
 Learning Python, O’reilly, Mark Lutz
 Head First Python, O’reilly, By Paul Barry

Recommended Learning Material:

Online Courses:
● Coursera: "Python for Everybody" by the University of Michigan
● Udemy: "Complete Python Bootcamp: Go from zero to hero in Python 3" by Jose
Portilla
● edX: "Introduction to Python Programming" by Microsoft
Official Documentation:
● Python Official Documentation: [Link]
● Django Official Documentation: [Link]
● MongoDB Documentation: [Link]

Recommended Certification:
 Programming, Data Structures and Algorithms Using Python
[Link]
 Data Analytics with Python [Link]

Page 14/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

DSA502MJ: Data Structure and Algorithms

Teaching Scheme: Credit: 03 Examination Scheme:
Internal (TH): 25 Marks
Theory Session: Total 45
External (TH): 50 Marks
Hours
Total :75 Marks

Prerequisites:
Programming Knowledge, Mathematical Foundations, Understanding of Algorithms.

Course Objectives:

 To acquire the knowledge fundamentals of various data structure and algorithms.

 To choose the appropriate data structure for a specified application.
 To formulate the problems using appropriate Linear and non-linear data structures such
as Array, linked lists, stacks, queues, hash tables, trees, heaps and graphs.
 To understand and analyze various Searching, Sorting, Hashing and Heap technique to
solve the problems.
Course Outcomes:
On completion of the course, learners should be able to
CO# Cognitive Course Outcomes
Domain
Implement linear data structures and its various real time
CO1 Apply
applications
CO2 Apply Demonstrate linked list data structure and its types
Demonstrate dynamic linear data structures like stack, queue and
CO3 Apply
analyze their various applications.
Implement techniques of Non-Linear data structures like Tree and
CO4 Apply
Graph
Demonstrate and compare various approaches of Searching,
CO5 Apply
Sorting, Hashing and Heaps.
Unit Contents Weightage No of
No. in % Sessions
Arrays/List:
1.1 Introduction & Definition of an Array
1.2 Memory Allocation & Indexing
1 1.3 Operations on 1-D & 2D Arrays/Lists 15 4
1.4 Arrays and Their Applications
1.5 Sparse Matrices
1.6 String manipulation using arrays
*Mapping of Course Outcomes for Unit 1: CO1

Linked Lists:
2 2.1 Introduction 20 7
2.2 Definition of a Linked List

Page 15/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

2.3 Memory Allocation in a Linked List

2.4 Types of Linked Lists
2.4.1 Singly Linked List
2.4.2 Operations on a Singly Linked List
2.4.3 Circular Linked Lists
2.4.4 Operations on a Circular Linked List
2.4.5 Doubly Linked List
2.4.6 Operations on a Doubly Linked List
*Mapping of Course Outcomes for Unit 2: CO2

Stacks and Queues

3.1 Introduction and Definition of a Stack
3.2 Implementation of a Stack
3.2.1 Implementation of Stacks Using Arrays
3.2.2 Implementation of Stacks Using Linked Lists
3.3 Applications of Stacks:
3.3.1 Conversion of an expression (Infix, Prefix,
3 Postfix) 20 10
3.3.2 Evaluation of Expression
3.3.3 String Reversal
3.4 Introduction and Definition of a Queue
3.5 Implementation of a Queue
3.5.1 Implementation of Queues Using Arrays
3.5.2 Implementation of Queues Using Linked Lists
3.6 Applications of Queues
*Mapping of Course Outcomes for Unit 3: CO3

Tree & Graph

4.1 Tree Definition, representation
4.2 Binary Search Tree and its operations
4.2.1 Tree Traversal
4.2.2 Insertion
4.2.3 Deletion
4.2.4 Search
4.3 AVL Tree and its operations
4 4.3.1 Insertion 25 16
4.3.2 Deletion
4.3.3 Rotations
4.4 Directed and Undirected Graph
4.5 Graph Representations
4.5.1 Adjacency Matrix
4.5.2 Adjacency List
4.6 Graph Traversals
4.6.1 BFS

Page 16/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

4.6.2 DFS
*Mapping of Course Outcomes for Unit 4: CO4

Searching and Sorting

5.1 Linear Search or Sequential Search
5.2 Binary Search
5.3 Interpolation Search
5.4 Introduction to Sorting
5.4.1 Merge Sort
5 5.4.2 Quick Sort 20 8
5.4.3 Bubble Sort
5.5 Heap
5.5.1 Min heap and Max heap
5.6 Hashing
5.6.1 Hash Table
5.6.2 Hash Functions
*Mapping of Course Outcomes for Unit 5: CO5

Note: Course should be taught in python programming language.

Learning Resources

Text Books

 Jean Paul Tremblay, Paul G. Sorensons, “An Introduction to Data Structures with
Application”, McGraw Hall Publication (INDIAN edition)
 Michael T. Goodrich, Roberto Tamassia, Michael H. Goldwasser “Data Structures
and Algorithms in Python”, Wiley
 Dheeraj Malhotra, Neha Malhotra, “Data Structures and Program Design using
Python”, Mercury Learning and Information
Reference Books

 Lipschutz Schaum’s, “Data Structure”, Outline Series, MH

 D. Samanta, “Classical Data Structure”, PHI,
 Practical Approach to Data Structures by Hanuman Thappa.
 Horowitz/Sahani, Fundamental of Algorithm. PHI, Galgotia.
 Magnifying Data Structures, Arpita Gopal, PHI Publications

Page 17/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

Recommended Learning Material

Online Courses:

 Coursera: Data Structures and Algorithms Specialization by UCSan Deigo

 Coursera: Python Data Structures by the University of Michigan

 Udemy: "The Complete Data Structure & Algorithms in Python”

 edX: " GTx: Data Structures & Algorithms I: ArrayLists, LinkedLists, Stacks and
Queues”

Tutorials and Guides:

 [Link]

 [Link]
 [Link]
Recommended Certification

 Programming, Data Structures and Algorithms Using Python

[Link]

 [Link]
 [Link]

Page 18/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

ADB503MJ: Advanced DBMS

Teaching Scheme: Credit: 03 Examination Scheme:
Theory Session: Total 45 Hours Internal(TH): 25 Marks
External (TH) : 50 Marks
Total :75 Marks
Prerequisites: File Structure
Course Objectives:
● To understand the fundamental concepts and applications of Database Management
Systems.
● To understand the relational database design principles.
● To get familiar with Data Collection and Design techniques.
● To acquire the skillset to use flexible databases for real world applications.
● To design Database Management Systems for projects.
● To relate different DB languages like MySQL, Noe4J, Risk, MongoDB.
Course Outcomes: On completion of the course, learners should be able to
CO# Cognitive Course Outcomes
Domain
CO1 Apply Demonstrating the concept of fundamentals of relational
database systems include: data models, database & DDBS
architectures, and ER features.
CO2 Understand Understand the concepts of transaction concurrency control,
Query Processing and Security aspects
CO3 Apply Apply SQL & NoSQL development tools on different types of
Schemas.
CO4 Apply Demonstrate database design and Computation techniques for
parallel and distributed database Technology.
CO5 Apply Implement Real Time applications using Database tools.

Unit Weightage No of
Contents
No. in % Sessions
1 Database Design and SQL Query Processing
1.1 Introduction to Database, Data Models and
Architecture of DBMS (Views of data: Schemas and
Instances, Data Independence)
1.2 Data Modelling using ER Diagram: Representation
of Entities, Attributes, Relationships and their Types, 20 10
Cardinality, Generalization, Specialization,
Aggregation.
1.3 Relational Data Model: Structure of Relational
Database Model, Referential Integrity Constraints & its
types, Codd’s rules

Page 19/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

1.4 Database Design using E-R, E-R to Relational Tables

Conversion, Database design using Normalization –
Normal forms - 1NF, 2NF, 3NF - Case Studies
1.5 Introduction to SQL Query Processing (DDL, DML,
Aggregate Functions and Joins)
*Mapping of Course Outcomes for Unit 1: CO1 & CO3
2 Transaction and Concurrency Control
2.1. Concept of Transaction and Transaction
processing, ACID properties, Transaction States
2.2 Concurrency control, Problems in concurrency
Control
20 8
2.3 Scheduling of Transactions, Serializability and
Testing of Serializability
2.4 Concurrency Control Protocols: Lock-Based
Protocol and Time Stamp-based ordering protocols
2.5 Deadlock in DBMS , Deadlock Handling Methods,
*Mapping of Course Outcomes for Unit 2: CO2
3 Database Recovery and Security Techniques
3.1 Failure Classification
3.2 Storage Structure
3.3 Recovery and Atomicity
3.4 Log-Based Recovery (Deferred Database
Modification, Immediate Database Modification)
3.5 Check Points, Shadow Paging
3.6 Introduction to Database backup, factors of database
backups, Types of backups, steps to create database
backup plan, Recovery from catastrophic failures 20 10
3.7 Database Security in DBMS, Importance of Database
Security, Security Threats, Challenges in Database
Security
3.8 Discretionary access control based on grant &
revoking Privilege
3.9 Mandatory access control and role-based access
control for Multilevel security
3.10 Encryption- its types & Public & Private key
Infrastructures
*Mapping of Course Outcomes for Unit 3: CO2
4 Parallel and Distributed Database 20 9
4.1 Parallel Database System: Parallel Database
Architectures; Parallel query processing and
optimization; Load balancing; database clusters
4.2 Introduction to Distributed DBMS & Architecture,
Characteristics

Page 20/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

4.3 Distributed Data Processing, Promises of DDBMSs,

Problem Areas.
4.4 Distributed data storage (Fragmentation, Replication
& Transparency)
4.5 Query Processing: Objectives, Query decomposition;
Localization of distributed data
4.6 Transaction Management & Concurrency Control in
DDBMS, Commit Protocols (2-PC, 3-PC)
*Mapping of Course Outcomes for Unit 4: CO4
5 NOSQL database for Business Applications
5.1 Introduction to NOSQL Database: Overview,
History of NoSQL Databases, The Definition of the Four
Types of NoSQL Databases.
5.2 Processing of NOSQL Column-Oriented NoSQL
Databases using MongoDB, NoSQL Key/Value
databases using MongoDB 20 8
5.3 Introduction to MongoDB Database, JSON and
JSON Structure, NoSQL Key/Value databases, Graph
NoSQL Databases using Neo4J, NoSQL database
development tools and programming languages, Future
Trends in NoSQL Databases.
5.4 Introduction to FireBase
*Mapping of Course Outcomes for Unit 5: CO3, CO5

Learning Resources

Text Books
 Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd edition,
Tata McGraw Hill, New Delhi, India
 Introduction to database systems C.J. Date, Pearson.
 Principles of Database Management James Martin, PHI
 Elmasri Navate, Fundamentals of Database Systems, Pearson Education, India.
 Sadalage, P. & Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of
Polyglot Persistence, Wiley Publications,1st Edition ,2019.
 Principles of Distributed Database Systems, M.T. Ozsu and P. Valduriez, Prentice-Hall,
1991..
 Distributed Database Systems, D. Bell and J. Grimson, Addison-Wesley, 1992.

Reference Books
 Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke Third
Edition
 Database System Concepts by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan
Seventh Edition

Page 21/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

 Peter Rob, Carlos Coronel (2009), Database Systems Design, Implementation and
Management, 7th edition
 Dan Sullivan, "NoSQL For Mere Mortals", 1st Edition, Pearson Education India, 2015.
(ISBN13: 978-9332557338)
 Dan McCreary and Ann Kelly, "Making Sense of NoSQL: A guide for Managers and the
Rest of us", 1st Edition, Manning Publication/Dreamtech Press, 2013. (ISBN-13: 978-
9351192022)
 Kristina Chodorow, "Mongodb: The Definitive Guide- Powerful and Scalable Data
Storage", 2nd Edition, O'Reilly Publications, 2013. (ISBN-13: 978-9351102694)
 Meier & Kaufmann. SQL & NoSQL Databases: Models, Languages, Consistency
Options and Architectures for Big Data Management, 1st ed. Springer, 2019
 Bradshaw & Chodorow. MongoDB: The Definitive Guide: Powerful and Scalable Data
Storage, 3rd ed. O'Reilly, 2019
 Pivert. NoSQL Data Models: Trends and Challenges, 1st ed. Wiley, 2018
 Sullivan. NoSQL for Mere Mortals, 1st ed. Addison-Wesley Professional, 2015
 A Dive Deep into Types of Databases -[Link]
types-nosql-databases
 Geethmi Nimantha Dissanayake - A Study on Real-Time Database Technology and Its
Applications.
 Adity Gupta, Swati Tyagi, Nupur Panwar, Shelly Sachdeva Jaypee Institute of
Information Technology, India -NoSQL Databases:Critical Analysis and Comparison.
 Firebase Realtime Database -[Link]
 Database system practical approach to design, implementation & management by
Connoly & Begg

Recommended Learning Material

 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
 [Link] 2.
 [Link] 3.

Page 22/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

 [Link]
 [Link]

Recommended Certification
 The Complete Database Design & Modeling Beginners Tutorial
 Oracle Database SQL Certification
 SQL for Data Science
 Introduction to SQL
 MySQL Certification
 Complete SQL Bootcamp
 Oracle Certified Professional, MySQL 5.7 Database Administrator Certification
 IBM Associate Certified DBA - Db2 12 for z/OS Fundamentals
 DataCamp’s SQL Certification
 Free MongoDB Course
 Neo4j Certified Professional
 MongoDB Certified Developer Associate

Page 23/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

BST504MJ: Business Statistics

Teaching Scheme: Credit: 03 Examination Scheme:
Theory Session: Total 45 Internal(TH): 25 Marks
Hours External (TH) : 50 Marks
Total :75 Marks
Prerequisites: Basic Mathematics

Course Objectives:

 To understand the importance of data-driven business decisions.

 To learn the basics of business decision analysis.
 To summarize business data numerically and graphically.
 Learn the basics of beginning predictive business modelling.
 To understand the importance of business sampling methods, and be able to describe
different business sampling methods.
 To understand the process associated with statistical decisions, defining and formulating
problems, analysing the data, and using the results in decision-making.
Course Outcomes:
On completion of the course, learners should be able to

CO#
Cognitive Course Outcomes
Domain
CO1 Understand Understand the role and importance of statistics in business
decision-making.
CO2 Apply Apply measures of central tendency and dispersion to
summarize data.
CO3 Understand Understand basic probability concepts and rules.
CO4 Apply Apply correlation and regression techniques to analyze
relationships between variables
CO5 Apply Apply time series analysis techniques to forecast business
trends.
Unit Contents Weightage No of
No.
in % Sessions

1 Introduction to Business Statistics

1.1 Definition and Scope of Business Statistics Definition
of Statistics, Importance, Scope and Applications of
Statistics, Characteristics of Statistics, Functions of
20 7
Statistics, Limitations of Statistics, Importance of
Statistics in modern business environment.
1.2 Need of Data, Organisation of data, Data Classification
& Types of Data : Qualitative and Quantitative

Page 24/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

1.3 Data Collection Methods and representation of data,

Principles of Measurement, Source of Data
1.4 Scales of Measurement: Nominal, Ordinal, Interval,
Ratio
1.5 Descriptive vs. Inferential Statistics

*Mapping of Course Outcomes for Unit 1: CO1

2 Descriptive Statistics
2.1 Introduction, Objectives of statistical average,
Requisites of a Good Average, Statistical Averages -
Arithmetic mean -

2.2 Measures of Central Tendency: Properties of

arithmetic mean - Merits and demerits of arithmetic mean
,Median - Merits and demerits of median , Mode - Merits
and demerits of mode , Geometric Mean , Harmonic Mean 20 10

2.3 Measures of Dispersion: Dispersion – Range - Quartile

- Percentile, deviations, Mean deviation ,Standard
Deviation -Properties of standard deviation, Coefficient of
Variance
2.4 Skewness and Kurtosis
2.5 Exploratory Data Analysis

*Mapping of Course Outcomes for Unit 2: CO2

3 Probability and Probability Distributions

3.1 Basic of Permutation and Combinatorics, Probability
Concepts: Events, Sample Space, Rules of Probability
3.2 Random variable Expected values, Conditional
20 8
Probability and Bayes' Theorem
3.3 Discrete Probability Distributions: Binomial, Poisson
distribution
3.4 Continuous Probability Distributions: Normal

*Mapping of Course Outcomes for Unit 3: CO3

4 Correlation and Regression Analysis

4.1 Introduction of Correlation
20 10
4.2 Types of Correlation - Measures of Correlation -
Scatter diagram - Karl Pearson’s correlation coefficient-

Page 25/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

4.3 Properties of Karl Pearson’s correlation coefficient -

Spearman’s Rank Correlation Coefficient
4.4 Regression - Regression analysis - Regression lines -
Regression coefficient,
4.5 Multiple Regression Analysis, Reliability of Estimates
4.6 Model Diagnostics and Validation Application of
Multiple Regressions

*Mapping of Course Outcomes for Unit 4: CO4

5 Time Series Analysis

5.1 Time Series Analysis -Introduction, Time Series
Analysis, Utility of the Time Series, Components of Time
Series - Long term trend or secular trend - Seasonal
variations - Cyclic variations - Random variations

5.2 Methods of Measuring Trend - Free hand or graphic

method - Semi-average method - Method of moving 20 10
averages - Method of least squares,
5.3 Mathematical Models for Time Series - Additive
model - multiplicative model, Editing of Time Series,
Measurement of Seasonal Variation - Seasonal average
method - Seasonal variation through moving averages -
Chain or link relative method - Ratio to trend method

*Mapping of Course Outcomes for Unit 5: CO5

Learning Resources

Text Books

 Business Statistics by J.K. Sharma

 Statistics for Management by Richard I. Levin, David S. Rubin, Masood H. Siddiqui,
and Sanjay Rastogi
 Fundamentals of Statistics by S.C. Gupta
 Business Statistics by S.P. Gupta and M.P. Gupta
 Quantitative Techniques for Management by N.D. Vohra
Reference Books

 Statistics for Business and Economics by P. N. Arora, S. Arora, and S. Arora

 Quantitative Techniques for Decision Making by Anand Sharma
 Mathematical Statistics by J.N. Kapur and H.C. Saxena
 Business Statistics and Analytics by P. Mariappan
 Introduction to the Theory of Statistics by A.M. Mood, F.A. Graybill, and D.C. Boes

Page 26/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

Recommended Learning Material

Online Courses:

 Coursera: "Business Statistics and Analysis Specialization by Rice University

 edX: "Statistics and Data Science" MicroMasters Program by MIT
 Khan Academy: "Statistics and Probability"
 Udacity: "Introduction to Descriptive Statistics" and "Introduction to Inferential
Statistics"
 LinkedIn Learning: "Business Statistics Fundamentals"
Software Tools

 Microsoft Excel
 R and RStudio
 Tableau
 Python (with libraries such as Pandas, NumPy, and Matplotlib)

Recommended Certification

 Certified Business Analysis Professional (CBAP)

 Microsoft Certified: Data Analyst Associate
 SAS Certified Statistical Business Analyst
 Certified Analytics Professional (CAP)
 IBM Data Science Professional Certificate
 Google Data Analytics Professional Certificate
 Certified Six Sigma Green Belt
 Tableau Desktop Specialist
 Coursera Specializations in Business Statistics
 edX MicroMasters in Data, Economics, and Development Policy

Page 27/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

SEP505MJ : Software Engineering and Project Management

Teaching Scheme: Credit: 03 Examination Scheme:
Theory Sessions: Total 45 Internal (TH): 25 Marks
Hours External (TH): 50 Marks
Total :75 Marks
Prerequisites: Basic software engineering concepts

Course Objectives:

 To understand fundamental principles and concepts of software engineering.

 To learn requirement analysis and system design principles.
 To study the process of Software Project Management for effective project planning.
 To acquire knowledge of Agile Project Management Framework.
 To apply Agile tools for software development.
Course Outcomes:
On completion of the course, learners should be able to
CO# Cognitive Course Outcomes
Domain
CO1 Apply Apply concepts, principles of software engineering to develop
comprehensive Software Requirement Specification.

CO2 Apply Use software engineering analysis and design modelling technique
to represent systems.

CO3 Apply Illustrate Software Project Management models for effective plan,
manage and enhance projects.

CO4 Apply Implement Agile methodologies to enhance project adaptability

and responsiveness to changing requirements.

CO5 Apply Employ Agile tools effectively to manage, navigate and facilitate
collaboration and streamline project workflows in software
development.

Unit Contents Weightage No of

No. in % Sessions
1 Overview of Software Engineering
1.1. Overview of Software Engineering
1.2. SDLC models
1.3. Requirement Engineering
1.3.1. Types of Requirements: -Functional and Non- 15 6
functional
1.3.2. Four Phases of Requirement Engineering
1.4. Software requirement Specification (SRS)
1.4.1. Structure and contents of SRS

Page 28/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

1.4.2. IEEE SRS Format

Case studies : based on SRS

*Mapping of Course Outcomes for Unit 1: CO1

2 System Analysis and Modeling

2.1. Use case diagrams
2.2. Class Diagram
2.3. Activity Diagram 20 8
2.4. Interaction Diagram
2.5. Package, component and deployment Diagrams
Case studies based on diagrams
*Mapping of Course Outcomes for Unit 2: CO2

3 Fundamentals of Project Management

3.1. Overview of project Management
3.2. Project management life cycle-IEEE Life Cycle
3.3. Quality Metrics
3.4. Risk Management Process
3.5. Linear Software Project Cost Estimation 25 12
3.5.1. COCOMO-I (Problem Statement)
3.5.2 Function Point Analysis (Problem Statement)
3.5.3. The SEI Capability Maturity Model CMM
3.5.4. Software Configuration management
Case studies/Numerical Problems based on Risk
management , COCOMO-I and FPA
*Mapping of Course Outcomes for Unit 3: CO3

4 Agile Project Management Framework

4.1. Introduction and Definition Agile, Agile
Project Life Cycle
4.2. Agile Manifesto: History of Agile and Agile
Principles
4.3. Team and roles of an Agile Team: Scrum Master
Product Owner, Development Team
4.4. Key Agile Concepts:
4.5. User stories, Story points 30 14
4.6. Techniques for estimating Story Points
4.7. Product Backlog
4.8. Sprint Backlog,
4.9. Product Vision and Product Roadmap
4.10. Sprint Velocity
4.11. Swim lanes
4.12. Minimum Viable Product (MVP)
4.13. Version and Release

Page 29/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

4.14. Agile Project Management v/s Traditional

Project Management
4.15. Agile Reports: Daily Reports, Sprint Burn down
Chart and Reports
User Stories Scenarios and writing user stories
*Mapping of Course Outcomes for Unit 4: CO3, CO4

5Implementation with Agile Tools

5.1. MS Project Tool
5.2. Agile Tools: Open Source
5.3. Hands on GitHub
5.4. Create Project using Kanban 10 5
5.5. Project Repositories
5.6. Continuous Integration
5.7. Project Backlog
5.8 Team Management
*Mapping of Course Outcomes for Unit 5:CO4, CO5

Learning Resources

Text Books

 Software Engineering by Roger Pressman (6th edition)

 Object-Oriented Software Engineering: A Use Case Driven Approach by Ivan Jacobson
 Software Engineering by Sommerville, Pearson,8th Ed
 Agile Software Engineering with visual studio by Sam Guckenheimer, Neno Loje.
 Coaching Agile Teams: A Comparison for ScrumMasters, Agile Coaches, and Project
Managers in Transition, Lyssa Adkins
 Agile Project Management: Creating Innovative Products (2nd Edition) by Jim
Highsmith, Addison-Wesley Professional
Reference Books

 Object Oriented Modeling and Design with UML by James Rumbaugh, Michael Blaha
 Software Engineering by Chandramouli Subramanian, Saikat Dutt
 Object Oriented Systems Analysis and Design using UML by Simon Bennett
 The Unified Modeling Language user guide by Grady Booch, James Rumbaugh, Ivar
Jacobson Mark C. Layton, Steven J. Ostermiller
 Agile Estimating and Planning by Mike Cohn Robert C Martin Series
 Introduction to Software Project Management by Adolfo Villafiorita, CRC Press
 Agile Project Management for Dummies by Mark C. Layton
 Agile Project Management with Kanban By Eric Brechner
Recommended Learning Material

 [Link]
 [Link]
 [Link]

Page 30/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

 [Link]
 [Link]
 [Link]
 [Link]
 [Link]
Recommended Certification

 Project Management Professional (PMP)

 PMI-ACP(Agile Certified Practitioner)
 Certified Associate in Project Management (CAPM)
 Certified Project Director
 Certified Project Management Practitioner (CPMP)
 Certified Project Manager (CPM)
 Certified ScrumMaster (CSM)
 Professional in Project Management (PPM)
 Project Management in IT Security (PMITS)
 Certified Agile Project Manager (IAPM)

Page 31/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

FCC510MJ: Fundamentals of Cloud Computing

Teaching Scheme: Credit: 03 Examination Scheme:
Theory Sessions: Total 45 Internal (TH): 25 Marks
Hours External (TH): 50 Marks
Total :75 Marks
Prerequisites: Networking Fundamentals, Database Basics
Course Objectives:
● To introduce the fundamentals of cloud computing, Dockers and Containers.
● To give Insights into Cloud Service Models and Deployment Models.
● To provide knowledge on virtualization technologies.
● To know about Cloud Architecture and SOA.
● To impart the knowledge on different Cloud Platforms.
Course Outcomes: On completion of the course, learners should be able to
CO# Cognitive Course Outcomes
Domain
CO1 Understand Describe the concepts of Cloud Computing, Dockers and
Container.
CO2 Understand Explore the various Cloud Service Models and Deployment
Models.
CO3 Apply Implement concepts, hypervisors, virtual machines, VMware,
Microsoft Hyper-V, and Open-Source Virtualization Manager.
CO4 Understand Describe the Cloud Architecture and relate Cloud to SOA along
with SLA management, cloud bursting strategies.
CO5 Analyze Compare different Cloud Platforms – AWS, GCP, IBM Cloud.

Unit Contents Weightage No of

No. in % Sessions
1 Introduction to Cloud Computing 15% 6
1.1 Introduction to Cloud Computing
1.2 Cloud Computing vs. Cluster Computing vs. Grid
Computing
1.3 Characteristics, Pros and Cons of Cloud
1.4 Introduction to Dockers
1.5 Introduction to Container
*Mapping of Course Outcomes for Unit 1: CO1
2 Cloud Service Models and Deployment Models
2.1 Cloud Service Models - IAAS, PAAS, SAAS & its
Comparison
2.2 Cloud Deployment Models-Public, Private, Hybrid,
20 9
Community
2.3 XAAS- Anything as a Service – Storage as a service,
Network as a Service, Database as a Service

Page 32/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

2.4 Cloud Storage Types: Block, File, Object Storage

*Mapping of Course Outcomes for Unit 2: CO2
3 Virtualization
3.1. Introduction to Virtualization concept & Hypervisors
3.2. Pros and Cons of Virtualization
3.3. Machine Image, Virtual Machine (VM) 25 12
3.4. Xen: Para virtualization, VMware: Full Virtualization
3.5. Microsoft Hyper-V
3.6. Open-Source Virtualization Manager
*Mapping of Course Outcomes for Unit 3: CO3
4 Cloud Architecture
4.1 Web Services: SOAP and REST
4.2. Relating SOA and Cloud Computing.
4.3. Service Level Agreement (SLA), Billing, Pricing,
and Support 25 12
4.4. Cloud Computing Architecture
4.5. Multi Cloud Environment
4.6. Edge Computing Concepts
4.7. Cloud Bursting
*Mapping of Course Outcomes for Unit 4: CO4
5 Fundamentals of Cloud Platforms
5.1. Commercial cloud computing Infrastructures.
5.2. Amazon Web Services (AWS)
5.3. Google Cloud Platform (GCP) 15 6
5.4. Microsoft Azure (M. Azure)
5.5. Sales Force
5.6. IBM Cloud
*Mapping of Course Outcomes for Unit 5: CO5
Learning Resources

Text Books
 Cloud Computing Concepts, Technology & Architecture by Thomas Erl,
 Zaigham Mahmood, and Ricardo Puttin
 Mastering Cloud Computing by Rajkumar Buyya, Christian Vecchiola,
 S. Thamarai Selvi - McGraw Hill Education (India) Private Limited,
 Cloud Computing Web –Based Applications that change the way you
 work and Collaborate Online by Michael Miller, Pearson
 Cloud Computing for Dummies by Judith Hurwitz, Robin Bloor, Marcia
 Kaufman, FernHalper

Reference Books:
 Cloud Computing Bible by Barrie Sosinsky, Wiley India Pvt. Ltd,
 Cloud Computing: Automating the Virtualized Data Center

Page 33/177
 Curriculum for MCA, Semester I to IV (Pattern 2024) - Savitribai Phule Pune University

 Cloud Computing by Dr. Kumar Saurabh ,Wiley–India

 Cloud computing: A practical approach by Anthony T. Velte, Tata
 McGraw-Hill

Recommended Learning Material

 [Link]
 [Link]
 [Link]

Recommended Certification:
 Amazon Web Services (AWS)
 Google Cloud Platform (GCP)
 Microsoft Azure ([Link])
 Sales Force
 IBM Cloud

Page 34/177