{"id":9313,"date":"2018-08-27T19:06:04","date_gmt":"2018-08-27T19:06:04","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/?p=9313"},"modified":"2026-05-24T10:55:15","modified_gmt":"2026-05-24T05:25:15","slug":"jntuh-m-tech-2017-2018-r17-detailed-syllabus-database-management-systems","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-m-tech-2017-2018-r17-detailed-syllabus-database-management-systems\/","title":{"rendered":"JNTUH M.Tech 2017-2018 (R17) Detailed Syllabus Database Management Systems"},"content":{"rendered":"Database Management Systems Detailed Syllabus for Geo-Informatics and Surveying Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.\r\n\r\nThe detailed syllabus for Database Management Systems M.Tech 2017-2018 (R17) first year first sem is as follows.\r\n\r\nM.Tech. I Year I Sem.\r\n\r\n<strong>Course Objectives:<\/strong> to understand the role of Database Management to prepare spatial data base.\r\n\r\n<strong>Course Outcomes:<\/strong> at the end of the course the student will able to Understand the components of Database management system and file management methods, Apply the concepts of SQL and its use to manage the databases, Carry out the Query, update a databases using SQL and Design and build a simple database system using DBMS software.\r\n\r\n<strong>UNIT-I:<\/strong> Need for Data Base Management Systems (DBMS) Components of DBMS, Records and files, Data Models, Data Associations, Entities, Attributes and Associations, Relationships among entities, Data models classification\r\n\r\n<strong>UNIT-II: File Organization,<\/strong> Constituents of file, Operations on files, Sequential files, Index- Sequential files, Direct files\r\n\r\n<strong>UNIT-III: Relational Database,<\/strong> Attributes and domains, Tuples, Relations and their schemes, Relation Representation, Relational operations, Relational algebra, Relational calculus, Implementation\r\n\r\n<strong>UNIT-IV: Relational Database Manipulation<\/strong>, Structured Query Language (SQL), Query Language (QUEL) Query-by-Example (QBE), Data Manipulation and retrieval using SQL.\r\n\r\n<strong>UNIT-V: QUEL and QBE,<\/strong> Concepts of Relational database design, Introduction to Big Data Management\r\n\r\n<strong>TEXT BOOKS:<\/strong>\r\n<ul>\r\n \t<li>Arun K. Majundar and P. Bhattacharya, Database Management Systems, 2001.<\/li>\r\n \t<li>Bipin C. Desai, An Introduction to Database Systems, 1990.<\/li>\r\n<\/ul>\r\n<strong>REFERENCES:<\/strong>\r\n<ul>\r\n \t<li>C J Date, An Introduction to Database Systems Vol-1, 1994.<\/li>\r\n<\/ul>\r\nFor all other M.Tech 1st Year 1st Sem syllabus go to<a href=\"https:\/\/www.inspirenignite.com\/jntuh\/jntuh-first-year-first-sem-geo-informatics-and-surveying-technology-for-m-tech-2017-2018-r17-batch\/\"> JNTUH M.Tech Geo-Informatics and Surveying Technology 1st Year 1st Sem Course Structure for (R17) Batch.<\/a>\r\n\r\nAll 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.\r\n\r\nDo share with friends and in case of questions please feel free drop a comment.\n\n<h2>Download iStudy App (Android &amp; iOS)<\/h2>\n<div style=\"width: 100%;text-align: center;background: #f0f7ff;border: 1px solid #d9e8ff;border-radius: 10px;padding: 12px 10px;margin: 8px 0 12px 0\">\n<p style=\"margin: 0 0 8px 0\">Get instant JNTUH updates, timetables, results, and notices on mobile.<\/p>\n<div style=\"justify-content: center;align-items: flex-start;gap: 24px;flex-wrap: wrap\">\n<div style=\"flex-direction: column;align-items: center;gap: 2px\"><img decoding=\"async\" style=\"height: 54px;width: auto\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<img decoding=\"async\" style=\"height: 80px;width: 80px\" src=\"https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=120x120&amp;data=https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" alt=\"Android app QR code\" \/><\/div>\n<div>\u00a0<\/div>\n<div style=\"flex-direction: column;align-items: center;gap: 2px\"><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">Android App<\/a><\/div>\n<div>\u00a0<\/div>\n<div style=\"flex-direction: column;align-items: center;gap: 2px\"><img decoding=\"async\" style=\"height: 40px;width: auto\" src=\"https:\/\/upload.wikimedia.org\/wikipedia\/commons\/3\/3c\/Download_on_the_App_Store_Badge.svg\" alt=\"Download on the App Store\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<img decoding=\"async\" style=\"height: 80px;width: 80px\" src=\"https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=120x120&amp;data=https:\/\/apps.apple.com\/us\/app\/istudy-app-syllabus-papers\/id6478500231\" alt=\"iOS app QR code\" \/><\/div>\n<div>\u00a0<\/div>\n<div style=\"flex-direction: column;align-items: center;gap: 2px\"><a href=\"https:\/\/apps.apple.com\/us\/app\/istudy-app-syllabus-papers\/id6478500231\" target=\"_blank\" rel=\"noopener\">iOS App <\/a><\/div>\n<\/div>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management Systems Detailed Syllabus for Geo-Informatics and Surveying Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details [&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":[73,62],"tags":[],"class_list":["post-9313","post","type-post","status-publish","format-standard","hentry","category-m-tech","category-syllabus"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/9313","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=9313"}],"version-history":[{"count":3,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/9313\/revisions"}],"predecessor-version":[{"id":40522,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/9313\/revisions\/40522"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=9313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=9313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=9313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}