{"id":3464,"date":"2017-12-10T12:16:13","date_gmt":"2017-12-10T12:16:13","guid":{"rendered":"http:\/\/www.inspirenignite.com\/jntuh\/?p=3464"},"modified":"2020-06-17T11:22:06","modified_gmt":"2020-06-17T11:22:06","slug":"dbms-syllabus-database-management-systems-jntuh-b-tech-2016-17-r16","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/dbms-syllabus-database-management-systems-jntuh-b-tech-2016-17-r16\/","title":{"rendered":"DBMS Syllabus (Database Management Systems) JNTUH B.Tech 2016-17 (R16)"},"content":{"rendered":"<p>DBMS syllabus (Database Management Systems) for JNTUH B.Tech II year II 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<h3>DBMS Syllabus (Database Management Systems) JNTUH R16<\/h3>\n<p>B.Tech. II Year II Sem. \u00a0 \u00a0L\/T\/P\/C<br \/>\nCourse Code: CS402ES 4\/0\/0\/4<\/p>\n<p><strong>Course Objectives:<\/strong><\/p>\n<ul>\n<li>To understand the basic concepts and the applications of database systems.<\/li>\n<li>To master the basics of SQL and construct queries using SQL.<\/li>\n<li>To understand the relational database design principles.<\/li>\n<li>To become familiar with the basic issues of transaction processing and concurrency\u00a0control.<\/li>\n<li>To become familiar with database storage structures and access techniques.<\/li>\n<\/ul>\n<p><strong>Course Outcomes:<\/strong><\/p>\n<ul>\n<li>Demonstrate the basic elements of a relational database management system.<\/li>\n<li>Ability to identify the data models for relevant problems.<\/li>\n<li>Ability to design entity relationship model and convert entity relationship diagrams\u00a0into RDBMS and formulate SQL queries on the data.<\/li>\n<li>Apply normalization for the development of application software.<\/li>\n<\/ul>\n<p><strong>UNIT &#8211; I\u00a0Introduction<\/strong>: Database System Applications, Purpose of Database Systems, View of Data,<br \/>\nDatabase Languages \u2013 DDL, DML, Relational Databases, Database Design, Data Storage\u00a0and Querying, Transaction Management, Database Architecture, Data Mining and\u00a0Information Retrieval, Specialty Databases, Database Users and Administrators, History of\u00a0Database Systems.\u00a0Introduction to Data base design: Database Design and ER diagrams, Entities, Attributes\u00a0and Entity sets, Relationships and Relationship sets, Additional features of ER Model,\u00a0Conceptual Design with the ER Model, Conceptual Design for Large enterprises.\u00a0Relational Model: Introduction to the Relational Model, Integrity Constraints over\u00a0Relations, Enforcing Integrity constraints, Querying relational data, Logical data base\u00a0Design: ER to Relational, Introduction to Views, Destroying \/Altering Tables and Views.<\/p>\n<p><strong>UNIT &#8211; II\u00a0Relational Algebra and Calculus:<\/strong> Preliminaries, Relational Algebra, Relational calculus \u2013\u00a0Tuple relational Calculus, Domain relational calculus, Expressive Power of Algebra and\u00a0calculus.\u00a0SQL: Queries, Constraints, Triggers: Form of Basic SQL Query, UNION,INTERSECT, and\u00a0EXCEPT, Nested Queries, Aggregate Operators, NULL values Complex Integrity\u00a0Constraints in SQL, Triggers and Active Data bases, Designing Active Databases..<\/p>\n<p><strong>UNIT &#8211; III\u00a0Schema Refinement and Normal Forms:<\/strong> Introduction to Schema Refinement, Functional\u00a0Dependencies-Reasoning about FDs,Normal Forms,Properties of \u00a0Decompositions, \u00a0Normalization, Schema Refinement in Database Design, Other Kinds of Dependencies.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\"><strong><span style=\"color: #ff0000\">Download iStudy Android App for complete JNTUH syllabus, results, timetables and all other updates. There are no ads and no pdfs and will make your life way easier<\/span>.<\/strong><\/a><\/p>\n<p><strong>TEXT BOOKS:<\/strong><\/p>\n<ul>\n<li>Data base Management Systems, Raghu Ramakrishnan, Johannes Gehrke, McGraw\u00a0<span style=\"line-height: 1.5\">Hill Education (India) Private Limited, 3rd Edition. (Part of UNIT-I, UNIT-II,\u00a0<\/span><span style=\"line-height: 1.5\">UNIT-III, UNIT-V)<\/span><\/li>\n<li>Data base System Concepts, A. Silberschatz, Henry. F. Korth, S. Sudarshan,\u00a0McGraw Hill Education(India) Private Limited l, 6th edition.( Part of UNIT-I,\u00a0UNIT-IV)<\/li>\n<\/ul>\n<p><strong>REFERENCE BOOKS:<\/strong><\/p>\n<ul>\n<li>Database Systems, 6th edition, R Elmasri, Shamkant B.Navathe, Pearson\u00a0Education.<\/li>\n<li>Database System Concepts, Peter Rob &amp; Carlos Coronel, Cengage Learning.<\/li>\n<li>Introduction to Database Management, M. L. Gillenson and others, Wiley Student\u00a0Edition.<\/li>\n<li>Database Development and Management, Lee Chao, Auerbach publications, Taylor\u00a0&amp; Francis Group.\u00a0Introduction to Database Systems, C. J. Date, Pearson Education.<\/li>\n<\/ul>\n<p>For all other B.Tech 2nd\u00a0Year 2nd Sem syllabus go to <a href=\"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-second-year-second-sem-information-technology-course-structure-2016-2017-r16-batch\/\">JNTUH B.Tech Information Technology 2nd\u00a0Year 2nd Sem Course Structure for (R16) Batch.<\/a><\/p>\n<p>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>DBMS syllabus (Database Management Systems) for JNTUH B.Tech II year II sem is covered here. This gives the details about credits, number of hours and other details along with reference [&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":[62],"tags":[],"class_list":["post-3464","post","type-post","status-publish","format-standard","hentry","category-syllabus"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/3464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/users\/2259"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=3464"}],"version-history":[{"count":4,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/3464\/revisions"}],"predecessor-version":[{"id":22222,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/3464\/revisions\/22222"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=3464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=3464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=3464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}