{"id":3070,"date":"2021-06-20T03:37:49","date_gmt":"2021-06-20T03:37:49","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/3132-database-management-system-kl-diploma-syllabus-for-it-3rd-sem-2015-revision-sitttr\/"},"modified":"2021-06-20T03:37:49","modified_gmt":"2021-06-20T03:37:49","slug":"3132-database-management-system-kl-diploma-syllabus-for-it-3rd-sem-2015-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/3132-database-management-system-kl-diploma-syllabus-for-it-3rd-sem-2015-revision-sitttr\/","title":{"rendered":"3132: Database Management System KL Diploma Syllabus for IT 3rd Sem 2015 Revision SITTTR"},"content":{"rendered":"

Database Management System detailed syllabus for Information Technology (IT) for 2015 revision curriculum has been taken from the SITTTRs<\/a> official website and presented for the IT 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

For Information Technology 3rd Sem scheme and its subjects, do visit IT 3rd Sem 2015 revision scheme<\/a>. The detailed syllabus of database management system is as follows. <\/p>\n

Database Management System<\/title><\/p>\n<h4>Course Outcomes:<\/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’s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&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>Specific Outcomes:<\/h4>\n<p align=\"justify\">\n MODULE – I Database systems<\/p>\n<ol>\n<li>To Understand Database systems\n<ol type=\"i\">\n<li>Define data, information, field, record, file, and database<\/li>\n<li>Define DBMS<\/li>\n<li>Explain the advantages of DBMS<\/li>\n<li>Describe the applications of DBMS<\/li>\n<li>List the Database Users.<\/li>\n<li>Define instance, schema and subschema<\/li>\n<li>Explain Three Schema architecture with diagram<\/li>\n<li>Explain Data Independence – Logical Data Independence and Physical Data Independence<\/li>\n<li>Describe Conceptual Model, representation and physical model<\/li>\n<li>Explain hierarchical, network and relational models<\/li>\n<li>Describe DBMS Languages – DDL, DML and DCL<\/li>\n<li>Explain Component Modules of DBMS<\/li>\n<li>Centralised and Client-Server Database Systems<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – II Database Design<\/p>\n<ol>\n<li>To Understand Database Design\n<ol type=\"i\">\n<li>Explain Relational model concepts<\/li>\n<li>Define Domains, Attributes, Tuples , Instances, relations and relational schema<\/li>\n<li>Explain Keys – Super key, candidate key, composite key, primary key and foreign key<\/li>\n<li>Explain E-R Model with example<\/li>\n<li>Discuss the features of Enhanced E-R diagram<\/li>\n<li>Explain Relational Algebra and fundamental operations<\/li>\n<li>Explain Additional Operations – Natural-Join, Outer Join<\/li>\n<li>Explain the mapping of E-R model to relational model<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – III Structured Query Language<\/p>\n<ol>\n<li>To Understand SQL\n<ol type=\"i\">\n<li>Explain features of SQL<\/li>\n<li>Explain Data types in SQL<\/li>\n<li>Explain CREATE TABLE command with constraints NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity<\/li>\n<li>Explain INSERT, UPDATE and DELETE commands<\/li>\n<li>Explain SELECT statements with WHERE, ORDER BY clause with examples<\/li>\n<li>Describe the use of Aggregate and scalar functions in SELECT statements with examples<\/li>\n<li>Explain SELECT statements with GROUP BY, HAVING clauses with examples<\/li>\n<li>Explain Nested queries, sub queries<\/li>\n<li>Describe DROP TABLE and ALTER TABLE command<\/li>\n<li>Explain what are inner join and outer join<\/li>\n<li>Explain how views are created and used<\/li>\n<li>Explain transactions<\/li>\n<li>Describe integrity constraints<\/li>\n<li>Explain how index creation is done<\/li>\n<li>Explain about authorizations on data and granting & revoking of privileges<\/li>\n<li>Explain how to create and use functions, procedure, cursor and trigger<\/li>\n<li>Explain Database connectivity using JDBC\/ ODBC<\/li>\n<li>Explain how to connect to a database<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – IV Emerging Technologies<\/p>\n<ol>\n<li>To Understand Normalisation\n<ol type=\"i\">\n<li>State functional dependency<\/li>\n<li>Explain the need of normalisation<\/li>\n<li>Describe decomposition of a table with examples<\/li>\n<\/ol>\n<\/li>\n<li>To Understand Emerging Technologies\n<ol type=\"i\">\n<li>Explain Object Oriented Concepts<\/li>\n<li>Describe Object Identity, Object Structure<\/li>\n<li>Explain Parallel DBMS.<\/li>\n<li>Describe Distributed DBMS<\/li>\n<li>Explain Mobile Databases<\/li>\n<li>State Data Mining Technology<\/li>\n<li>Describe Data Warehousing<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h4>MODULE – I<\/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’s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&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>MODULE – II<\/h4>\n<p align=\"justify\">\n Database Design Relational Model Concepts – Domain – Attribute – tuple – instance – relation – relational schema -Keys – E R Model – Enhanced E R diagram – sub class – super class – inheritance – specialisation -generalisation – UML class diagram – Relational Algebra operations – select, project, Union, Set Difference, Cartesian Product and Rename – additional operations – Natural-Join, Outer Join – mapping of E-R model to relational model\n<\/p>\n<h4>MODULE – III<\/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’s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&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>MODULE – IV<\/h4>\n<p align=\"justify\">\n Emerging Technologies Normalisation -Functional Dependency – Decomposition — Introduction to Object oriented databases-Features-Object identity- Object Structure. Parallel DBMS – Overview – Architecture – Distributed DBMS -Advantages Mobile Databases – Concept .Databases and Internet.Introduction to Data Mining and Data warehousing.\n<\/p>\n<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’s lives easier.<\/b><br \/><a class=\"rank-math-link\" href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&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>Reference Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Introduction to Database Systems – ITL Education Solutions Ltd – PEARSON- 2010<\/li>\n<li>Database system concepts – Silberschatz, Korth, and Sudarshan (TMH)-Sixth Edition<\/li>\n<li>SQL for professional – Swapne & Rajesh Naik<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Information Technology, 2015 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/it+3rd-sem\">IT 3rd Sem subject syllabuses for 2015 revision<\/a>. <\/p>\n<p align=\"justify\">To see the syllabus of all other branches of diploma 2015 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/kerala-diploma-syllabus\/\">all branches of SITTTR diploma 2015 revision<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management System detailed syllabus for Information Technology (IT) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the IT students. For course code, […]<\/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":[34,52],"tags":[],"class_list":["post-3070","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-it"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/3070","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=3070"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/3070\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=3070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=3070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=3070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}