{"id":20147,"date":"2019-12-10T06:23:59","date_gmt":"2019-12-10T06:23:59","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/geo-database-system-geo-4th-sem-syllabus-for-be-2017-regulation-anna-univ\/"},"modified":"2019-12-10T06:23:59","modified_gmt":"2019-12-10T06:23:59","slug":"geo-database-system-geo-4th-sem-syllabus-for-be-2017-regulation-anna-univ","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/geo-database-system-geo-4th-sem-syllabus-for-be-2017-regulation-anna-univ\/","title":{"rendered":"Geo Database System Geo 4th Sem Syllabus for BE 2017 Regulation Anna Univ"},"content":{"rendered":"<p>Geo Database System detail syllabus for Geoinformatics Engineering (Geo), 2017 regulation is taken from <a href=\"https:\/\/www.annauniv.edu\/\" target=\"_blank\" rel=\"noopener\">Anna University<\/a> official website and presented for students of Anna University. The details of the course are: course code (GI8403), Category (PC), Contact Periods\/week (3), Teaching hours\/week (3), Practical Hours\/week (0). The total course credits are given in combined syllabus.<\/p>\n<p>For all other geo 4th sem syllabus for be 2017 regulation anna univ you can visit <a href=\"..\/geo-4th-sem-syllabus-for-be-2017-regulation-anna-univ\">Geo 4th Sem syllabus for BE 2017 regulation Anna Univ Subjects<\/a>. The detail syllabus for geo database system is as follows.&#8221;<\/p>\n<p><h4>Course Objective:<\/h4>\n<ul>\n<li>To introduce the students to the concepts of DBMS, Spatial Database Management System (SDBMS), Spatial Database design, basic application program development and user interfaces.<\/li>\n<\/ul>\n<p><h4>Unit I<\/h4>\n<p>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy<\/a>. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Unit II<\/h4>\n<p><strong> Spatial Concepts and Data Models<\/strong><br \/>\nField based model &#8211; object based model &#8211; spatial data types &#8211; operations on spatial objects &#8211;<br \/>\nEntity Relationship Model (ER Model) &#8211; Relational Model &#8211; Constraints and Normal forms of Relational Model &#8211; mapping ER model to Relational model &#8211; ER model with spatial concepts -Object-oriented data modeling with Unified Modeling Language (UML)\n<\/p>\n<p><h4>Unit III<\/h4>\n<p><strong> Query Language<\/strong><br \/>\nSQL &#8211; Data Definition &#8211; Data Manipulation &#8211; Basic structure of SQL &#8211; Set operations &#8211; Aggregate Functions -Simple queries -spatial Vs non spatial- Nested sub queries &#8211; Complex queries -Views &#8211; Trigger &#8211; OGIS standard for extending SQL &#8211; example spatial SQL queries &#8211; Object relational SQL.\n<\/p>\n<p><h4>Unit IV<\/h4>\n<p>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy<\/a>. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Unit V<\/h4>\n<p><strong> Design and Development of Spatial Data Base System<\/strong><br \/>\nExploring Spatial Geometry, Organizing spatial data, Spatial data relationships and functionalities SDBMS &#8211; Customization &#8211; Big Data and Analytics &#8211; Tools.\n<\/p>\n<p><h4>Course Outcome:<\/h4>\n<p>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><h4>Text Books:<\/h4>\n<ol>\n<li>Shashi Shekhar, Sanjay Chawla, ||Spatial Databases a Tour|| Prentice Hall, 2003.<\/li>\n<li>Philippe Rigaux, Michel Scholl, Agnes Voisard  Spatial Databases|| Morgan Kaufmann, ISBN13: 9781558605886, ISBN10: 1558605886,2002<\/li>\n<\/ol>\n<p><h4>References:<\/h4>\n<ol>\n<li>Abraham Silberschatz, Henry F. Korth and S.Sudharshan, Database System Concepts| , Sixth edition, McGraw Hill, 2011<\/li>\n<li>Ravi Kothuri, Albert Godfrind, Euro Beinat Pro Oracle Spatial for Oracle Database 11g| , Apress , ISBN13 : 9788181288882, 2007<\/li>\n<li>Regina, Leo Hsu PostGIS in Action| , Oreilly and Associates Inc., ISBN-13: 9781935182269, ISBN-10: 1935182269, 2011<\/li>\n<\/li>\n<\/ol>\n<p>For detail syllabus of all other subjects of BE Geo, 2017 regulation do visit <a href=\"..\/category\/geo+4th-sem\">Geo 4th Sem syllabus for 2017 Regulation<\/a>.<\/p>\n<p>Dont forget to <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy<\/a> for latest syllabus and results, class timetable and more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Geo Database System detail syllabus for Geoinformatics Engineering (Geo), 2017 regulation is taken from Anna University official website and presented for students of Anna University. The details of the course [&hellip;]<\/p>\n","protected":false},"author":2297,"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":[47,80],"tags":[],"class_list":["post-20147","post","type-post","status-publish","format-standard","hentry","category-4th-sem","category-geo"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/20147","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\/2297"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/comments?post=20147"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/20147\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=20147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=20147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=20147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}