{"id":6663,"date":"2024-04-04T10:28:54","date_gmt":"2024-04-04T10:28:54","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/4323-database-management-system-syllabus-for-communication-computer-network-4th-sem-2021-revision-sitttr\/"},"modified":"2024-04-04T10:28:54","modified_gmt":"2024-04-04T10:28:54","slug":"4323-database-management-system-syllabus-for-communication-computer-network-4th-sem-2021-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/4323-database-management-system-syllabus-for-communication-computer-network-4th-sem-2021-revision-sitttr\/","title":{"rendered":"4323: Database Management System Syllabus for Communication &amp; Computer Network 4th Sem 2021 Revision SITTTR"},"content":{"rendered":"<p align=\"justify\">Database Management System detailed syllabus for Communication &amp; Computer Network (CN) 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 Communication &amp; Computer Network 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 Communication &amp; Computer Network 4th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/sitttr-diploma-communication-computer-network-cn-syllabus-for-4th-sem-2021-revision\">Communication &amp; Computer Network (CN) 4th Sem 2021 revision scheme<\/a>. The detailed syllabus of database management system is as follows. <\/p>\n<p><h4>Course Objectives:<\/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<p><h4>Course Outcomes:<\/h4>\n<p>On completion of the course, the student will be able to:<\/p>\n<ol>\n<li>To describe about Database systems<\/li>\n<li>To illustrate Database Design.<\/li>\n<li>To write queries in SQL<\/li>\n<li>To relate Emerging Technologies<\/li>\n<\/ol>\n<p><h4>Module 1:<\/h4>\n<p>Database Systems Database Systems &#8211; Data &#8211; Information &#8211; Record &#8211; Field &#8211; Need of database system -Advantages and Disadvantages &#8211; application areas &#8211; people who interact with database -Three schema Architecture &#8211; Data independence &#8211; Data models &#8211; Database Schema versus database instance &#8211; Component modules of DBMS- Classification of DBMS.\n<\/p>\n<p><h4>Module 2:<\/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<p><h4>Module 3:<\/h4>\n<p>Structured Query Language SQL &#8211; Features of SQL &#8211; Data types in SQL &#8211; CREATE TABLE command, Constraints &#8211; NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity &#8211; INSERT, UPDATE and DELETE command &#8211; SELECT statements with WHERE, ORDER BY clause &#8211; Aggregate and scalar functions in SELECT statements. Database connectivity using JDBC\/ ODBC\n<\/p>\n<p><h4>Module 4:<\/h4>\n<p>Database Design and Emerging Technologies Normalisation -Functional Dependency &#8211; Decomposition &#8211;.Introduction to Data Mining and Data warehousing (Only theoretical concepts).\n<\/p>\n<p><h4>Text Books:<\/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<p><h4>Reference Books:<\/h4>\n<ol>\n<li>Introduction to Database Systems &#8211; ITL Education Solutions Ltd &#8211; PEARSON-2010<\/li>\n<li>Database system concepts &#8211; Silberschatz, Korth, and Sudarshan (TMH)-Sixth Edition<\/li>\n<li>SQL for professional &#8211; Swapne &amp; Rajesh Naik<\/li>\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<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<p align=\"justify\">For detailed syllabus of all other subjects of Communication &amp; Computer Network (CN), 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/sitttr\/cn\">Communication &amp; Computer Network 4th 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 Communication &amp; Computer Network (CN) of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-results\/\"> SITTTR diploma Communication &amp; Computer Network (CN) results.<\/a>. <\/p>\n<p align=\"justify\">For all Communication &amp; Computer Network academic calendars, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-academic-calendar\/\"> Communication &amp; Computer Network all semesters academic calendar<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management System detailed syllabus for Communication &amp; Computer Network (CN) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Communication &amp; Computer [&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":[35,75],"tags":[],"class_list":["post-6663","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-cp"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6663","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=6663"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/6663\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=6663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=6663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=6663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}