Course detail

Database Systems (in English)

FIT-IDSeAcad. year: 2023/2024

Fundamentals of database systems (DBS). Conceptual modeling. The relational model. Relational database design from a conceptual model. Normalization-based design of a relational database. SQL language. Transaction processing. DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to database administration: data security and integrity, introduction to physical database design, performance optimization, database recovery, concurrency control. Trends in database technology. Development of a database application in modern development and database environment.

Language of instruction

English

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

RNDr. Marek Rychlý, Ph.D.

Department

Department of Information Systems (UIFS)

Offered to foreign students

Of all faculties

Entry knowledge

The sets, relations and mappings. The elementary notions of the graph theory. Basics of hashing and tree-based search. Basic steps of software development. Rudiments of programming and data modeling.

Rules for evaluation and completion of the course

  • Data and use case models - 5 points
  • Building of the database in SQL - 9 points
  • Querying in SQL - 10 points
  • Advanced database objects and documentation - 10 points
  • Midterm written exam - 15 points
  • Final written examination - 51 points
  • To be allowed to sit for written examination student is  to present and defend project oucomes in due dates, and to earn at least 24 points during semester.

Mid-term exam passing, realization and presentation/defence of projects in due dates.

Aims

Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications and database administration.

Student is able to develop conceptual models of an application domain for database applications. He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, has experience with some integrated development environment for database applications, and has knowledge of relational database management system fundamentals. He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning. Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery. Student acquaints with basic English terminology in the subject.

Student will learn how to analyze a given problem in a small team and he/she will learn to design and implement solution of the problem individually. He/she learns to present and defend both partial and final results of the project.

Study aids

Not applicable.

Prerequisites and corequisites

Basic literature

Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p. (EN)

Recommended reading

Ramakrishnan R.: Database Management Systems. Third edition. McGraw-Hill Science/Engineering/Math, 2000, 1104 p. (EN)
Date C.J.: An Introduction to Database Systems. Seventh edition. Addison-Wesley, 2000, 838 p. (EN)
Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p. (EN)
Zendulka, J., Rudolfová, I.: Databázové systémy. IDS. Studijní opora. FIT VUT v Brně. 2006, 217 s. (CS)
Oracle Database Documentation [online]. Redwood Shores, CA, USA: Oracle Corporation, 2021 [cit. 2021-12-23]. Available at: https://docs.oracle.com/en/database/oracle/oracle-database/ (EN)

eLearning

eLearning: currently opened course

Classification of course in study plans

  • Programme IT-BC-1H Bachelor's

    specialization BCH , any year of study, summer semester, recommended

Type of course unit

 

Lecture

39 hours, optionally

Teacher / Lecturer

RNDr. Marek Rychlý, Ph.D.

Syllabus

  1. Course Introduction, Introduction to Databases
  2. Database Analysis and Design, Conceptual Modelling and Entity-Relationship Diagram
  3. Relational Database Model
  4. Transformation of a Conceptual Model to a Relational Database Schema, Normalization
  5. SQL: Data Definition
  6. Relational Algebra and Calculus
  7. SQL: Select Statements
  8. SQL: Indices and Views
  9. Database Performance, Indexing and Hashing
  10. SQL: Database Triggers and Stored Procedures
  11. Database Transactions
  12. Database Security
  13. Architectures of Database Systems

Project

13 hours, compulsory

Teacher / Lecturer

RNDr. Marek Rychlý, Ph.D.

Syllabus

  1. Conceptual model (ERD)
  2. SQL script to create database in accordance with the conceptual model
  3. SQL script with at least four SELECT database queries and one view
  4. SQL script with at least one database trigger, one stored procedure or function, and one database index

eLearning

eLearning: currently opened course