5309B: Non Relational Database Management System Lab Syllabus for Robotics Process Automation 6th Sem 2021 Revision SITTTR (Professional Elective-II)

Non Relational Database Management System Lab detailed syllabus for Robotics Process Automation (RP) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Robotics Process Automation (RP) students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.

For Robotics Process Automation 6th Sem scheme and its subjects, do visit Robotics Process Automation (RP) 6th Sem 2021 regulation scheme. For Professional Elective-II scheme and its subjects refer to Robotics Process Automation (RP) Professional Elective-II syllabus scheme. The detailed syllabus of non relational database management system lab is as follows.

Course Objectives:

• Familiarization of No-SQL databases.
• Understand the basic operations using Mongodb.
• Exercise the different functions used in Mongodb.
• To obtain Practical Experience Working with emerging trends.

Course Outcomes:

On completion of the course student will be able to:

1. Familiarization of No-SQL databases
2. Analyze various basic operators in MongoDB
3. Use of different functions in Mongodb
4. Establish a database connectivity

Module 1:

1. Familiarization of MongoDB
2. Familiarization of Cassandra

Module 2:

1. Student Database i) Create database, Create collection, Drop collection and database
2. ii) Do the operations, insert data, find, find one, sort
3. iii) Do the operations limit, skip, distinct, projection.
4. Update modifiers ($set, $unset, $inc, $push, $pushAll, $pull, $pullAll, $addToSet)

Module 3:

1. Indexing in mongodb
2. Mongodb aggregation
3. RDBMS Where Clause Equivalents in MongoDB
4. MongoDB Delete Document

Module 4:

1. Mongodb with Php i) Make a connection and Select a database ii) Create a collection iii) Insert a document iv) Find all documents v) Update a document vi) Delete a document

Micro Project

Students are expected to do a micro project in database management system during the course for the purpose of continuous evaluation. This experiment shall be included in the bona-fide record. Example: Develop program such as

• Football statistics app
• Develop a content Management System
• Product Catalog Management

Text Books:

1. Adam Fowler, NoSQL for Dummies, John Wiley & Sons, 2015
2. NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data), Wiley, 2018

Online Resources

1. http://mdslab.unime.it/sites/default/files/mongodb_tutorial.pdf
2. https://www.mongodb.com/docs/manual/indexes/
3. https://cassandra.apache.org/_/index.html
4. https://www.projectpro.io/article/mongodb-projects-ideas/640

List of Experiments:

1. Familiarization of No SQL databases-Mongodb and Cassandra.
2. Create a student database with the fields: (SRN, Sname, Degree, Sem, CGPA)
• Display all the documents
• Display all the students in
• Display all the students in ascending order
• Display first 5 students
• Display students 5,6,7
• List the degree of student “Rahul”>
• Display students details of 5,6,7 in descending order of percentage
• Display the number of students in BCA
• Display all the degrees without _id
• Display all the distinct degrees
• Display all the BCA students with CGPA greater than 6, but less than 7.5
• Display all the students in BCA and in 6th Sem
3. Create an employee database with the fields: {eid, ename, dept, desig, salary, yoj, address{dno,street, locality, city}
• Display all the employees with salary in range (50000, 75000
• Display all the employees with desig developer
• Display the Salary of Rahul
• Display the city of employee “Rahul
• Update the salary of developers by 5000 increment
• Add field age to employee “Rahul”>
• Remove YOJ from “Rahul
• Add an array field project to “Rahul
• Add p2 and p3 project to “Rahul”
• Remove p3 from “Rahul”
• Add a new embedded object “contacts” with “email” and “phone” as array objects to “Rahul”
• Add two phone numbers to “Rahul”.
4. Create a student database with the fields: {studentid, Sname,Age,section, subject }
• Insert multiple documents into the collection
• Create the index on name field in ascending order.
• Finding the indexes in a collection
• Drop indexes in a collection.
• Display the total number of students in one section only
• Display the details of students whose age is greater than 30 using match stage
• Display the distinct names and ages (non-repeating)
• Display the use of where clause
5. Establish a database connectivity (Mongodb with Php)
• Make a connection and Select a database
• Create a collection
• Insert a document
• Find all documents
• Update a document
• Delete a document

For detailed syllabus of all other subjects of Robotics Process Automation, 2021 revision curriculum do visit Robotics Process Automation (RP) 6th Sem subject syllabuses for 2021 revision.

To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..

To see the results of Robotics Process Automation of diploma 2021 revision curriculum do visit SITTTR diploma results..

For all Robotics Process Automation academic calendars, visit Robotics Process Automation all semesters academic calendar direct link.