Course Details

Database Systems

Academic Year 2024/25

NUB019 course is part of 1 study plan

​ NPC-GK Winter Semester 1st year

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.

Credits

4 credits

Language of instruction

Czech

Semester

winter

Course Guarantor

Ing. Michal Vojkůvka, Ph.D.

Institute

Institute of Computer Aided Engineering and Computer Science

Forms and criteria of assessment

course-unit credit

Entry Knowledge

Basic knowledge and using of operation system especially of filesystem.

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

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)

Offered to foreign students

Not to offer

Course on BUT site

https://www.vut.cz/en/students/courses/detail/284475

Lecture

13 weeks, 1 hours/week, elective

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

13 weeks, 2 hours/week, compulsory

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.