Course detail

Relational Database Management Systems

FAST-IU53Acad. year: 2022/2023

Database technology fundamentals, terminology, data modelling.
Relational data model, relation algebra, data integrity.
Conceptual modelling, Entition-Relationship diagrams.
RDBMS languages, SQL language.
RDBMS architecture.
ISAM and SQL systems (MS Access, MS SQL2000 Server).
Practices of analytical skills. As a project students develop a simple database system in chosen production branch.

Language of instruction

Czech

Number of ECTS credits

7

Mode of study

Not applicable.

Guarantor

doc. RNDr. Jiří Macur, CSc.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Not applicable.

Prerequisites

Basic knowledge and using of operation system especially of filesystem.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Not applicable.

Course curriculum

1. Data modelling, current approaches
2. Relational model for database management, relation and its representation
3. Relational algebra
4. Conceptual modelling
5-6. Tables, relationships, primary and foreign keys, E-R diagrams
7. Indexing
8. Reference integrity
9. SQL language, DDL and DML commands
10. Complex SELECT queries
11. Views, stored procedures in TSQL. Transactions and access management.
12. Overview of current database management systems: Oracle, MySQL, SQL Server, ISAM
13. Sample analysis of simple information system.

Work placements

Not applicable.

Aims

Basic principles of database technology explained on chosen database management system. Design and implementation of a simple database aplication.

Specification of controlled education, way of implementation and compensation for absences

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Rebecca M. Riordan: Vytváříme relační databázové aplikace. Computer Press 2000

Recommended reading

Pokorný Jaroslav: Databázová abeceda. Science, Veletiny 1998
Pokorný Jaroslav: Dotazovací jazyky. Science, Veletiny 1994

Classification of course in study plans

  • Programme D-P-C-GK Doctoral

    branch GAK , 1 year of study, summer semester, compulsory-optional

  • Programme D-K-C-GK Doctoral

    branch GAK , 1 year of study, summer semester, compulsory-optional

Type of course unit

 

Lecture

39 hod., optionally

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.

Syllabus

1. Data modelling, current approaches 2. Relational model for database management, relation and its representation 3. Relational algebra 4. Conceptual modelling 5-6. Tables, relationships, primary and foreign keys, E-R diagrams 7. Indexing 8. Reference integrity 9. SQL language, DDL and DML commands 10. Complex SELECT queries 11. Views, stored procedures in TSQL. Transactions and access management. 12. Overview of current database management systems: Oracle, MySQL, SQL Server, ISAM 13. Sample analysis of simple information system.

Exercise

26 hod., compulsory

Teacher / Lecturer

doc. RNDr. Jiří Macur, CSc.