Data bases 1

2022/2023
Programme:
Practical Mathematics
Year:
3 year
Semester:
first
Kind:
mandatory
ECTS:
6
Language:
slovenian
Hours per week – 1. semester:
Lectures
2
Seminar
1
Tutorial
2
Lab
0
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. CREATE TABLE, INSERT, UPDATE, DELETE.
Views. Basics of transactions.
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

Home works (requirement for taking the written exam) written exam
Oral exam – the presentation of term paper
Students receive two grades: one from the written exam and home works and the other from the oral exam.
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]