Data bases 2

Completed course Data bases 1.

Advanced concepts of database design. Normal forms and benefits of their use.
Views. Basics of transactions.
MVC model and web interface for accessing the database.Basic concepts of database management: user roles and privileges, logical and physical space, logging and modes of DBMS execution.

1. T. Mohorič: Podatkovne baze, 2. popravljena izd., Ljubljana : Bi-tim, 2002.
2. R. Ramakrishnan, J. Gehrke: Database management systems, 3rd ed., Boston : McGraw-Hill, cop. 2003.
3. T. M. Connolly, C. E. Begg: Database systems : a practical approach to design, implementation and management, 6th ed., Pearson, 2014.
4. S. Sumathi, S. Esakkirajan: Fundamentals of Relational Database Management Systems, Springer, 2007.

The main course objective is to introduce the students to the principles of database management systems and their various usages, and prepare them for autonomous and efficient use of available data base tools.
Developing web interface for accessing the database.

Knowledge and understanding:
Comprehensive knowledge of databases and database management systems, underlying principles, and their exploitation.
Application:
Efficient use of various database tools and query language SQL.
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 in data bases strengths student's abilities for data organization during the study and at future work.

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

Students receive one grade from the project with defence.
grading: 5 (fail), 6-10 (pass) (according to the Statute of UL)
preparation of the project
presentation
report with defense

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]
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]
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]
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]
Matija Lokar:
A. Poberžnik, G. Bezjak, L. Jerše, S. Brezovnik, A. Arh-Klančar, N. Stopar, D. Smej Skutnik, F. Zupančič, J. Bajc, M. Lokar, V. Manfreda Kolar, Š. Rožanc, R. Krajnc, R. Repnik, P. Čeh, A. Žakelj, A. Triller, M. Cotič, E. Klemenčič, M. Ploj Vitrič in drugi, Razvijanje zmožnosti reševanja avtentičnih problemov z digitalnimi tehnologijami. Spletna izd. Ljubljana: Zavod RS za šolstvo, 2022. [COBISS-SI-ID 103284739]
CERAR, Špela, LOKAR, Matija, ANŽELJ, Gregor, BRODNIK, Andrej, NANČOVSKA ŠERBEC, Irena. Textbooks and materials for teaching computer science in Slovenia. V: BOLLIN, Andreas (ur.), FUTSCHEK, Gerald (ur.). Informatics in schools : a step beyond digital education : 15th International Conference on Informatics in Schools: Situation, Evolution, and Perspectives, ISSEP 2022, Vienna, Austria, September 26-28, 2022 : proceedings. Cham: Springer, cop. 2022. Str. 138-149, ilustr., graf. prikaza. Lecture Notes in Computer Science, 13488. ISBN 978-3-031-15850-6. ISSN 0302-9743. [COBISS-SI-ID 128020483]
LOKAR, Matija. Designing tasks for CAS/DGS classrooms. V: TIME 2010, Technology and its Integration into Mathematics Education, July 6th-10th, 2010, Málaga, Spain. Proceedings of TIME 2010 : Technology and its Integration into Mathematics Education. Málaga: Universidad de Málaga, 2011, 17 str. [COBISS-SI-ID 15643993]
KUDREVIČIUS, Evelina. Platforma SharePoint in oblikovanje glavne strani : diplomska naloga. Ljubljana: [E. Kudrevičius], 2008. 77 f., ilustr. [COBISS-SI-ID 15105625]
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]