{"id":396,"date":"2021-12-31T11:43:44","date_gmt":"2021-12-31T11:43:44","guid":{"rendered":"https:\/\/www.inspirenignite.com\/rj\/4cai4-22-database-management-system-lab-syllabus-for-ai-4th-sem-2021-22-regulation-rtu\/"},"modified":"2021-12-31T11:43:44","modified_gmt":"2021-12-31T11:43:44","slug":"4cai4-22-database-management-system-lab-syllabus-for-ai-4th-sem-2021-22-regulation-rtu","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/rj\/4cai4-22-database-management-system-lab-syllabus-for-ai-4th-sem-2021-22-regulation-rtu\/","title":{"rendered":"4CAI4-22: Database Management System Lab Syllabus for AI 4th Sem 2021-22 Regulation RTU"},"content":{"rendered":"<p align=\"justify\">Database Management System Lab detailed syllabus for Artificial Intellignece (AI) for 2021-22 regulation curriculum has been taken from the <a class=\"rank-math-link\" href=\"https:\/\/www.rtu.ac.in\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Rajasthan Technical University<\/a> official website and presented for the artificial intellignece 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 Artificial Intellignece 4th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/artificial-intellignece-ai-syllabus-for-4th-sem-2021-22-regulation-rtu\">AI 4th Sem 2021-22 regulation scheme<\/a>. The detailed syllabus of database management system lab is as follows. <\/p>\n<p>  <title>Database Management System Lab<\/title><\/p>\n<h4>List of Experiments:<\/h4>\n<ol>\n<li>Design a Database and create required tables. For e.g. Bank, College Database<\/li>\n<li>Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.<\/li>\n<li>Write a SQL statement for implementing ALTER,UPDATE and DELETE.<\/li>\n<li>Write the queries to implement the joins.<\/li>\n<li>Write the query for implementing the following functions: MAX (), MIN (), AVG () and COUNT ().<\/li>\n<li>Write the query to implement the concept of Integrity constrains.<\/li>\n<li>Write the query to create the views.<\/li>\n<li>Perform the queries for triggers.<\/li>\n<li>Perform the following operation for demonstrating the insertion , updation and deletion<\/li>\n<li>Using the referential integrity constraints.<\/li>\n<li>Write the query for creating the users and their role.<\/li>\n<\/ol>\n<h4>Data Base Designing Project:<\/h4>\n<p>  For better understanding students (group of 3-4 students) should design data base for any data base project, understand the requirement and design methodology of project by its own.<br \/>\n  <i>Some Example of Data Base Design Project Like:<\/i> College management system, Inventory management system and Hospital management system.<\/p>\n<p align=\"justify\">For detailed syllabus of all other subjects of Artificial Intellignece, 2021-22 regulation curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/ai+4th-sem\">AI 4th Sem subject syllabuses for 2021-22 regulation<\/a>. <\/p>\n<p align=\"justify\">For all Artificial Intellignece results, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/rj\/category\/results\/\">Rajasthan Technical University artificial intellignece all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management System Lab detailed syllabus for Artificial Intellignece (AI) for 2021-22 regulation curriculum has been taken from the Rajasthan Technical University official website and presented for the artificial intellignece [&hellip;]<\/p>\n","protected":false},"author":2491,"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":[8,24],"tags":[],"class_list":["post-396","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-ai"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/posts\/396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/users\/2491"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/comments?post=396"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/posts\/396\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/media?parent=396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/categories?post=396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/rj\/wp-json\/wp\/v2\/tags?post=396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}