{"id":20164,"date":"2019-12-10T06:24:10","date_gmt":"2019-12-10T06:24:10","guid":{"rendered":"https:\/\/www.inspirenignite.com\/anna-university\/geo-database-laboratory-geo-5th-sem-syllabus-for-be-2017-regulation-anna-univ\/"},"modified":"2019-12-10T06:24:10","modified_gmt":"2019-12-10T06:24:10","slug":"geo-database-laboratory-geo-5th-sem-syllabus-for-be-2017-regulation-anna-univ","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/anna-university\/geo-database-laboratory-geo-5th-sem-syllabus-for-be-2017-regulation-anna-univ\/","title":{"rendered":"Geo Database Laboratory Geo 5th Sem Syllabus for BE 2017 Regulation Anna Univ"},"content":{"rendered":"<p>Geo Database Laboratory 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 (GI8511), Category (PC), Contact Periods\/week (4), Teaching hours\/week (0), Practical Hours\/week (0). The total course credits are 4.<\/p>\n<p>For all other geo 5th sem syllabus for be 2017 regulation anna univ you can visit <a href=\"..\/geo-5th-sem-syllabus-for-be-2017-regulation-anna-univ\">Geo 5th Sem syllabus for BE 2017 regulation Anna Univ Subjects<\/a>. The detail syllabus for geo database laboratory is as follows.&#8221;<\/p>\n<p><h4>Course Objective:<\/h4>\n<ul>\n<li>To get practical experience on the server &#8211; client setup on the database Management system and extending it to spatial data handling<\/li>\n<\/ul>\n<p><h4>Exercises:<\/h4>\n<ol>\n<li>Basics of Database<\/li>\n<ul>\n<li>Field, Record, table and relationships concepts on file type database<\/li>\n<\/ul>\n<li>Server \/ client operations<\/li>\n<ul>\n<li>Starting \/ Shutdown of server<\/li>\n<li>Client user creation<\/li>\n<li>client connection over network<\/li>\n<\/ul>\n<li>Data Definition of Tables<\/li>\n<ul>\n<li>Creation, Deletion and Modification of definition<\/li>\n<\/ul>\n<li>Data Manipulation<\/li>\n<ul>\n<li>Insert, delete and modify table data<\/li>\n<\/ul>\n<li>Simple Queries<\/li>\n<ul>\n<li>On single table<\/li>\n<li>Linking with multiple tables<\/li>\n<li>With simple conditions<\/li>\n<\/ul>\n<li>Views<\/li>\n<ul>\n<li>Creation of views<\/li>\n<li>Querying on views<\/li>\n<\/ul>\n<li>Queries on Tables and views<\/li>\n<ul>\n<li>Simple, Complex, nested queries using the tables and views<\/li>\n<\/ul>\n<li>Data Control of Tables and Views<\/li>\n<ul>\n<li>Defining different constraints<\/li>\n<li>Handling different permissions on tables and views<\/li>\n<\/ul>\n<li>Index on tables<\/li>\n<li>Database triggers<\/li>\n<li>Spatial data creation<\/li>\n<ul>\n<li>Creation of simple geometries (point, line and polygon) on database<\/li>\n<\/ul>\n<li>Indexing and viewing spatial data<\/li>\n<li>Topological querying on spatial data<\/li>\n<li>Geometrical functions and analysis<\/li>\n<ul>\n<li>Area and length, Buffer, Union and intersection<\/li>\n<\/ul>\n<li>Front end tool applications<\/li>\n<ul>\n<li>Designing of database application with any front end tool<\/li>\n<\/ul>\n<\/ol>\n<p><h4>Course Outcome:<\/h4>\n<p>At the end of the course the student will be able to<\/p>\n<ul>\n<li>Create database structure and populate database<\/li>\n<li>Apply geometric functions to derive spatial parameters<\/li>\n<li>Apply simple overlay and buffering tools on spatial database<\/li>\n<\/ul>\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<\/ol>\n<p><h4>List of Equipments:<\/h4>\n<ol>\n<li>i7 computer system with minimum 4GB RAM, 500GB HDD &#8211; 15 nos for 30 students<\/li>\n<li>Standard DBMS software with spatial data handling (Example: PostgreSQL DBMS with postgis)<\/li>\n<li>Two students can be allotted per system per session.<\/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+5th-sem\">Geo 5th 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 Laboratory 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":[48,80],"tags":[],"class_list":["post-20164","post","type-post","status-publish","format-standard","hentry","category-5th-sem","category-geo"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/20164","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=20164"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/posts\/20164\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/media?parent=20164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/categories?post=20164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/anna-university\/wp-json\/wp\/v2\/tags?post=20164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}