Palacký University Olomouc
Study programmes & Course catalogue
for academic year 2024/2025
Palacký University Olomouc
Česky
Search

Course: Database Systems

» List of faculties » PRF » KMI
Course title Database Systems
Course code KMI/DATA1
Organizational form of instruction Lecture + Exercise
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Laštovička Jan, Mgr. Ph.D.
Course content
Introduction to DBS. Notions, data and abstract models of data. DBS architecture. Models of DBS. Relational model of DBS and its characteristics, relational structure of data, the language of relational DBS. Introduction to SQL language. SQL, creation and filling of the table, queries (with conditions, column functions). Aggregation, nested queries, data manipulation. Referential integrity, integrity constraints, primary and secondary key. Joining tables. Foreign key. Table structure modification. Set operations, quantifiers. Analysis and design of relational DB. Conceptual modeling. ER model. Transformation to relational model. Complex queries construction. Further topics in relational DBS and SQL. Transitive closure of table. Views, triggers and indexes. Cooperation of SQL with other languages. The basics of administration of relational DBS. Transactional data processing. Basic principles of transactional processing. Data consistency violation prevention. Parallel processing of transactions, locking protocols, deadlock, two-phase commit protocol, timestamps. heoretical basics of relational DBS. Table formalization, relational algebra, relational logic and calculi, query systems. Functional dependencies, Armstrong's axioms, closure, covering. Normal forms. First, second and third normal form. Boyce-Codd normal form. Normalization by decomposition of relation schemes.

Learning activities and teaching methods
Lecture, Demonstration
Learning outcomes
The students become familiar with basic concepts of database systems.
2. Comprehension. Understand basic concepts of database systems.
Prerequisites
unspecified

Assessment methods and criteria
Oral exam, Written exam

Active participation in class. Completion of assigned homeworks. Passing the oral (or written) exam.
Recommended literature
  • Braharu D. (2018). Database For Beginners: Relational Database Concepts and Model (Programming courses). Independently published.
  • Connolly Thomas, Begg Carolyn. (2002). Database Systems: A Practical Approach to Design, Implementation and Management. Addison Wesley.
  • Elmasri R., Navathe S. B. (2000). Fundamentals of Database Systems, 3rd edition. Addison Wesley.
  • Johnson James L. (1997). Database Models, Languages, Design. Oxford University Press.
  • Maier R. (1983). The Theory of Relational Databases. Computer Science Press.
  • Pokorný J. (1992). Databázové systémy a jejich použití v informačních systémech. Academia.
  • Rob. P., Coronel C. (2004). Database Systems. Design, Implementation & Management, 6th edition. Thomson Course Technology.
  • Simovici D. A., Tenney R. L. (1995). Relational Database Systems. Academic Press.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Palacký University Olomouc, date of update: 30.04.2025 23:58. Data created for academic year 2024/2025