SARVAJANIK UNIVERSITY
Sarvajanik College of Engineering and Technology
Master of Computer Applications
MCA Semester III
Subject Name: NoSQL Databases Subject Code: MTCA13303
Type of course: Professional Core Course
Prerequisite: Basic Knowledge of Databases, Basic understanding of HTTP, Basic
understanding of JavaScript, Basic understanding of JSON
List of Courses where this course will be prerequisite:
MongoDB, Python, PHP
Rationale: After studying this course, students will be able to Integrate MongoDB with
Java, Node.js, Python and PHP application.
Teaching and Examination Scheme:
TEACHING SCHEME Theory Marks Practical Marks Total
L T P C TEE CA1 CA2 TEP CA3
3 0 2 4 60 25 15 60 40 200
CA1: Continuous Assessment (assignments/projects/open book tests/closed book tests CA2:
Sincerity in attending classes/class tests/ timely submissions of assignments/self-learning
attitude/solving advanced problems TEE: Term End Examination TEP: Term End Practical Exam
(Performance and viva on practical skills learned in course) CA3: Regular submission of Lab
work/Quality of work submitted/Active participation in lab sessions/viva on practical skills learned
in course
Page 1 of 4
w.e.f. AY 2022-23
SARVAJANIK UNIVERSITY
Sarvajanik College of Engineering and Technology
Master of Computer Applications
Content:
Sr. Content Teaching Module
No. Hrs. Weightage
1 Basics of NoSQL Database : 07 15%
Introduction to NoSQL database, Difference between RDBMS
and NoSQL databases, Types of NoSQL: Key-Value database,
Document-based database, Column-based database, Graph-based
database, CAP theorem, The Value of Relational Databases,
Getting at Persistent Data, Concurrency, Integration, NoSQL,Key
Points.
2 Introduction to MongoDB, Overview of NoSQL databases, 16 33%
MongoDB introduction: history, document based storage, key
features, advantages, MongoDB shell, Data modeling in
MongoDB, MongoDB data types, Database create and drop,
Collection create and drop
MongoDB NoSQL Database Setup
3 CRUD operations CRUD operations in MongoDB, Relationships 8 18%
in MongoDB, Indexing, Sorting, Aggregate functions, limit(),
skip()
4 Backup and Restore Data backup and restore, Cassandra vs 6 12%
MongoDB, CouchDB vs. MongoDB, Redis vs MongoDB
5 Connectivity Java MongoDB, PHP MongoDB. Python MongoDB 8 22%
Suggested Specification table with Marks (Theory):
Distribution of Theory Marks
R Level U Level A Level N Level E Level C Level
20 20 15 15 15 15
Legends: R: Remembrance; U: Understanding; A: Application, N: Analyze and E: Evaluate
C: Create and above Levels (Revised Bloom’s Taxonomy)
Note: This specification table shall be treated as a general guideline for students and teachers. The
actual distribution of marks in the question paper may vary slightly from above table.
Page 2 of 4
w.e.f. AY 2022-23
SARVAJANIK UNIVERSITY
Sarvajanik College of Engineering and Technology
Master of Computer Applications
Reference Books:
Sr no Title of book Author(s) Publisher and Year of Publication
/article details like publicati Edition
ISBN on
1 MongoDB in Action Kyle Banker, Manning 2016 2nd Edition
Second Edition Peter Bakkum, Publications Co
Shaun Verch ISBN: 978-
,Douglas Garrett, 9351199359
Tim Hawkins
2 MongoDB The Kristina O’Reilly 2013 2nd Edition
Definitive Guide Chodorow ISBN: 978-
9351102694
Course Outcomes:
Sr. CO statement Marks %
No. weightage
CO-1 Develop competency in describing how NoSQL databases differ from 20%
relational databases from a theoretical perspective
CO-2 Understand the Mongo as a datastore 20%
CO-3 Perform CRUD operations 30%
CO-4 Index Mongo Collections 15%
CO-5 Use data backup and restore techniques 15%
Mapping with POs:
PO PO PO PO PO PO PO PO PO PO PO PO PS PS PS
1 2 3 4 5 6 7 8 9 10 11 12 O1 O2 O3
CO-1 3 3 0 0 2 2 0 2 2 3 0 3
CO-2 3 3 2 0 2 0 0 2 2 0 0 3
CO-3 3 3 0 2 3 0 0 0 2 2 2 3
Page 3 of 4
w.e.f. AY 2022-23
SARVAJANIK UNIVERSITY
Sarvajanik College of Engineering and Technology
Master of Computer Applications
CO-4 3 3 0 1 3 0 0 0 2 2 2 3
CO-5 3 3 0 1 3 0 0 0 1 2 3 3
Rationa
le*
Rationale*: Explaining why it is matching this particular program outcome
List of Open learning website:
● https://www.mongodb.com/basics
● https://www.tutorialspoint.com/mongodb/index.htm
List of Open Source Software:
FOR LAB SESSIONS:
List of Experiments:
Sr. No Particulars
1 MongoDB Create Database - How to Create Database & Collection in MongoDB
2 Add MongoDB Array using insert() — Learn With Example
3 Mongodb Primary Key — Example to set _id field with ObjectId()
4 MongoDB Query Document — using find() method with Examples
5 MongoDB Cursor Tutorial — Learn with EXAMPLE
6 MongoDB Sort() & Limit() — MongoDB order with Sort() & Limit() Query
7 MongoDB Count() & Remove() Functions — Learn With Example
8 MongoDB Update() Document — Learn With Example
9 MongoDB Backup Methods — MongoDB Security, Monitoring & Backup
(Mongodump)
10 MongoDB Regular Expression — Use a Regular Expression $Regex in MongoDB
Major Equipment Needed:
NA
Page 4 of 4
w.e.f. AY 2022-23
