{"id":17415,"date":"2020-09-09T11:00:26","date_gmt":"2020-09-09T11:00:26","guid":{"rendered":"https:\/\/www.inspirenignite.com\/mh\/ec-46-b-database-management-syllabus-for-el-7th-sem-2017-dbatu-elective-ix\/"},"modified":"2020-09-09T11:00:26","modified_gmt":"2020-09-09T11:00:26","slug":"ec-46-b-database-management-syllabus-for-el-7th-sem-2017-dbatu-elective-ix","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/mh\/ec-46-b-database-management-syllabus-for-el-7th-sem-2017-dbatu-elective-ix\/","title":{"rendered":"EC 46 B: Database Management Syllabus for EL 7th Sem 2017 DBATU (Elective-IX)"},"content":{"rendered":"

Database Management detailed syllabus scheme for Electronics Engineering (EL), 2017 onwards has been taken from the DBATU<\/a> official website and presented for the Bachelor of Technology students. For Subject Code, Course Title, Lecutres, Tutorials, Practice, Credits, and other information, do visit full semester subjects post given below. <\/p>\n

For 7th Sem Scheme of Electronics Engineering (EL), 2017 Onwards, do visit EL 7th Sem Scheme, 2017 Onwards<\/a>. For the Elective-IX scheme of 7th Sem 2017 onwards, refer to EL 7th Sem Elective-IX Scheme 2017 Onwards<\/a>. The detail syllabus for database management is as follows.<\/p>\n

Database Management Syllabus for Electronics Engineering (EL) 4th Year 7th Sem 2017 DBATU<\/h2>\n

Database Management<\/title><\/p>\n<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 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 pdf platform to make students’s lives easier.<\/b><br \/><a 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>Course Outcomes:<\/h4>\n<ol>\n<li>Understand the basic concepts and appreciate the applications of database systems.<\/li>\n<li>Understand the basics of SQL and construct queries using SQL.<\/li>\n<li>Be familiar with a commercial relational database system (Oracle) by writing SQL using the system.<\/li>\n<li>Be familiar with the relational database theory, and be able to write relational algebra expressions for queries.<\/li>\n<li>Understand sound design principles for logical design of databases, including the E-R method and normalization approach.<\/li>\n<li>Be familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B-tree, and hashing.<\/li>\n<li>Understand the basics of query evaluation techniques and query optimization.<\/li>\n<li>Be familiar with the basic issues of transaction processing and concurrency control.<\/li>\n<\/ol>\n<h4>Unit 1<\/h4>\n<p> <strong>Introduction to DBMS<\/strong><br \/>\n <strong>Relational Model:<\/strong><br \/>\n Basic concepts, Attributes and Domains, Codd’s Rules, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram.<\/p>\n<h4>Unit 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 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 pdf platform to make students’s lives easier.<\/b><br \/><a 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>Unit 3<\/h4>\n<p> <strong>Relational Database Design<\/strong><br \/>\n Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set, canonical cover, Decomposition: lossless join decomposition and dependency preservation, The Process of Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.<\/p>\n<h4>Unit 4<\/h4>\n<p> <strong>File Systems and Query Processing<\/strong><br \/>\n Overview, Measures of query cost, Selection and join operations, Evaluation of Expressions, Introduction to Query Optimization, Estimation, Transformation of Relational Expressions.<\/p>\n<h4>Unit 5<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete syllabus, results, class timetable, and many other features kindly download the <a 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 pdf platform to make students’s lives easier.<\/b><br \/><a 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>Unit 6<\/h4>\n<p> <strong>Object-Oriented Databases and Database Architectures<\/strong><br \/>\n Centralized and Client-Server Architectures, 2 Tier and 3 Tier Architecture, Introduction to Distributed Database systems. Introduction to data mining using association rules, introduction to data warehousing and its components.<\/p>\n<h4>Reference\/Text Book:<\/h4>\n<ol>\n<li>Silberschatz A., Korth H., Sudarshan S., “Database System Concepts”, 5th Edition, McGraw Hill Publishers, 2002, ISBN 0-07-120413-X<\/li>\n<li>Elmasri R., Navathe S., “Fundamentals of Database Systems”, 4* Edition, Pearson Education, 2003, ISBN 8129702282.<\/li>\n<li>Rab P. Coronel C. “Database Systems Design, Implementation and Management”, 5th Edition, Thomson Course Technology, 2002, ISBN 981-243-135-7<\/li>\n<li>Connally T., Begg C., “Database Systems”, 3rd Edition, Pearson Education, 2002, ISBN 81-7808-861-4<\/li>\n<li>Date C., “An Introduction to Database Systems”, 7th Edition, Pearson Education, 2002, ISBN 81 -7808-231- 4<\/li>\n<li>Ramkrishna R., Gehrke J., “Database Management Systems”, 3rd Edition, McGraw-Hill, 2003, ISBN 0-07- 123151 -XAtulKahate, Introduction to Database Management System, 3rd Edition, Pearson Education<\/li>\n<\/ol>\n<p align=\"justify\">For detail syllabus of all subjects of Electronics Engineering (EL) 7th Sem 2017 onwards, visit <a href=\"..\/category\/dbatu\/7th-sem-dbatu\">EL 7th Sem Subjects <\/a>of 2017 Onwards.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management detailed syllabus scheme for Electronics Engineering (EL), 2017 onwards has been taken from the DBATU official website and presented for the Bachelor of Technology students. For Subject Code, […]<\/p>\n","protected":false},"author":2351,"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":[107],"tags":[],"class_list":["post-17415","post","type-post","status-publish","format-standard","hentry","category-el-dbatu"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/17415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/users\/2351"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/comments?post=17415"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/17415\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/media?parent=17415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/categories?post=17415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/tags?post=17415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}