Course Details
Relational Database Management Systems
Academic Year 2024/25
DUB027 course is part of 4 study plans
DKA-GK Summer Semester 1st year
DPA-GK Summer Semester 1st year
DKC-GK Summer Semester 1st year
DPC-GK Summer Semester 1st year
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.
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.
Credits
7 credits
Language of instruction
Czech
Semester
summer
Course Guarantor
Institute
Forms and criteria of assessment
examination
Entry Knowledge
Basic knowledge and using of operation system especially of filesystem.
Offered to foreign students
Not to offer
Course on BUT site
Lecture
13 weeks, 3 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.