Database systems

Study programs

Teaching information

Teachers

doc. Ing. Stanislav Ondáš, PhD. Ing. Zuzana Sokolová, PhD. Ing. Marianna Koctúrová, PhD. Ing. Matúš Čavojský Ing. Ján Staš, PhD.

Schedule

Learning outcomes

The student will gain knowledge of the basics of information systems, database technologies, database systems and database management systems. They will get acquainted with the concept of relational databases and the SQL (Structured Query Language). They will gain knowledge in the field of data model design, database solutions, database user management and, last but not least, they will learn to use the SQL language. He will use the acquired skills in the design and implementation of a relational database schemas, in working with database objects, creating database applications and database management.

Course outline

1. Introduction to database systems 2. Data modeling 3. Relational data model 4. Relational algebra 5. Functional dependencies, normalization 6. Database languages, SQL, query processing 7. Primary file organizations 8. Indexing 9. Transactions and their processing. Parallelism and competition techniques. Error recovery. 10. Security of database systems 11. NoSQL databases 12. Object-oriented databases, XML databases.

Completion conditions

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%. Credit test 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%. Examination 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)

Recommended literature

1. Elmasri,R., Navathe, S.B. : Fundamentals of Database Systems, The Benjamin/Cummings Publishing Company, Inc., 1., 2. , 3.vydanie 2. Sumathi, S., Esakkirajan, S.: Fundamentals of Relational Database Management Systems, Springer, 2007 3. Date C. J.: An Introduction to Database Systems, Addison-Wesley, 8th Edition, 2003 4. Date, C.J.: A guide to the SQL standard : a user's guide to the standard database language SQL, 4th ed. Reading : Addison-Wesley, c2000 5. Piatini, M., Diaz, O.: Advanced Database Technology and Design, 2000 ARTECH HOUSE, INC. 6. Matiaško, K.: Databázové systémy, EDIS - vydavateľstvo Žilinskej univerzity, 2002 7. Pokorný,J. , Halaška,I. 2003. Databázové systémy. 2. vyd. Praha: Vydavatelství ČVUT, 200 8. Telepovská Henrieta: Databázové systémy, učebné texty – skriptá, Elfa Košice, 2003 9. Telepovská Henrieta: Databázové systémy - Jazyk SQL, Technická univerzita v Košiciach, 2012

Notes

To successfully complete the course, it is necessary to obtain a credit and successfully pass the exam. This includes the student's participation in educational activities of direct teaching, lectures, exercises, as well as independent study and independent creative activity of the student in processing the semester assignment / assignments, project on a specified topic, to a specified extent, in a specified design of a total of 180 hours intensity of the student's work per semester.

Grade distribution

Total graded students: 726