Course Details

Database Systems

Academic Year 2023/24

NUB017 course is part of 2 study plans

​ NPC-SIK Summer Semester 1st year

​ NPC-MI Summer Semester 1st year

Database technology, terminology, data models, relational concept, relational algebra and calculus.
Conceptual modeling, E-R diagrams, normal forms of the design. Data consistency and integrity.
Non-procedural language SQL and QBE, commands for creating and maintaining data structures, data manipulation and retrieval of information.
Basic algorithms of database engines.
Classification of database systems, network architectures, interface ODBC
Hosting language T-SQL, database cursor, stored procedures, functions and triggers.
Data analysis, information systems design, introduction to process analysis.
Example of information system in the three-layer technology and ISAM type system.

Course Guarantor

doc. RNDr. Jiří Macur, CSc.

Institute

Institute of Computer Aided Engineering and Computer Science

Objective

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

Knowledge

Knowledge for design and implementation of simple database application

Syllabus

1. Basic concepts, data base management systems, starting principles, database systems classification.
2. Data models, relation as the set and its representation in memory.
3. Relational algebra and calculus.
4. Conceptual modeling, database normalization, E-R diagrams and their transformation into the system data base.
5. Modeling of relationships between entities, primary and foreign keys, associative entities.
6. Data integrity and consistency, referential integrity, methods of enforcement.
7. Basic internal algorithms of databases, indexing, B-trees, hashing, levels of data locking.
8. The language SQL, commands of subsets DDL and DML.
9. Construction of the complex command SELECT.
10. Views, functions, stored procedures and triggers, hosting language T-SQL. Database cursor. Transaction processing and access control.
11. Modern database systems Oracle, MySQL, MS SQL, ISAM systems, network architecture, ODBC interface.
12.–13. Data analysis and implementation of the information system in three tiers architecture.

Prerequisites

Basic knowledge and using of operation system especially of filesystem.

Language of instruction

Czech

Credits

4 credits

Semester

summer

Forms and criteria of assessment

course-unit credit and examination

Specification of controlled instruction, the form of instruction, and the form of compensation of the absences

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

Offered to foreign students

Not to offer

Course on BUT site

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

Lecture

13 weeks, 2 hours/week, elective

Syllabus

1. Basic concepts, data base management systems, starting principles, database systems classification. 2. Data models, relation as the set and its representation in memory. 3. Relational algebra and calculus. 4. Conceptual modeling, database normalization, E-R diagrams and their transformation into the system data base. 5. Modeling of relationships between entities, primary and foreign keys, associative entities. 6. Data integrity and consistency, referential integrity, methods of enforcement. 7. Basic internal algorithms of databases, indexing, B-trees, hashing, levels of data locking. 8. The language SQL, commands of subsets DDL and DML. 9. Construction of the complex command SELECT. 10. Views, functions, stored procedures and triggers, hosting language T-SQL. Database cursor. Transaction processing and access control. 11. Modern database systems Oracle, MySQL, MS SQL, ISAM systems, network architecture, ODBC interface. 12.–13. Data analysis and implementation of the information system in three tiers architecture.

Exercise

13 weeks, 2 hours/week, compulsory

Syllabus

1. User environment of the selected data management system. Tools for data structure definition, relationships, and information searching. 2. Configuration of the tables, data types, data interpretation formats, setting of integrity constraints and business rules. 3. SQL SELECT command and its representation in system of forms environment. 4. Data grouping, aggregates, filtering by their properties. 5. Inner and outer data joins, searching in related entities. 6. Commands for SQL data manipulation. Using the relations while data changing. 7. Instruments for configuration of data interpretation. Settings of output data format, data constraints and rules. 8. Using data enumerators and data links for data management. 9. Import and export data, using of public data warehouses, interface ODBC. 10. Working in the environment of the hosting language. Program for batch processing using the database cursor. 11.–12. User interface design for viewing and managing data. 13. Evaluation of individual tasks and knowledge testing.