{"id":8169,"date":"2024-04-04T11:34:42","date_gmt":"2024-04-04T11:34:42","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/5309b-non-relational-database-management-system-lab-syllabus-for-robotics-process-automation-6th-sem-2021-revision-sitttr-professional-elective-ii\/"},"modified":"2024-04-04T11:34:42","modified_gmt":"2024-04-04T11:34:42","slug":"5309b-non-relational-database-management-system-lab-syllabus-for-robotics-process-automation-6th-sem-2021-revision-sitttr-professional-elective-ii","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/5309b-non-relational-database-management-system-lab-syllabus-for-robotics-process-automation-6th-sem-2021-revision-sitttr-professional-elective-ii\/","title":{"rendered":"5309B: Non Relational Database Management System Lab Syllabus for Robotics Process Automation 6th Sem 2021 Revision SITTTR (Professional Elective-II)"},"content":{"rendered":"<p align=\"justify\">Non Relational Database Management System Lab detailed syllabus for Robotics Process Automation (RP) for 2021 revision curriculum has been taken from the <a class=\"rank-math-link\" href=\"http:\/\/www.sitttrkerala.ac.in\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">SITTTRs<\/a> 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. <\/p>\n<p align=\"justify\">For Robotics Process Automation 6th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/sitttr-diploma-robotics-process-automation-rp-syllabus-for-6th-sem-2021-revision\">Robotics Process Automation (RP) 6th Sem 2021 regulation scheme<\/a>. For Professional Elective-II scheme and its subjects refer to <a class=\"rank-math-link\" href=\"..\/sitttr-robotics-process-automation-6th-sem-professional-elective-ii-syllabus-2021-revision\">Robotics Process Automation (RP) Professional Elective-II syllabus scheme<\/a>. The detailed syllabus of non relational database management system lab is as follows. <\/p>\n<p><h4>Course Objectives:<\/h4>\n<ul>\n<li>Familiarization of No-SQL databases.<\/li>\n<li>Understand the basic operations using Mongodb.<\/li>\n<li>Exercise the different functions used in Mongodb.<\/li>\n<li>To obtain Practical Experience Working with emerging trends.<\/li>\n<\/ul>\n<p><h4>Course Outcomes:<\/h4>\n<p>On completion of the course student will be able to:<\/p>\n<ol>\n<li>Familiarization of No-SQL databases<\/li>\n<li>Analyze various basic operators in MongoDB<\/li>\n<li>Use of different functions in Mongodb<\/li>\n<li>Establish a database connectivity<\/li>\n<\/ol>\n<p><h4>Module 1:<\/h4>\n<ol>\n<li>Familiarization of MongoDB<\/li>\n<li>Familiarization of Cassandra<\/li>\n<\/ol>\n<p><h4>Module 2:<\/h4>\n<ol>\n<li>Student Database i) Create database, Create collection, Drop collection and database<\/li>\n<li>ii) Do the operations, insert data, find, find one, sort<\/li>\n<li>iii) Do the operations limit, skip, distinct, projection.<\/li>\n<li>Update modifiers ($set, $unset, $inc, $push, $pushAll, $pull, $pullAll, $addToSet)<\/li>\n<\/ol>\n<p><h4>Module 3:<\/h4>\n<ol>\n<li>Indexing in mongodb<\/li>\n<li>Mongodb aggregation<\/li>\n<li>RDBMS Where Clause Equivalents in MongoDB<\/li>\n<li>MongoDB Delete Document<\/li>\n<\/ol>\n<p><h4>Module 4:<\/h4>\n<ol>\n<li>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<\/li>\n<\/ol>\n<p><h4>Micro Project<\/h4>\n<p>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<\/p>\n<ul>\n<li>Football statistics app<\/li>\n<li>Develop a content Management System<\/li>\n<li>Product Catalog Management<\/li>\n<\/ul>\n<p><h4>Text Books:<\/h4>\n<ol>\n<li>Adam Fowler, NoSQL for Dummies, John Wiley &amp; Sons, 2015<\/li>\n<li>NoSQL Data Models: Trends and Challenges (Computer Engineering: Databases and Big Data), Wiley, 2018<\/li>\n<\/ol>\n<p><h4>Online Resources<\/h4>\n<ol>\n<li>http:\/\/mdslab.unime.it\/sites\/default\/files\/mongodb_tutorial.pdf<\/li>\n<li>https:\/\/www.mongodb.com\/docs\/manual\/indexes\/<\/li>\n<li>https:\/\/cassandra.apache.org\/_\/index.html<\/li>\n<li>https:\/\/www.projectpro.io\/article\/mongodb-projects-ideas\/640<\/li>\n<\/ol>\n<p><h4><H4>List of Experiments:<\/H4><\/h4>\n<ol>\n<li>Familiarization of No SQL databases-Mongodb and Cassandra.<\/li>\n<li>Create a student database with the fields: (SRN, Sname, Degree, Sem, CGPA)<\/li>\n<ul>\n<li>Display all the documents<\/li>\n<li>Display all the students in<\/li>\n<li>Display all the students in ascending order<\/li>\n<li>Display first 5 students<\/li>\n<li>Display students 5,6,7<\/li>\n<li>List the degree of student &#8220;Rahul&#8221;&gt;<\/li>\n<li>Display students details of 5,6,7 in descending order of percentage<\/li>\n<li>Display the number of students in BCA<\/li>\n<li>Display all the degrees without _id<\/li>\n<li>Display all the distinct degrees<\/li>\n<li>Display all the BCA students with CGPA greater than 6, but less than 7.5<\/li>\n<li>Display all the students in BCA and in 6th Sem<\/li>\n<\/ul>\n<li>Create an employee database with the fields: {eid, ename, dept, desig, salary, yoj, address{dno,street, locality, city}<\/li>\n<ul>\n<li>Display all the employees with salary in range (50000, 75000<\/li>\n<li>Display all the employees with desig developer<\/li>\n<li>Display the Salary of Rahul<\/li>\n<li>Display the city of employee &#8220;Rahul<\/li>\n<li>Update the salary of developers by 5000 increment<\/li>\n<li>Add field age to employee &#8220;Rahul&#8221;&gt;<\/li>\n<li>Remove YOJ from &#8220;Rahul<\/li>\n<li>Add an array field project to &#8220;Rahul<\/li>\n<li>Add p2 and p3 project to &#8220;Rahul&#8221;<\/li>\n<li>Remove p3 from &#8220;Rahul&#8221;<\/li>\n<li>Add a new embedded object &#8220;contacts&#8221; with &#8220;email&#8221; and &#8220;phone&#8221; as array objects to &#8220;Rahul&#8221;<\/li>\n<li>Add two phone numbers to &#8220;Rahul&#8221;.<\/li>\n<\/ul>\n<li>Create a student database with the fields: {studentid, Sname,Age,section, subject }<\/li>\n<ul>\n<li>Insert multiple documents into the collection<\/li>\n<li>Create the index on name field in ascending order.<\/li>\n<li>Finding the indexes in a collection<\/li>\n<li>Drop indexes in a collection.<\/li>\n<li>Display the total number of students in one section only<\/li>\n<li>Display the details of students whose age is greater than 30 using match stage<\/li>\n<li>Display the distinct names and ages (non-repeating)<\/li>\n<li>Display the use of where clause<\/li>\n<\/ul>\n<li>Establish a database connectivity (Mongodb with Php)<\/li>\n<ul>\n<li>Make a connection and Select a database<\/li>\n<li>Create a collection<\/li>\n<li>Insert a document<\/li>\n<li>Find all documents<\/li>\n<li>Update a document<\/li>\n<li>Delete a document<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Robotics Process Automation, 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/sitttr\/rp\">Robotics Process Automation (RP) 6th Sem subject syllabuses for 2021 revision<\/a>. <\/p>\n<p align=\"justify\">To see the syllabus of all other branches of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-syllabus\/\"> SITTTR diploma all branches syllabus.<\/a>. <\/p>\n<p align=\"justify\">To see the results of Robotics Process Automation of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-results\/\"> SITTTR diploma results.<\/a>. <\/p>\n<p align=\"justify\">For all Robotics Process Automation academic calendars, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-academic-calendar\/\"> Robotics Process Automation all semesters academic calendar<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":2462,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[90],"tags":[],"class_list":["post-8169","post","type-post","status-publish","format-standard","hentry","category-rp"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/8169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/users\/2462"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/comments?post=8169"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/8169\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=8169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=8169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=8169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}