Syllabus
The content of the course includes:- data models
- entity-relationshhip modeling
- functional dependencies
- database normalization
- relational algebra- SQL query language- database architectures- indexing and transactions.The support the major database systems vendors provide to spatial data and GIS is discussed. The lab and the development of SQL scripts is done using PostgreSQL database platform.
Annotation
Introductory course of database systems. The course concerns three levels of data modelling.
The conceptual level with emphasis on entity-relationship modelling. The relational data model on the logical level.
Database indexing, referential integrity and transactions on the physical level of data modelling.