{"id":84,"date":"2016-10-30T19:49:57","date_gmt":"2016-10-30T19:49:57","guid":{"rendered":"http:\/\/www.inspirenignite.com\/anna-university\/?p=84"},"modified":"2019-07-17T06:20:04","modified_gmt":"2019-07-17T06:20:04","slug":"anna-university-b-tech-it-r13-3rd-sem-database-management-systems-detailed-syllabus","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-it-r13-3rd-sem-database-management-systems-detailed-syllabus\/","title":{"rendered":"Anna University B.Tech IT (R13) 3rd Sem Database Management Systems Detailed Syllabus"},"content":{"rendered":"<p>Database Management Systems Syllabus for B.Tech Third sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.<\/p>\n<p>The detailed syllabus for Database Management Systems B.Tech 2016-2017 (R13) thirdsem is as follows<\/p>\n<p><strong>OBJECTIVES<\/strong><\/p>\n<ul>\n<li>To expose the students to the fundamentals of Database Management Systems.<\/li>\n<li>To make the students understand the relational model.<\/li>\n<li>To familiarize the students with ER diagrams.<\/li>\n<li>To expose the students to SQL.<\/li>\n<li>To make the students to understand the fundamentals of Transaction Processing and Query Processing.<\/li>\n<li>To familiarize the students with the different types of databases.<\/li>\n<li>To make the students understand the Security Issues in Databases.<\/li>\n<\/ul>\n<p><strong>UNIT I INTRODUCTION TO DBMS \u00a0 \u00a0 [10 hours]<\/strong><br \/>\nFile Systems Organization &#8211; Sequential, Pointer, Indexed, Direct &#8211; Purpose of Database System- Database System Terminologies-Database characteristics- Data models \u2013 Types of data models \u2013 Components of DBMS- Relational Algebra. LOGICAL DATABASE DESIGN: Relational DBMS &#8211; Codd&#8217;s Rule &#8211; Entity-Relationship model &#8211; Extended ER Normalization \u2013 Functional Dependencies, Anomaly- 1NF to 5NF- Domain Key Normal Form \u2013 Denormalization.<\/p>\n<p><strong>UNIT II SQL &amp; QUERY OPTIMIZATION<\/strong>\u00a0 \u00a0 [<strong>8 \u00a0hours]<\/strong><br \/>\nSQL Standards &#8211; Data types &#8211; Database Objects- DDL-DML-DCL-TCL-Embedded SQL-Static Vs Dynamic SQL &#8211; QUERY OPTIMIZATION: Query Processing and Optimization &#8211; Heuristics and Cost Estimates in Query Optimization.<\/p>\n<p><strong>UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL \u00a0 [8 \u00a0hours]\u00a0<\/strong><br \/>\nIntroduction-Properties of Transaction- Serializability- Concurrency Control \u2013 Locking Mechanisms- Two Phase Commit Protocol-Dead lock.<\/p>\n<p style=\"text-align: center\"><strong><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">Download iStudy<\/a> <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">Android<\/a><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\"> App for complete Anna University syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier.<\/a><\/strong><\/p>\n<p><strong>[TOTAL: 45 PERIODS]<\/strong><\/p>\n<p><strong>OUTCOMES<\/strong>: At the end of the course, the student should be able to:<\/p>\n<ul>\n<li>Design Databases for applications.<\/li>\n<li>Use the Relational model, ER diagrams.<\/li>\n<li>Apply concurrency control and recovery mechanisms for practical problems.<\/li>\n<li>Design the Query Processor and Transaction Processor.<\/li>\n<li>Apply security concepts to databases.<\/li>\n<\/ul>\n<p><strong>TEXT BOOK:<\/strong><\/p>\n<ul>\n<li>Ramez Elmasri and Shamkant B. Navathe, \u201cFundamentals of Database Systems\u201d, Fifth Edition, Pearson Education, 2008.<\/li>\n<\/ul>\n<p><strong>REFERENCES:<\/strong><\/p>\n<ul>\n<li>Abraham Silberschatz, Henry F. Korth and S. Sudharshan, \u201cDatabase System Concepts\u201d, Sixth Edition, Tata McGraw Hill, 2011.<\/li>\n<li>C.J.Date, A.Kannan and S.Swamynathan, \u201cAn Introduction to Database Systems\u201d, Eighth Edition, Pearson Education, 2006.<\/li>\n<li>Atul Kahate, \u201cIntroduction to Database Management Systems\u201d, Pearson Education, New Delhi, 2006.<\/li>\n<li>Alexis Leon and Mathews Leon, \u201cDatabase Management Systems\u201d, Vikas Publishing House Private Limited, New Delhi,<\/li>\n<li>Raghu Ramakrishnan, \u201cDatabase Management Systems\u201d, Fourth Edition, Tata McGraw Hill, 2010.<\/li>\n<li>G.K.Gupta,\u201dDatabase Management Systems\u201d, Tata McGraw Hill, 2011.<\/li>\n<li>Rob Cornell, \u201cDatabase Systems Design and Implementation\u201d, Cengage Learning, 2011.<\/li>\n<\/ul>\n<p>For all other B.Tech IT 3rd sem syllabus go to <a href=\"http:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-information-technology-3rd-sem-course-structure-for-r13-batch\/\">Anna University B.Tech Information Technology (IT) 3rd Sem Course Structure for (R13) Batch.<\/a> All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.<\/p>\n<p>Do share with friends and in case of questions please feel free drop a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management Systems Syllabus for B.Tech Third sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course. [&hellip;]<\/p>\n","protected":false},"author":2259,"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":[1],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/84","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\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":5,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":10568,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/84\/revisions\/10568"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}