Data bases 2

2022/2023
Programme:
Practical Mathematics
Year:
3 year
Semester:
second
Kind:
optional
ECTS:
5
Language:
slovenian
Hours per week – 2. semester:
Lectures
2
Seminar
0
Tutorial
2
Lab
0
Content (Syllabus outline)

Basic concepts of database design. Normal forms and benefits of their use. ER diagrams.
Basic concepts of database management: user roles and privileges, logical and physical space, logging and modes of DBMS execution.

Readings

R. Ramakrishnan, J. Gehrke: Database Management Systems, 3. izdaja, McGraw-Hill, Boston, 2003.
T. M. Connolly, C. E. Begg: Database Systems: A Practical Approach to Design, Implementation and Management, 4. izdaja, Addison Wesley, 2004.
S. Sumathi, S. Esakkirajan: Fundamentals of Relational Database Management Systems, Springer, 2007.
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.
Manuals and textbooks for data base tools and for programming languages.
Notes from lectures, tutorials and other resources in the online classroom.
References and resources are refreshed regularly to address the development of data bases and programming languages. Specific resources listed would have been at the time of the implementation already obsolete.

Objectives and competences

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.

Intended learning outcomes

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.

Learning and teaching methods

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

Assessment

Students get one grade from homework, written exam and a term paper.
grading: 5 (fail), 6-10 (pass) (according to the Statute of UL)

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]
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:
MARKOVIČ, Katja. Izdelava vodičev za uporabo programa GeoGebra : diplomska naloga. Ljubljana: [K. Markovič], 2011. 73 f., ilustr. [COBISS-SI-ID 16189529]
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]
LOKAR, Matija. Prvenstvo študentskih ekip Univerze v Ljubljani v programiranju 2002. Ljubljana: [Fakulteta za matematiko in fiziko], 2002. 100 str., ilustr. [COBISS-SI-ID 12122457]