Course: Database Systems

» List of faculties » FZS » MTI
Course title Database Systems
Course code MTI/DAS*Z
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
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Lamr Marián, Ing. Ph.D.
Course content
Lectures 1. The first lecture: History of database systems, overview on current as well historic data models. Multilayer database architecture overview. 2. The second and third lecture: Relation databases principles, basic data modeling. Conceptual schema modeling (ERD model), functional modeling approaches (DFD), normalization and relations design principles 3. The fourth and fifth lecture: Unified Modeling Language (UML) basics, more detail overview on database modeling in UML (class, use case, deployment diagrams) plus behavioral diagrams. 4. The seventh and eighth lecture: SQL data definition language (creation of a new database and database objects, constraints, foreign keys, primary keys) 5. The night and tenth lecture: SQL data manipulation language (basics commands for data manipulation in relational databases, advanced data manipulation techniques and commands) 6. The eleventh lecture: advanced topics in SQL (complicated SQL commands, nested commands, left, right, outer, inner joins) 7.-8. The twelfth lecture: overview on indexes and data structures used in databases for indexing. 9.-10. The main advantages on disadvantages of different index types are discussed, SQL command for indexes creation are also given. 11.-12. The thirteenth and fourteenth lecture: Server site programming, stored procedures, triggers. 13.-14. The fifteenth lecture: Invited lecture by a selected expert in the database system field from a commercial field. Practice 1. Overview on file organizations used for data storage. 2. Normalization process is explained on selected examples 3.-4. Conceptual schema modeling (Case studio) - ERD model 5.-6. Functional modeling (Case studio) - DFD model 7.-8. UML basics, UML approaches for modeling databases 9. SQL DDL introduction, creation of several database objects, constraints and experimental verification of expected behavior 10.-11. SQL DML, at the beginning simple commands for data manipulation in relational database, followed by more complicated and sophisticated commands 12.-13. SQL server site programming principles, stored procedure, triggers 14. Note that MS SQL Server 2005 has bee

Learning activities and teaching methods
Monological explanation (lecture, presentation,briefing), Working activities (workshops)
  • Class attendance - 42 hours per semester
Learning outcomes
The course aims the current trends in database systems. Students follow during the courses standard principles in creation of database information systems with a special emphasis on pragmatic approaches in realization of the server as well as client site of the application. Particularly, students are given information about functional and data modeling approaches, followed by SQL, security aspects, transaction overview and server site programming.
The course overviews data structures used for algorithm creation and further computer data processing in the case of more complicated (mathematical) problems. Students are given information about commonly used as well as special database systems used for building information systems for special cases (e.g., GIS). Data base modeling approaches are also mentioned and students are introduced to data as well as functional database modeling approaches.
Prerequisites
Unspecified

Assessment methods and criteria
Combined examination, Oral exam, Written exam

Active participation on seminars. Oral presentation of the student's project at the end of semester.
Recommended literature
  • BRUCKNER, T., VOŘÍŠEK, J., BUCHALCEVOVÁ, A- a. kol. Tvorba informačních systémů. Principy, metodiky, architektury. Grada Publishing, 2012. ISBN 978-80-247-4153-6.
  • POKORNÝ, J., VALENTA, M. Databázové systémy. ČVUT Praha, 2013. ISBN 978-80-01-05212-9.
  • Šešera L. a kol. Datové modelování v příkladech. Grada.
  • Šimůnek P. SQL - kompletní kapesní průvodce. Grada, 1999.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Health Studies Study plan (Version): Biomedical Technology (12) Category: Special and interdisciplinary fields 2 Recommended year of study:2, Recommended semester: Summer