Sep 22, 2019   10:56 p.m. Móric
Academic information system

Course syllabus B-DBS - Database systems (FEEIT - SS 2019/2020)


     Information sheet          ECTS          Syllabus          


     Slovak          English          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Electrical Engineering and Information Technology
Course unit code: B-DBS
Course unit title: Database systems
Mode of delivery, planned learning activities and teaching methods:
lecture2 hours weekly (on-site method)
seminar2 hours weekly (on-site method)

 
Credits allocated: 6
 
Recommended semester/trimester: Applied Informatics - bachelor (compulsory), 4. semester
Level of study: 1.
Prerequisites for registration: none
 
Assesment methods:
There are 1 test per 20 points and 2 projects, each per 10 points, during the semester. It is necessary to obtain at least 25 points during the semester (to get the opportunity to write the exam).
Then 60 points can be obtained at the written exam. To get the degree A, it is neccesary to obtain at least 92 points, at least 83 points to get degree B, at least 74 points to get degree C, at least 65 points to get degree D, and at least 56 points to get degree E. The credits are not assigned to a student, that obtained less than 56 points.
 
Learning outcomes of the course unit:
The students get knowledge on databases, SQL, and database management systems. The students can analyse, design, and implement a simple database application and can write queries in SQL.
 
Course contents:
1. Database, Database Management System.
2. Conceptual model.
3. Logical model, mapping a conceptual model to a logical model.
4. Relational algebra and relational calculus.
5. SQL.
6. Normal forms.
7. Physical model. Records organizations, hashing.
8. Indexes.
9. Transaction control.
10. Query optimization.
11. Distributed databases.
12. New trends in databases.
 
Recommended or required reading:
Recommended:
Delikát, T.: Základy databázových systémov, vydavateľstvo DELINT Bratislava, 2006, 209 s., ISBN: 80-969484-4-X
Elmasri,R., Navathe, S.B. : Fundamentals of Database Systems, Addison Wesley - Pearson International Edition, 2007, 5. vydanie, 1123 s., ISBN: 0-321-41506-X
Garcia-Molina, H., Ullman, J. D., Widom, J.: Database Systems. The Complete Book, Prentice Hall - Pearson International Edition, 2009, 2. vydanie, 1203 s., ISBN: 0-13-135428-0, 978-0-13-135428-9
Hernandez, M.J.: Návrh databází, Grada Publishing, a.s., 2006, 1. vydanie, 408 s., ISBN: 80-247-0900-7
Matiaško, K., Vajsová, M., Zábovský, M., Chochlík, M.: Databázové systémy a technológie, Nakladateľstvo STU Bratislava, 2009, 693 s., ISBN: 978-80-227-3035-8

 
Language of instruction: slovak or english
 
Notes:
 
Courses evaluation:
Assessed students in total: 921

ABCDEFX
3,7 %7,1 %14,4 %25,3 %39,0 %10,5 %
Name of lecturer(s): Ing. Vladislav Novák (examiner, instructor, tutor) - slovak, english
doc. Ing. Milan Vojvoda, PhD. (examiner, instructor, lecturer, person responsible for course) - slovak, english
 
Last modification: 6. 5. 2019
Supervisor: doc. Ing. Milan Vojvoda, PhD. and programme supervisor


Last modification made by RNDr. Marian Puškár on 05/06/2019.

Type of output: