Information sheet ECTS Syllabus
Course syllabus B-DBS - Database systems (FEEIT - SS 2019/2020)
|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:|
|Recommended semester/trimester:||Applied Informatics - bachelor (compulsory), 4. semester|
|Level of study:||1.|
|Prerequisites for registration:||none|
|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.|
|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.
6. Normal forms.
7. Physical model. Records organizations, hashing.
9. Transaction control.
10. Query optimization.
11. Distributed databases.
12. New trends in databases.
|Recommended or required reading:|
|Language of instruction:||slovak or english|
|Assessed students in total: 921|
|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.