{"id":50799,"date":"2023-03-22T07:15:59","date_gmt":"2023-03-22T07:15:59","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/ad3381-database-design-and-management-laboratory-syllabus-for-aiml-2021-regulation\/"},"modified":"2023-03-22T07:15:59","modified_gmt":"2023-03-22T07:15:59","slug":"ad3381-database-design-and-management-laboratory-syllabus-for-aiml-2021-regulation","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/ad3381-database-design-and-management-laboratory-syllabus-for-aiml-2021-regulation\/","title":{"rendered":"AD3381: Database Design and Management Laboratory syllabus for AI&ML 2021 regulation"},"content":{"rendered":"

Database Design and Management Laboratory detailed syllabus for Artificial Intelligence & Machine Learning (AI&ML) for 2021 regulation curriculum has been taken from the Anna University<\/a> official website and presented for the AI&ML 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 Artificial Intelligence & Machine Learning 4th Sem scheme and its subjects, do visit AI&ML 4th Sem 2021 regulation scheme<\/a>. The detailed syllabus of database design and management laboratory is as follows. <\/p>\n

Database Design and Management Laboratory<\/title><\/p>\n<h4>Course Objectives:<\/h4>\n<ul>\n<li>To understand the database development life cycle<\/li>\n<li>To learn database design using conceptual modeling, Normalization<\/li>\n<li>To implement database using Data definition, Querying using SQL manipulation and SQL programming<\/li>\n<li>To implement database applications using IDE\/RAD tools<\/li>\n<li>To learn querying Object-relational databases<\/li>\n<\/ul>\n<h4>Suggestive Experiments<\/h4>\n<ol>\n<li>Database Development Life cycle:Problem definition and Requirement analysis Scope and Constraints<\/li>\n<li>Database design using Conceptual modeling (ER-EER) – top-down approach Mapping conceptual to relational database and validate using Normalization<\/li>\n<li>Implement the database using SQL Data definition with constraints, Views<\/li>\n<li>Query the database using SQL Manipulation<\/li>\n<li>Querying\/Managing the database using SQL Programming- Stored Procedures\/Functions – Constraints and security using Triggers<\/li>\n<li>Database design using Normalization – bottom-up approach<\/li>\n<li>Develop database applications using IDE\/RAD tools (Eg., NetBeans,VisualStudio)<\/li>\n<li>Database design using EER-to-ODB mapping \/ UML class diagrams<\/li>\n<li>Object features of SQL-UDTs and sub-types, Tables using UDTs, Inheritance, Method definition<\/li>\n<li>Querying the Object-relational database using Objet Query language<\/li>\n<\/ol>\n<h4>Course Outcomes:<\/h4>\n<p> After the completion of this course, students will be able to:<\/p>\n<ul>\n<li>Understand the database development life cycle<\/li>\n<li>Design relational database using conceptual-to-relational mapping, Normalization<\/li>\n<li>Apply SQL for creation, manipulation and retrieval of data<\/li>\n<li>Develop a database applications for real-time problems<\/li>\n<li>Design and query object-relational databases<\/li>\n<p> HARDWARE:<\/p>\n<li>Standalone Desktops<\/li>\n<p> SOFTWARE:<\/p>\n<li>PostgreSQL<\/li>\n<\/ul>\n<p align=\"justify\">For detailed syllabus of all other subjects of Artificial Intelligence & Machine Learning, 2021 regulation curriculum do visit <a class=\"rank-math-link\" href=\"..\/category\/ai-ml+4th-sem\">AI&ML 4th Sem subject syllabuses for 2021 regulation<\/a>. <\/p>\n<p align=\"justify\">For all Artificial Intelligence & Machine Learning results, visit <a class=\"rank-math-link\" href=\"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-results\/\">Anna University AI&ML all semester results<\/a> direct link. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Design and Management Laboratory detailed syllabus for Artificial Intelligence & Machine Learning (AI&ML) for 2021 regulation curriculum has been taken from the Anna University official website and presented for […]<\/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":[47,157],"tags":[],"class_list":["post-50799","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-aiml"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/50799","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=50799"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/50799\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=50799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=50799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=50799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}