Courses

Course title:Introduction into Databases
Faculty:Faculty of Science
Department:Department of Informatics and Computers
Course code:KIP / 7UVDT
Credits:5
Semester:Winter
Level of study:Bc.
Format of study:Lecture 2 [Hours/Week], Practical classes 2 [Hours/Week]
Name of the lecturer:Ing. Zdeňka Telnarová, Ph.D. (G)
Language:Czech, English
ISCED F broad:Information and Communication Technologies
Annotation:Introduction to Database Technology, main characteristics, history of Database Technology. Analysis and design of conceptual model, E-R diagrams, UML, relational data model, Type and Organisations of Database Files, Dynamic Organization, B-trees, hashing, reduction of the data. Normalisation, decomposition of the relations. Introduction to DDL, DML, integrity constraints, introduction to PL/SQL: procedures, functions, triggers.