Course: Databases

« Back
Course title Databases
Course code KMI/DB
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
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
Lecturer(s)
  • Zacpal Jiří, Mgr. Ph.D.
  • Hronek Jiří, Ing.
  • Motyčková Lenka, doc. Ing. CSc.
  • Večerka Arnošt, RNDr.
Course content
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
Lecture, Demonstration
Learning outcomes
The students become familiar with basic concepts of databases.
1. Knowledge Define and use relational data model and database systems.
Prerequisites
unspecified
KMI/UVT
----- or -----
KMI/ZVT

Assessment methods and criteria
Oral exam, Written exam

Active participation in class. Completion of assigned homeworks. Passing the oral (or written) exam.
Recommended literature
  • Connolly T., Begg C. (2002). Database Systems. A Practical Approach to Design, Implementation and Management, 3rd edition. Addison Wesley.
  • Groff J. R., Weinberg P. N. (2005). SQL. Computer Press.
  • Kosek J. (1998). HTML, tvorba dokonalých WWW stránek, podrobný průvodce. Grada Publishing.
  • Oppel A. (2006). Databáze bez předchozích znalostí. Computer Press.
  • Viescas J., Conrad J. (2008). Mistrovství v Microsoft Office Access. Computer Press.


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