SYLLABUS
University: Technical University of Košice
Faculty: Faculty of Electrical Engineering and Informatics
Department: Department of Computers and Informatics
Course Number: 26001025 Course Name: Database systems and their security
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): 2,2
Part-time study (hours per semester): 26,26
Study Method:
Number of credits: 6
Recommended semester of study: ST
Recommended semester Study programme Study grade Study Method
2.rok ST Cybersecurity (KB_Bc_D_sk) Bachelor 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. Elmasri,R., Navathe, S.B. : Fundamentals of Database Systems, The Benjamin/Cummings Publishing Company, Inc., 1., 2. edition
2. Date, C.J.: A Guide the SQL Standard
Recommended optional program components:
Languages required for the course completion:
Notes:
Course assessment:
Total number of students assessed: 84
  A B C D E FX  
  4% 15% 17% 25% 13% 26%  
Teacher:
doc. Ing. William Steingartner, PhD.
Ing. Ján Perháč, PhD.
Last modified: 01.09.2022
Approved by: person(s) responsible for the study program