|Organizational form of instruction||Lecture + Lesson|
|Level of course||Bachelor|
|Year of study||not specified|
|Number of ECTS credits||2|
|Language of instruction||Czech|
|Status of course||Compulsory, Compulsory-optional|
|Form of instruction||Face-to-face|
|Work placements||This is not an internship|
|Recommended optional programme components||None|
Students are introduced to basics of relational database systems and the SQL query language and also to the WWW internet service and basics of creating web pages. Students try to create their own database in MS Access environment and a simple web page in practices. 1. Basic concepts (database, DBMS, database system). Architecture of DS in relation to distribution of services. Location of data in DS. Distributed database. DBMS model. Relation model - basic concepts. 2. Data model. Relational algebra. Normalization in database model. 3. Database program languages. SQL language. 4. Working with MS Access. MS Visual Basic and database.
|Learning activities and teaching methods|
The students become familiar with basic concepts of databases.
1. Knowledge Define and use relational data model and database systems.
----- or -----
|Assessment methods and criteria|
Oral exam, Written exam
Active participation in class. Completion of assigned homeworks. Passing the oral (or written) exam.
|Study plans that include the course|
|Faculty||Study plan (Version)||Branch of study Category||Recommended year of study||Recommended semester|
|Faculty of Science||Applied Statistics (2015)||Mathematics courses||2||Summer|
|Faculty of Science||Mathematics-Economics of Banking / Insurance Systems (1)||Mathematics courses||1||Summer|
|Faculty of Science||Discrete Mathematics (2016)||Mathematics courses||2||Summer|