Course Details

Relational Database Management Systems

DUB027 course is part of 4 study plans

Ph.D. full-t. program DPC-GK compulsory-elective Summer Semester 1st year 7 credits

Ph.D. combi. program DKC-GK compulsory-elective Summer Semester 1st year 7 credits

Ph.D. full-t. program DPA-GK compulsory-elective Summer Semester 1st year 7 credits

Ph.D. combi. program DKA-GK compulsory-elective Summer Semester 1st year 7 credits

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.

Course Guarantor

doc. RNDr. Jiří Macur, CSc.

Institute

Institute of Computer Aided Engineering and Computer Science

Prerequisites

Basic knowledge and using of operation system especially of filesystem.

Planned educational activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

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

Vymezení kontrolované výuky a způsob jejího provádění stanoví každoročně aktualizovaná vyhláška garanta předmětu.

Lecture

3 hours/week, 13 weeks, elective

Syllabus of lectures

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.