Početna stranicaVisoka učilištaKorisničke stranice
Abbreviation: B23A01Load: 30(L) + 0(P) + 0(FE) + 0(LE) + 0(S) + 0(PEE) + 0(E) + 30(DE)
Lecturers in charge: prof. dr. sc. Damir Medak
Lecturers: Luka Rumora MEng Geod. et G ( Design exercises )
dr. sc. Ela Vela ( Design exercises )
Course description:

Students will acquire theoretical background and practical usage of contemporary databases in context of geodesy and geoinformatics.

Learning outcomes expected at the level of the course
  • define basic database concepts
  • differentiate relational. object, object-relational and deductive database models
  • apply entity-relationship model on a concrete problem in fields of geodesy and geoinformatics
  • crate a database relational schema using the normal forms
  • explain database indexing
  • solve practical problems using SQL commands and functions

Learning outcomes at the level of the programme to which the course contributes
  • Maintain topographic, cartographic, maritime and navigation, and land information systems, integrate and visualise spatial information.
  • Use information technology in solving geodetic and geoinformation tasks.
  • Recognise problems and tasks in the application of geodetic and geoinformation principles and methods, and select proper procedures for their solution.
  • Keep pace with and adopt new technological achievements in the field of surveying, geoinformation systems and services based on the position, and the changes in regulations, norms and standards.

Course content broken down in detail by weekly class schedule (syllabus)
  • Introduction, Course goals. Definitions of basic concepts. Motivation for Databases.
  • Database Management System (DBMS). Three levels of abstraction.
  • Entity Relationship Schema. Logical data models.
  • Acces methods. Linear and binary searching. Data indexing.
  • Entities and attributes. Primary and foreign keys.
  • Relational model. Normal forms.
  • Relational algebra.
  • SQL-92: Data Definition Language, Data Manipulation Language.
  • Multitable queries. Aggregation and grouping operations.
  • Transactions. ACID conditions.
  • Object databases. Encapsulation. Reusability. Inheritance. Polymorphism
  • Extensions to relational model. Spatial extensions. OGC standards.
  • Geometric data types and operations.
  • Knowledge databases. Facts and rules.
  • Prolog. NoSQL.

Screening student work
  • Tests - 2 ECTS
  • Oral exam - 1 ECTS
  • Written exam - 1 ECTS
  • Project - 1 ECTS
Lecture languages: - - -
Compulsory literature:
1. Worboys, M.F. and Duckham, M. (2004) GIS: A Computing Perspective, Second Edition, CRC Press.
3. Douglas, K., Douglas, S (2005): PostgreSQL (2nd Edition), SAMS.
4. Medak, D. (2011): Baze podataka - predavanja. Geodetski fakultet Sveučilišta u Zagrebu.
Recommended literature:
2. Date, C.J. (2000): An Introduction to Database Systems. Addison Wesley Longman; 7th edition.
Prerequisit for enrollment:
Passed : Programming
L - Lectures
P - Practicum
FE - Field exercises
LE - Laboratory exercises
S - Seminar
PEE - Physical education excercises.
E - Exercises
DE - Design exercises
* - Not graded
Copyright (c) 2006. Ministarstva znanosti, obrazovanja i športa. Sva prava zadržana.
Programska podrška (c) 2006. Fakultet elektrotehnike i računarstva.
Oblikovanje(c) 2006. Listopad Web Studio.
Posljednja izmjena 2017-09-26