{"id":7938,"date":"2024-04-04T11:25:50","date_gmt":"2024-04-04T11:25:50","guid":{"rendered":"https:\/\/www.inspirenignite.com\/kl\/6159b-database-management-systems-lab-syllabus-for-computer-hardware-engineering-7th-sem-2021-revision-sitttr-professional-elective-iv\/"},"modified":"2024-04-04T11:25:50","modified_gmt":"2024-04-04T11:25:50","slug":"6159b-database-management-systems-lab-syllabus-for-computer-hardware-engineering-7th-sem-2021-revision-sitttr-professional-elective-iv","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/kl\/6159b-database-management-systems-lab-syllabus-for-computer-hardware-engineering-7th-sem-2021-revision-sitttr-professional-elective-iv\/","title":{"rendered":"6159B: Database Management Systems Lab Syllabus for Computer Hardware Engineering 7th Sem 2021 Revision SITTTR (Professional Elective-IV)"},"content":{"rendered":"<p align=\"justify\">Database Management Systems Lab detailed syllabus for Computer Hardware Engineering (CM) 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 Computer Hardware Engineering (CM) 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 Computer Hardware Engineering 7th Sem scheme and its subjects, do visit <a class=\"rank-math-link\" href=\"..\/sitttr-diploma-computer-hardware-engineering-cm-syllabus-for-7th-sem-2021-revision\">Computer Hardware Engineering (CM) 7th Sem 2021 regulation scheme<\/a>. For Professional Elective-IV scheme and its subjects refer to <a class=\"rank-math-link\" href=\"..\/sitttr-computer-hardware-engineering-7th-sem-professional-elective-iv-syllabus-2021-revision\">Computer Hardware Engineering (CM) Professional Elective-IV syllabus scheme<\/a>. The detailed syllabus of database management systems lab is as follows. <\/p>\n<p><h4>Course Objectives:<\/h4>\n<ul>\n<li>Impart to design, develop and manage relational databases using SQL.<\/li>\n<li>Understand the design of databases with constraints for real world applications.<\/li>\n<p> Database Management Systems should be registered along with this\n<\/ul>\n<\/p>\n<p><h4>Course Outcomes:<\/h4>\n<p>On com\tpletion of the course student will be able to:\t\t<\/p>\n<ol>\n<li>Make use of DDL, DML commands to construct and manage databases<\/li>\n<li>Make use of aggregate functions, join operations, views and nested queries<\/li>\n<li>Develop SQL programming using functions, procedures, cursors and trigger<\/li>\n<li>Design and develop databases for real world applications<\/li>\n<\/ol>\n<p><h4>Module 1:<\/h4>\n<ol>\n<li>Experiment with DDL commands-CREATE, ALTER, DROP<\/li>\n<li>Apply integrity constraints &#8211; PRIMARY KEY, NOT NULL, DEFAULT, CHECK, UNIQUE, FOREIGN KEY<\/li>\n<li>Apply DML commands &#8211; INSERT, SELECT, UPDATE and DELETE to manipulate databases<\/li>\n<li>Experiment with WHERE, DISTINCT, BETWEEN, ORDER BY, IN, LIKE, set operations in SELECT statements for data retrieval from the databases<\/li>\n<\/ol>\n<p><h4>Module 2:<\/h4>\n<ol>\n<li>Identify aggregate functions -SUM, AVG, COUNT, MIN, MAX &#8211; GROUP BY and HAVING clause<\/li>\n<li>Develop nested queries<\/li>\n<li>Develop SQL queries for inner and outer joins.<\/li>\n<li>Construct various views of the table<\/li>\n<\/ol>\n<p><h4>Module 3:<\/h4>\n<ol>\n<li>Experiment with stored procedures for simple tasks<\/li>\n<li>Utilize stored functions for database manipulations<\/li>\n<li>Experiment with cursors for database operations<\/li>\n<li>Develop SQL programs using triggers<\/li>\n<\/ol>\n<p><h4>Module 4:<\/h4>\n<ol>\n<li>Open Ended Project<\/li>\n<\/ol>\n<p><h4>Sample Open Ended Projects<\/h4>\n<p>(Not for End Semester Examination but compulsory to be included in Continuous Internal Evaluation.) Students can-do open-ended experiments as a group of 2-3. There is no duplication in experiments between groups.<br \/>\nConsider the following scenarios:<\/p>\n<ul>\n<li>Student information system<\/li>\n<li>Hostel management<\/li>\n<li>Library management<\/li>\n<li>Super market billing system<\/li>\n<p>Students should gather the required information, draw the ER diagrams, map them to the relative databases and normalize the tables.\n<\/ul>\n<\/p>\n<p><h4>Text Books:<\/h4>\n<ol>\n<li>Elmasri, Navathe ,Database Systems ,6th ed.,Pearson,2011<\/li>\n<\/ol>\n<p><h4>Reference Books:<\/h4>\n<ol>\n<li>Sliberschatz A., H. F. Korth and S. Sudarshan, Database System Concepts, 6th ed, McGraw Hill, 2011.<\/li>\n<li>ITL Education Solutions ltd, Introduction to Database Systems, Pearson,2011<\/li>\n<\/ol>\n<p><h4>Online Resources<\/h4>\n<ol>\n<li>https:\/\/www.w3schools.com\/sql<\/li>\n<li>https:\/\/www.tutorialspoint.com\/sql<\/li>\n<li>https:\/\/www.javatpoint.com\/sql<\/li>\n<li>https:\/\/www.guru99.com\/sql<\/li>\n<\/li>\n<\/ol>\n<p align=\"justify\">For detailed syllabus of all other subjects of Computer Hardware Engineering, 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/sitttr\/cm\">Computer Hardware Engineering (CM) 7th 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 Computer Hardware Engineering of diploma 2021 revision curriculum do visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-results\/\"> SITTTR diploma results.<\/a>. <\/p>\n<p align=\"justify\">For all Computer Hardware Engineering academic calendars, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/kl\/sitttr-academic-calendar\/\"> Computer Hardware Engineering all semesters academic calendar<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management Systems Lab detailed syllabus for Computer Hardware Engineering (CM) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Computer Hardware Engineering [&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":[78],"tags":[],"class_list":["post-7938","post","type-post","status-publish","format-standard","hentry","category-cm"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/7938","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=7938"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/posts\/7938\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/media?parent=7938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/categories?post=7938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/kl\/wp-json\/wp\/v2\/tags?post=7938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}