Lecturer(s)
|
-
Tyl Pavel, Ing.
-
Špánek Roman, Ing. Ph.D.
-
Vitvarová Jana, Ing. Ph.D.
|
Course content
|
The subject deals with the theory of the relational data mode, normal forms, principles of the SQL, algorithms of relational database schema design, normal forms. Principles of the client-server technology, description of SQL language and its practical applications. Processing queries in a network environment, optimisation of SQL query evaluation.
|
Learning activities and teaching methods
|
Monological explanation (lecture, presentation,briefing), Working activities (workshops)
- Class attendance
- 56 hours per semester
|
Learning outcomes
|
The course aims at data and functional analysis and creation of information systems based on databases. For the analysis Case systems are used. Normalization as a basic measure of quality of database schema is discussed in details. Relational algebra - the predecessor of SQL language is also introduced. SQL language is used for realization of the modeled reality on server site. Server site security issues and advanced topics connected with transactions management are also given.
Students will acquire further knowledge in database systems. Algorithms are focused on maintaining server site, maintaining disk files, database methods.
|
Prerequisites
|
Basic knowledge of databases systems. Programming ability in an object programming language (java, C#)
|
Assessment methods and criteria
|
Combined examination, Oral exam
|
Recommended literature
|
-
Jaroslav Pokorný. Databázové systémy. Praha : Česká technika - nakladatelství ČVUT, 2020. ISBN 978-80-01-06696-6.
-
Mlýnková, Irena. Big Data a NoSQL databáze. 2015, 2015. ISBN 978-80-247-5466-6.
-
Sokolowsky, Peter. Distribuované databázové systémy. Praha, 1992. ISBN 80-200-0442-4.
-
Šimůnek, Milan. SQL. Praha, 1999. ISBN 80-7169-692-7.
|