Course Details

Database Systems

Academic Year 2024/25

NUB019 course is part of 1 study plan

NPC-GK Winter Semester 1st year

Course Guarantor

Institute

Language of instruction

Czech

Credits

4 credits

Semester

winter

Forms and criteria of assessment

course-unit credit

Offered to foreign students

Not to offer

Course on BUT site

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.