SYLLABUS

University: Technical University of Košice

Faculty: Faculty of Electrical Engineering and Informatics

Department: Department of Computers and Informatics

Course Number: 2601001

Course Name: Database Systems

Type, scope and method of learning activities:
Course Type: Lecture, Laboratory exercise
Recommended scope of the course content (in hours):
Full-time study (hours per week): 3,2
Part-time study (hours per semester): ST 39,26
Study Method:

Number of credits: 6

Recommended semester of study: ST

Recommended semester

Study programme

Study grade

Study Method

2.rok ST

Computer Modelling (PM_Bc_D_sk)
Intelligent Systems (IS_Bc_D_en)
Informatics (INF_Bc_D_en)
Informatics (INF_Bc_D_sk)
Intelligent Systems (IntS_Bc_D_en)

Bachelor
Bachelor
Bachelor
Bachelor
Bachelor

Attendance
Attendance
Attendance
Attendance
Attendance

Level of study:

Prerequisites:

Course completion requirements:
Assessment and completion of the course: Credit test and examination
Continuous assessment: Student passes the continuous assessment and receives credits when he or she meets the requirement to obtain at least 21% out of 40%.
individual work
Final assessment: Student passes the final assessment and passes the examination when he or she meets the requirement to obtain at least 31% out of 60%.
exam
Overall assessment: Overall assessment is the sum of the assessments obtained by students in the assessment period. The overall result is determined in accordance with the internal regulations of the Technical University in Košice. (Study Regulations, the internal regulation principles of doctoral studies)

Learning outcomes:
Student obtains knowledge of database system fundamentals and base principals of structured query language (SQL). Student exploits obtained skills in work with database objects and development of client-server database applications in practice and next study.

Brief course content:
1. Introduction to Database Systems
2. Data Modeling
3. Relational Data Model
4. Relational Algebra
5. Functional Dependencies and Normalization
6. Database Languages and Structured Query Language
7. Primary File Organization
8. Index File Organization
9. Transaction Processing
10. Concurrency Techniques and Recovery
11. Database Systems Security
12. Distributed Database Systems

Recommended Reference Sources:
1. Pokorný, J.: Konstrukce databázových systémů, skripta, Vydavatelstvo ČVUT, 1999
2. Pokorný, J.: Databázové systémy a jejich použití v informačných systémech, Academia, 1992
3. Matiaško, K.: Databázové systémy, EDIS - vydavateľstvo Žilinskej univerzity, 2002
4. Elmasri,R., Navathe, S.B. : Fundamentals of Database Systems, The Benjamin/Cummings Publishing Company, Inc., 1., 2. edition
Date, C.J.: A Guide the SQL Standard
5. Telepovská, H.: Databázové systémy, Elfa 2003

Recommended optional program components:

Languages required for the course completion:

Notes:

Course assessment:
Total number of students assessed: 2869

10%

17%

28%

23%

18%

Teacher:
doc. Ing. Ján Genči, PhD.

Last modified: 31.08.2020

Approved by: person(s) responsible for the study program