{"id":2714,"date":"2021-06-20T03:25:38","date_gmt":"2021-06-20T03:25:38","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/4255-relational-database-management-system-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr\/"},"modified":"2021-06-20T03:25:38","modified_gmt":"2021-06-20T03:25:38","slug":"4255-relational-database-management-system-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/4255-relational-database-management-system-kl-diploma-syllabus-for-ca-bm-4th-sem-2015-revision-sitttr\/","title":{"rendered":"4255: Relational Database Management System KL Diploma Syllabus for CA&BM 4th Sem 2015 Revision SITTTR"},"content":{"rendered":"

Relational Database Management System detailed syllabus for Computer Application & Business Management (CA&BM) for 2015 revision curriculum has been taken from the SITTTRs<\/a> official website and presented for the CA&BM 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 Computer Application & Business Management 4th Sem scheme and its subjects, do visit CA&BM 4th Sem 2015 revision scheme<\/a>. The detailed syllabus of relational database management system is as follows. <\/p>\n

Relational Database Management System<\/title><\/p>\n<h4>Course General 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 – 1<\/p>\n<ol>\n<li>Understand Database\n<ol type=\"i\">\n<li>Define Field, Record, Database<\/li>\n<li>Distinguish between Physical record -and Logical Record<\/li>\n<li>Explain Advantages of DBMS<\/li>\n<li>Understand Schema, Subschema, – Instances, Three schema architecture<\/li>\n<li>Define data independence.<\/li>\n<li>Distinguish between Logical data independence and Physical data independence<\/li>\n<\/ol>\n<\/li>\n<li>Know Database system structure(Architecture)\n<ol type=\"i\">\n<li>Explain Storage manager, Query processor, Disk storage, Database Users<\/li>\n<li>Distinguish Database Languages – DDL , DML,DCL<\/li>\n<li>Explain various Database system application architectures like Centralized DBMS architecture, Basic client\/server architecture, Two tier client\/server architectures, and three tier client\/server architectures<\/li>\n<\/ol>\n<\/li>\n<li>Understanding Data Models\n<ol type=\"i\">\n<li>Explain ER model<\/li>\n<li>Define Entity, Attribute, Keys, Relationship types, Relationship set<\/li>\n<li>Define Primary key, Candidate key, Super key<\/li>\n<li>Explain ER diagram, Weak entity set<\/li>\n<li>Compare ER Model and Enhanced ER Model<\/li>\n<li>Describe EER Model: Subclasses \u00e2\u20ac\u201c Super classes \u00e2\u20ac\u201c Inheritance \u00e2\u20ac\u201c Specialisation \u00e2\u20ac\u201c Generalisation<\/li>\n<li>Define Unified Modelling Language- Class diagram<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – 2<\/p>\n<ol>\n<li>Understand Relational model Concepts\n<ol type=\"i\">\n<li>Define Domains, Attributes, Tuples<\/li>\n<li>Explain Mapping ER model to Relational model<\/li>\n<li>Explain Constraints: Domain constraints, Key constraints, Entity integrity, Referential integrity, Foreign keys<\/li>\n<\/ol>\n<\/li>\n<li>Understand Relational algebra operations\n<ol type=\"i\">\n<li>Explain the following operations with examples: Select, Project, Rename, Union, Intersection, Difference, Cartesian Product, Division, Join, Equijoin, Natural join<\/li>\n<\/ol>\n<\/li>\n<li>Understand Relational database design\n<ol type=\"i\">\n<li>Explain design guidelines for relation schema<\/li>\n<li>Define Functional dependency<\/li>\n<li>Define Normalization<\/li>\n<li>Explain normal forms: 1NF \u00e2\u20ac\u201c 2NF \u00e2\u20ac\u201c 3NF \u00e2\u20ac\u201c Boyce Codd Normal Form<\/li>\n<li>Explain Decomposition, Dependency preservation, Multi-valued dependencies<\/li>\n<li>Explain 4NF with example<\/li>\n<li>Explain Join dependencies and define 5NF<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – 3<\/p>\n<ol>\n<li>Understand SQL\n<ol type=\"i\">\n<li>Explain features of SQL<\/li>\n<li>Explain Data types in SQL<\/li>\n<li>Differentiate Domains, attributes, and tuples<\/li>\n<\/ol>\n<\/li>\n<li>Creation of Table\n<ol type=\"i\">\n<li>Explain CREATE TABLE command<\/li>\n<li>Explain Constraints: NULL, DEFAULT,CHECK, PRIMARY KEY, UNIQUE, referential Integrity<\/li>\n<li>Explain DROP TABLE Command , ALTER TABLE<\/li>\n<li>Explain commands for creating and roping indexes CREATE INDEX, CREATE UNIQUE INDEX, DROP INDEX<\/li>\n<li>Explain SELECT statements with WHERE, ORDER BY clause with examples<\/li>\n<li>Describe UPDATE Statement, INSERT, DELETE with example<\/li>\n<li>Explain Nested queries, tuples and multi set comparison, Correlated nested queries<\/li>\n<li>Explain EXISTS and UNIQUE functions<\/li>\n<li>Explain explicit sets and renaming of attributes<\/li>\n<li>Explain Joining tables – aggregate functions<\/li>\n<li>Explain grouping: GROUP BY, HAVING clauses<\/li>\n<li>Explain BEGIN TRANS, COMMITT, ROLL BACK, SAVE POINT<\/li>\n<li>Explain Views: Advantages, Creation and Updation<\/li>\n<li>Explain Query optimization<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p> MODULE – 4<\/p>\n<ol>\n<li>Understand advanced SQL\n<ol type=\"i\">\n<li>Define triggers and cursors<\/li>\n<li>Explain reports and forms<\/li>\n<li>Explain stored procedures and functions<\/li>\n<li>Explain how Procedures are invoked from Interface<\/li>\n<\/ol>\n<\/li>\n<li>Understand Embedded SQL\n<ol type=\"i\">\n<li>Understand about Embedded SQL statements and its application<\/li>\n<li>Explain retrieving single tuples with embedded SQL<\/li>\n<li>Explain retrieving multiple tuples with embedded SQL using cursor<\/li>\n<li>Explain dynamic SQL by specifying queries at run time<\/li>\n<\/ol>\n<\/li>\n<li>Understand Transaction management\n<ol type=\"i\">\n<li>Define Transaction<\/li>\n<li>Explain transaction concepts<\/li>\n<li>Differentiate Properties of transactions, , Transaction Sates<\/li>\n<li>Explain Concurrent Executions<\/li>\n<li>Explain Serializability<\/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 Relational model – Concepts – Constraints – Key constraints – Referential integrity – Foreign keys Relational algebra operations -Unary & Binary relational operations Relational database design -Guidelines- Functional dependency – Normalization – 1NF – 2NF – 3NF – Boyce Codd Normal Form – Decomposition – Dependency preservation – Multivalued dependencies -4NF – Join dependencies – 5NF\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 Triggers, cursers – stored procedures and functions, embedded SQL, Retrieving single tuples with embedded SQL Dynamic SQL – specifying queries at run time using dynamic SQL Transaction management-Transaction concepts -Properties of transactions-Sates-Concurrent Executions-Serializability\n<\/p>\n<h4>BOOKS RECOMMENDED<\/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<p align=\"justify\">For detailed syllabus of all other subjects of Computer Application & Business Management, 2015 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/ca-bm+4th-sem\">CA&BM 4th 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>Relational Database Management System detailed syllabus for Computer Application & Business Management (CA&BM) for 2015 revision curriculum has been taken from the SITTTRs official website and presented for the CA&BM […]<\/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,46],"tags":[],"class_list":["post-2714","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-computer-application-business-management"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/2714","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=2714"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/2714\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=2714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=2714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=2714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}