![[DS] Database systems](https://www.kis.fri.uniza.sk/wp-content/themes/Divi-child/imgs/KIS-subject-default.png)
Main objectives of the course:
Student could understand:
– Principles of Database systems.
– Database systems design.
– Data modeling.
– Data definition and data manipulation language.
Student receive the practise with Master work with the particular database system.
| Course information sheet | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| University: University of Žilina | |||||||||||||
| Faculty: Faculty of Management Science and Informatics | |||||||||||||
| Course ID: 5BI106 | Course name: Database systems (DS) | ||||||||||||
| Form, extent and method of teaching activities: | |||||||||||||
| Number of classes per week in the form of lectures, laboratory exercises, seminars or clinical practice | Lectures: 2.0 Seminars: 0.0 Lab.exercises: 2.0 | ||||||||||||
| Methods by which the educational activity is delivered | Present form of education | ||||||||||||
| Applied educational activities and methods suitable for achieving learning outcomes | |||||||||||||
| Number of credits: 5.0 | |||||||||||||
| Study workload: hours Specification of the study workload: | |||||||||||||
| Recommended term of study: 2. year, winter semester | |||||||||||||
| Study degree: 1. | |||||||||||||
| Required subsidiary courses: Prerequisites: Recommended knowledge - Informatics 1,2,3 Co-requisites: | |||||||||||||
| Course requirements: Continuous assessment / evaluation: The student is responsible: (1) To Solve prepared tasks on each laboratory work. (2) To be present during laboratory works - two absence are acceptable (3) As a member of the team will create three projects deals basic information system using DBS under his choice from the prepared offers. - Data model and Normalization (max. 15 + 5 points) - Normalization of the Data model(max. 15 points) - The basic Information system (max. 25 points, min) (maximum is 60 points - minimum 31 points) (4) To pass two checking test. Each for 20 points. (min. 24 points, max. 40 points). Final assessment /evaluation: The student is responsible to fulfill all defined requirements during the semester. The exam will continue by test, where is possible receive 100 points. Additional points are possible to gain during the oral exam if the student received in the test at least 61 points. The complex sum of points aggregate results from exercises and exam from the final test. A 186 points B 170 – 185 C 144 – 169 D 135 – 143 E 121 – 134 Fx under 121. To enroll for an exam student must have 61 points. | |||||||||||||
| Course outcomes: Student could understand: - Principles of Database systems. - Database systems design. - Data modeling. - Data definition and data manipulation language. Student receive the practise with Master work with the particular database system. | |||||||||||||
| Course scheme: Lectures: Basic concepts. Database systems architecture. Entity-Relationship model. Relational DBS. Relational integrity. Relational algebra. Normal forms (1NF, 2NF, 3NF, BCNF). Introduction to SQL. Data manipulation in SQL. Introduction to Transaction management. Cursors. Laboratory work: Creating of information system on existing DBS. Creating of database, tables and data types. Creating simple and multitable forms. SQL statements – INSERT, UPDATE, DELETE, SELECT. Creating reports and menus. Application of triggers, procedures, views. Masters work with specific database system. | |||||||||||||
| Literature: • K.Matiaško, Michal.Kvet, Marek.Kvet: Databázové systémy 1.diel a 2. diel. EDIS 2018. • K.Matiaško, M.Vajsová, M.Kvet: Pokročilé databázové systémy. Umenie programovania a administrácie. EDIS 2017. • K.Matiaško, M.Vajsová, M.Kvet: Pokročilé databázové systémy. Architekúra, programovanie s objektami, XML. EDIS 2017. • K. Matiaško, M. Kvet, V. Šalgová, V. Vestenický: Rýchly vývoj dátových modelov a aplikácií v prostredí Oracle APEX. EDIS 2020 9(aj USB verzia) • K.Matiaško, Michal.Kvet, Marek.Kvet: Practices for Database systems. EDIS 2017. (Aj CD verzia) • C.J.Date: An Introduction to Database Systems, Vol. I. a II., Addison-Wesley, 8th Edition • K. Matiaško, M. Kvet: Temporálne databázy, EDIS 2020 • D. Maier: The Theory of Relational Databases, Computer Science Press,1983 • J. Pokorný: Databázové systémy - vybrané kapitoly a cvičení, UK Praha, 1993 • J. Pokorný: Dotazovací jazyky, Science, 1994 • Whitten, Bentley, Barlow: Systems Analysis and Design Methods • D.J.Ullman: Principles of Database and Knowledge-base Systems, Vol I., Computer Science Press, 1988 • J. Pokorný: Databázové systémy a jejich použití v informačních systémech. Academia, 1992 • Dokumentácia k systému Oracle | |||||||||||||
| Instruction language: slovak/english | |||||||||||||
| Notes: | |||||||||||||
| Course evaluation:: Total number of evaluated students: 1106
| |||||||||||||
| A | B | C | D | E | FX | ||||||||
| 3.98 % | 7.69 % | 17.27 % | 16.64 % | 20.25 % | 34.18 % | ||||||||
| Course teachers: | |||||||||||||
| Last updated: 2021-11-18 08:41:54.000 | |||||||||||||
| The person responsible for the course: prof. Ing. Karol Matiaško, PhD. | |||||||||||||
| Approved by: prof. Ing. Pavel Segeč, PhD. | |||||||||||||