Geographic Information System and Remote Sensing II

At the end of this course students will be able to: 1. explain Database Management Systems and its classifications; 2. describe the nature, components and applications of GIS; 3. develop skills in sourcing, manipulating and interpreting spatial data; 4. critically discuss the applications of GIS in a variety of fields; 5. discuss the underlying theory of spatial information science; 6. perform spatial analysis tasks; 7. generate outputs using GIS software; and 8. explain techniques required for Database recovery and Security.

Introduction to Spatial Database Management Systems. Introduction (Data, Information, File system vs DBMS, Data models, Hardware and software requirements, Database Management Systems, Database languages, Database Architecture, users and administrators, Classification of Database Management Systems. Relational Data Model (Relational model, Data Structure, Constraints, Key, Codd’s Rule, Relational Algebra, Fundamental operations, Additional operations, Extended operations Null values. SQL (SQL, Data Definition, Basic structure of SQL queries, set operations, Aggregate, Functions, Null values, Nested sub queries, Complex queries, Views, Embedded SQL, Dynamic SQL, Triggers. Database Design and Management (Design process, Entity Relationship Model, Constraints, EER, Diagrams, Atomic domain and First Normal Form, Functional Dependency, Decomposition using Functional dependencies, Normalization using Multi-Valued Dependencies and Join Dependencies, Basic concepts of file organizations, indexing and hashing, Database recovery techniques, Database Security, Handling Spatial Database. Accessing Data Using Ado.Net And Vb.Net (ADO.Net Object Model using OLE DB managed provider, Other data providers, Accessing XML data, Building Windows). GIS and the information age, Capabilities of GIS, Spatial data and their sources for GIS analysis, Raster and Vector data, Data Entry, GIS analysis and modelling data issues and problems. 400 LEVEL