{"id":34737,"date":"2021-05-22T13:18:59","date_gmt":"2021-05-22T13:18:59","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/oit551-database-management-systems-syllabus-for-production-6th-sem-2019-regulation-anna-university-open-elective-i\/"},"modified":"2021-05-22T13:18:59","modified_gmt":"2021-05-22T13:18:59","slug":"oit551-database-management-systems-syllabus-for-production-6th-sem-2019-regulation-anna-university-open-elective-i","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/oit551-database-management-systems-syllabus-for-production-6th-sem-2019-regulation-anna-university-open-elective-i\/","title":{"rendered":"OIT551: Database Management Systems Syllabus for Production 6th Sem 2019 Regulation Anna University (Open Elective-I)"},"content":{"rendered":"<p align=\"justify\">Database Management Systems detailed syllabus for Production Engineering (Production) for 2019 regulation curriculum has been taken from the <a class=\"rank-math-link\" href=\"https:\/\/cac.annauniv.edu\/\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">Anna Universities<\/a> official website and presented for the Production 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 Production Engineering 6th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/production-engineering-production-syllabus-for-6th-sem-2019-regulation-anna-university\">Production 6th Sem 2019 regulation scheme<\/a>. For Open Elective-I scheme and its subjects refer to <a class=\"rank-math-link\" href=\"..\/open-elective-i-syllabus-for-production-6th-sem-2019-regulation-anna-university\">Production Open Elective-I syllabus scheme<\/a>. The detailed syllabus of database management systems is as follows. <\/p>\n<p>  <title>Database Management Systems<\/title><\/p>\n<h4>Course Objective:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete syllabus, results, class timetable, and many other features kindly download the <a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.   <\/p>\n<h4>Unit I<\/h4>\n<p align=\"justify\">\n<p><strong>Dbms and Conceptual Data Modeling<\/strong><br \/>\n  Purpose of Database System &#8211; Data independence &#8211; Data Models &#8211; Database System Architecture &#8211; Conceptual Data modeling: ER models &#8211; Enhanced-ER Model. Introduction to relational databases &#8211; Relational Model &#8211; Keys &#8211; ER-to-Relational Mapping. Modeling of a library management system.<\/p>\n<\/p>\n<h4>Unit II<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete syllabus, results, class timetable, and many other features kindly download the <a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.   <\/p>\n<h4>Unit III<\/h4>\n<p align=\"justify\">\n<p><strong>Database Programming<\/strong><br \/>\n  Database programming with function calls, stored procedures &#8211; views &#8211; triggers. Embedded SQL. ODBC connectivity with front end tools. Implementation using ODBC\/JDBC and SQL\/PSM, implementing functions, views, and triggers in MySQL \/ Oracle.<\/p>\n<\/p>\n<h4>Unit IV<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete syllabus, results, class timetable, and many other features kindly download the <a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.   <\/p>\n<h4>Unit V<\/h4>\n<p align=\"justify\">\n<p><strong>Advanced Topics<\/strong><br \/>\n  Database security issues &#8211; Discretionary access control &#8211; role based access &#8211; Encryption and public key infrastructures &#8211; challenges. Information Retrieval: IR Concepts, Retrieval Models, Queries in IR systems.<\/p>\n<\/p>\n<h4>Course Outcome:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete syllabus, results, class timetable, and many other features kindly download the <a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdfs platform to make students&#8217;s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&amp;pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>.   <\/p>\n<h4>Text Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, Sixth Edition , Pearson, 2011.<\/li>\n<li>Abraham Silberschatz, Henry F. Korth, S. Sudharshan, Database System Concepts, Sixth Edition, Tata McGraw Hill, 2011<\/li>\n<\/ol>\n<h4>References:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>C.J.Date, A.Kannan, S.Swamynathan, An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006.<\/li>\n<li>Raghu Ramakrishnan, Database Management Systemsll, Fourth Edition, McGraw-Hill College Publications, 2015.<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all the other subjects of Production Engineering 6th Sem, visit <a class=\"rank-math-link\" href=\"..\/category\/production+6th-sem\">Production 6th Sem subject syllabuses for 2019 regulation<\/a>. <\/p>\n<p align=\"justify\">For all Production Engineering results, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-results\/\">Anna University Production all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management Systems detailed syllabus for Production Engineering (Production) for 2019 regulation curriculum has been taken from the Anna Universities official website and presented for the Production students. For course [&hellip;]<\/p>\n","protected":false},"author":2297,"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":[63],"tags":[],"class_list":["post-34737","post","type-post","status-publish","format-standard","hentry","category-production"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/34737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/users\/2297"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=34737"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/34737\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=34737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=34737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=34737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}