Course detail

Database Systems

FAST-NUB019Acad. year: 2023/2024

Database technology fundamentals, terminology, data modelling.
Relational data model, relation algebra, data integrity.
Conceptual modelling, Entity-Relationship diagrams.
RDBMS languages, SQL language.
RDBMS architecture.
Microsoft Access, Microsoft SQL Server.
The goal of the course is practice of analytical skills. As a project students develop a simple database system in chosen production branch.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Guarantor

Ing. Michal Vojkůvka, Ph.D.

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Entry knowledge

Basic knowledge and using of operation system especially of filesystem.

Rules for evaluation and completion of the course

Prerequisites for successful passing of the course are:
- Attendance at the seminars in the level specified by the lecturer.
- Passing written test covering topics discussed on lectures.
- Project (design custom demonstration system, create E-R diagram), orientation in chosen database system in the scale exercised on seminars.


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

Aims

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

Knowledge for design and implementation of simple database application

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

POKORNÝ, Jaroslav a Michal VALENTA. Databázové systémy. Praha: České vysoké učení technické v Praze, 2013. ISBN 978-80-01-05212-9.

(CS)

RIORDAN, Rebecca M. Vytváříme relační databázové aplikace. Praha: Computer Press, 2000. Databáze. ISBN 80-7226-360-9.

(CS)

LAURENČÍK, Marek. Excel 2016: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2017. Průvodce (Grada). ISBN 978-80-271-0477-2.

(CS)

Recommended reading

LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. Průvodce (Grada). ISBN 978-80-271-0774-2.

(CS)

Classification of course in study plans

  • Programme NPC-GK Master's, 1. year of study, winter semester, compulsory-optional

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Michal Vojkůvka, Ph.D.

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 hours, compulsory

Teacher / Lecturer

Ing. Michal Vojkůvka, Ph.D.

Syllabus

1. Comparison of work with data in demo application between application user interface and underlying database management system interface. 2. Using simple tools for information extraction (ordering a filtering). Data imports and exports. 3. Table structure definition, data types, integrity constraints implementation. 4.–6. Creating queries for information extraction. 7.–9. Relationships between tables, complex queries, SQL language notation. 10.–12. Assigning of themes for projects, project consultations. 13. Projects submission, final test.