Skip to main content

Data bases 1

2026/2027
Programme:
Applied mathematics
Year:
2 year
Semester:
first
Kind:
mandatory
ECTS:
5
Language:
slovenian
Hours per week – 1. semester:
Lectures
2
Seminar
0
Tutorial
0
Lab
2
Prerequisites

Programming 1

Content (Syllabus outline)

The motivation for working with databases and basic concepts: database, data independence, database and file system, relational databases.

Database software tools with a focus on systems for managing databases (SUPB).

SQL. SELECT. Restrictions, grouping of tables (JOIN).

The essentials of databases planning. ER diagrams.

CREATE TABLE, INSERT, UPDATE, DELETE.

Programmatic access to databases.

Readings

R. Ramakrishnan, J. Gehrke: Database Management Systems, 3. izdaja, McGraw-Hill, Boston, 2003.
T. Mohorič: Podatkovne baze, 2. dopolnjena izdaja, BI-TIM, Ljubljana, 2002.
Priročniki za uporabo podatkovnih baz in priročniki za uporabljene programske jezike.
Zapiski s predavanj, gradivo za vaje in ostalo gradivo v spletni učilnici predmeta.
Zaradi hitrega razvoja informacijskih tehnologij se literatura redno prilagaja razvoju aktualnih podatkovnih baz in programskih jezikov. Konkretni naslovi, ki bi jih navedli, bi bili v času izvajanja že zastareli.

Objectives and competences

Students will be acquainted with basic definitions of data and information, the organization of the logical and physical databases, as well as with basics of data models. They will gain knowledge in query languages such as SQL and learn to use them in practice. They will also study the functioning of certain systems for managing databases.

Intended learning outcomes

Knowledge and understanding:
Comprehensive knowledge of databases and practical work with them. The integration of applications and databases.
Application:
The use of databases in information systems and in other areas of computer science and information technology.
Reflection:
Introduction and comprehension of interactions between theoretical principles (especially those of relational data model) and their practical use in modern databases.
Transferable skills:
Practical knowledge of databases increases the student's abilities for data organization during the study and at future work.

Learning and teaching methods

Lectures, exercises, usage of distance learning techniques, home works, consultations

Assessment

Students receive two grades: one from the written exam and the other from the project and the oral exam.
Written exam
Oral exam – the presentation of project
5 - 10, a student passes the exam if he is graded from 6 to 10

Lecturer's references

Andrej Bauer:
– HAJDINJAK, Melita, BAUER, Andrej. Similarity-based relations in Datalog programs. International journal of uncertainty, fuzziness and knowledge-based systems, ISSN 0218-4885, Oct. 2012, vol. 20, no. 5, str. 673-700 [COBISS-SI-ID 9428308]
– AWODEY, Steve, BAUER, Andrej. Propositions as [Types]. Journal of logic and computation, ISSN 0955-792X, 2004, vol. 14, no. 4, str. 447-471 [COBISS-SI-ID 13374809]
– LUKŠIČ, Primož, HORVAT, Boris, BAUER, Andrej, PISANSKI, Tomaž. Practical E-Learning for the Faculty of Mathematics and Physics at the University of Ljubljana. Interdisciplinary journal of knowledge & learning objects, ISSN 1552-2210, 2007, vol. 3, str. 73-83 [COBISS-SI-ID 14269529]
– BAUER, Andrej, STONE, Christopher A. RZ: a tool for bringing constructive and computable mathematics closer to programming practice. Journal of logic and computation, ISSN 0955-792X, 2009, vol. 19, no. 1, str. 17-43 [COBISS-SI-ID 15325785]


Janoš Vidali:
– BERČIČ, Katja, VIDALI, Janoš. DiscreteZOO : a fingerprint database of discrete objects. Mathematics in computer science. Sep. 2020, vol 14, iss. 3, str. 559-575. ISSN 1661-8270 [COBISS-SI-ID 24924419]
– VIDALI, Janoš, NOSE, Peter, PAŠALIĆ, Enes. Collisions for variants of the BLAKE hash function. Information processing letters. July 2010, vol. 110, no. 14/15, str. 585-590. ISSN 0020-0190. [COBISS-SI-ID 1024263252]
– VIDALI, Janoš. Using symbolic computation to prove nonexistence of distance-regular graphs. The Electronic journal of combinatorics. 2018, vol. 25, iss. 4, paper p4.21 (10 str.). ISSN 1077-8926. [COBISS-SI-ID 18469721]