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 are: course code (GI8511), Category (PC), Contact Periods/week (4), Teaching hours/week (0), Practical Hours/week (0). The total course credits are 4.
For all other geo 5th sem syllabus for be 2017 regulation anna univ you can visit Geo 5th Sem syllabus for BE 2017 regulation Anna Univ Subjects. The detail syllabus for geo database laboratory is as follows.”
Course Objective:
- To get practical experience on the server – client setup on the database Management system and extending it to spatial data handling
Exercises:
- Basics of Database
- Field, Record, table and relationships concepts on file type database
- Server / client operations
- Starting / Shutdown of server
- Client user creation
- client connection over network
- Data Definition of Tables
- Creation, Deletion and Modification of definition
- Data Manipulation
- Insert, delete and modify table data
- Simple Queries
- On single table
- Linking with multiple tables
- With simple conditions
- Views
- Creation of views
- Querying on views
- Queries on Tables and views
- Simple, Complex, nested queries using the tables and views
- Data Control of Tables and Views
- Defining different constraints
- Handling different permissions on tables and views
- Index on tables
- Database triggers
- Spatial data creation
- Creation of simple geometries (point, line and polygon) on database
- Indexing and viewing spatial data
- Topological querying on spatial data
- Geometrical functions and analysis
- Area and length, Buffer, Union and intersection
- Front end tool applications
- Designing of database application with any front end tool
Course Outcome:
At the end of the course the student will be able to
- Create database structure and populate database
- Apply geometric functions to derive spatial parameters
- Apply simple overlay and buffering tools on spatial database
References:
- Abraham Silberschatz, Henry F. Korth and S.Sudharshan, Database System Concepts, Sixth edition, McGraw Hill, 2011.
List of Equipments:
- i7 computer system with minimum 4GB RAM, 500GB HDD – 15 nos for 30 students
- Standard DBMS software with spatial data handling (Example: PostgreSQL DBMS with postgis)
- Two students can be allotted per system per session.
For detail syllabus of all other subjects of BE Geo, 2017 regulation do visit Geo 5th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.