{"id":1635,"date":"2016-11-27T17:48:14","date_gmt":"2016-11-27T17:48:14","guid":{"rendered":"http:\/\/www.inspirenignite.com\/anna-university\/?p=1635"},"modified":"2019-07-17T19:52:23","modified_gmt":"2019-07-17T19:52:23","slug":"anna-university-b-tech-gi-r13-5th-sem-geo-database-system-detailed-syllabus","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-gi-r13-5th-sem-geo-database-system-detailed-syllabus\/","title":{"rendered":"Anna University B.Tech GI (R13) 5th Sem Geo database system Detailed Syllabus"},"content":{"rendered":"<p>Geo database system Syllabus for B.Tech 5th 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 Geo database system B.Tech (R13) fifthsem is as follows<\/p>\n<p><strong>OBJECTIVES:<\/strong><\/p>\n<ul>\n<li>To introduce the students to the concepts of DBMS, Spatial Database Management\u00a0System (SDBMS), Spatial Database design, basic application program development and user\u00a0interfaces.<\/li>\n<\/ul>\n<p><strong>UNIT I : INTRODUCTION<\/strong> \u00a0 \u00a0 \u00a0 \u00a0 \u00a0[9 hours]<br \/>\nData \u2013 Information &#8211; File system vs DBMS \u2013 Database Management Systems \u2013 Database\u00a0Architectures, users and administrators \u2013 Classification of Database Management Systems &#8211;\u00a0Spatial Data- Points, Lines, Polygons- definition of SDBMS -user classes of SDBMS &#8211; Multi layer\u00a0architecture of SDBMS &#8211; GIS and SDBMS<\/p>\n<p><strong>UNIT II : SPATIAL CONCEPTS AND DATAMODELS<\/strong> \u00a0 \u00a0[10 hours]<br \/>\nField based model \u2013 object based model \u2013 spatial data types \u2013 operations on spatial objects Entity\u00a0Relationship Model (ER Model) \u2013 Relational Model \u2013 Constraints and Normal forms of\u00a0Relational Model &#8211; mapping ER model to Relational model \u2013 ER model with spatial concepts \u2013\u00a0Object-oriented data modeling with Unified Modeling Language (UML)<\/p>\n<p><strong>UNIT III : QUERY LANGUAGE<\/strong> \u00a0 \u00a0[9 hours]<br \/>\nSQL \u2013 Data Definition \u2013 Data Manipulation &#8211; Basic structure of SQL \u2013 Set operations \u2013\u00a0Aggregate Functions \u2013Simple queries \u2013spatial vs non spatial- Nested sub queries \u2013 Complex\u00a0queries \u2013 Views \u2013 Trigger &#8211; OGIS standard for extending SQL &#8211; example spatial SQL queries \u2013\u00a0Object relational SQL.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\"><strong>Download iStudy\u00a0Android\u00a0App 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.<\/strong><\/a><\/p>\n<p><strong>[TOTAL: 45 PERIODS]<\/strong><\/p>\n<p><strong>OUTCOMES:\u00a0<\/strong>At the end of the course the student will be able to understand<\/p>\n<ul>\n<li>Concepts and architecture of SDBMS<\/li>\n<li>Concepts of SQL and generation of queries<\/li>\n<li>Concepts of spatial data storage and design of SDBMS<\/li>\n<\/ul>\n<p><strong>TEXTBOOKS:<\/strong><\/p>\n<ul>\n<li>Shashi Shekhar, Sanjay Chawla,\u201dSpatial Databases a Tour\u201d Prentice Hall, 2003.<\/li>\n<li>Philippe Rigaux, Michel Scholl, Agn\u00e8s Voisard \u201cSpatial Databases\u201d Morgan Kaufmann,\u00a02001<\/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,\u00a06th edition, McGraw Hill, 2011<\/li>\n<li>Ravi Kothuri, Albert Godfrind, Euro Beinat \u201cPro Oracle Spatial for Oracle Database 11g\u201d,\u00a0Apress , 2007<\/li>\n<li>Regina, LeoHsu\u201cPost GISin Action\u201d,Oreilly &amp; Associates Inc., 2011<\/li>\n<\/ul>\n<p>For all other B.Tech GI 5th sem syllabus go to <a href=\"http:\/\/www.inspirenignite.com\/anna-university\/anna-university-b-tech-geoinformatics-engineering-5th-sem-course-structure-r13-batch\/\">Anna University B.Tech GEOINFORMATICS ENGINEERING (GI) 5th 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>Geo database system Syllabus for B.Tech 5th 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-1635","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/1635","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=1635"}],"version-history":[{"count":2,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/1635\/revisions"}],"predecessor-version":[{"id":11077,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/1635\/revisions\/11077"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=1635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=1635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=1635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}