Course content

Databases

Code:

32798

Abbreviation:

B23A01

Higher education institution:

Faculty of Geodesy

ECTS credits:

5.0

Load:

30(L) + 30(E)

Issuing teachers:

Professor Damir Medak, PhD

Course contractors:

Assistant Professor Luka Rumora, PhD (E)

Professor Damir Medak, PhD (L, E)

Ivan Brkić (E)

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 <ul><li>define basic database concepts <li>differentiate relational. object, object-relational and deductive database models <li>apply entity-relationship model on a concrete problem in fields of geodesy and geoinformatics <li>crate a database relational schema using the normal forms <li>explain database indexing <li>solve practical problems using SQL commands and functions</ul> Learning outcomes at the level of the programme to which the course contributes <ul><li>Maintain topographic, cartographic, maritime and navigation, and land information systems, integrate and visualise spatial information. <li>Use information technology in solving geodetic and geoinformation tasks. <li>Recognise problems and tasks in the application of geodetic and geoinformation principles and methods, and select proper procedures for their solution. <li>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.</ul> Course content broken down in detail by weekly class schedule (syllabus) <ul><li>Introduction, Course goals. Definitions of basic concepts. Motivation for Databases. <li>Database Management System (DBMS). Three levels of abstraction. <li>Entity Relationship Schema. Logical data models. <li>Acces methods. Linear and binary searching. Data indexing. <li>Entities and attributes. Primary and foreign keys. <li>Relational model. Normal forms. <li>Relational algebra. <li>SQL-92: Data Definition Language, Data Manipulation Language. <li>Multitable queries. Aggregation and grouping operations. <li>Transactions. ACID conditions. <li>Object databases. Encapsulation. Reusability. Inheritance. Polymorphism <li>Extensions to relational model. Spatial extensions. OGC standards. <li>Geometric data types and operations. <li>Knowledge databases. Facts and rules. <li>Prolog. NoSQL.</ul> Screening student work <ul><li>Tests - 2 ECTS <li>Oral exam - 1 ECTS <li>Written exam - 1 ECTS <li>Project - 1 ECTS</ul>

Mandatory 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.

Enrollment prerequisites:

Programming (passed)

Course in study programme:

Code	Name of study	Level of study	Semester	Required/Elective
71	Geodesy and Geoinformatics	undergraduate	3	required

* the course is not taught in that semester

Legend

E - Exercises

L - Lectures