Course Details
Database Systems
Academic Year 2023/24
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.
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.
Course Guarantor
Institute
Objective
Basic principles of database technology explained on chosen database management system. Design and implementation of a simple database aplication.
Knowledge
Knowledge for design and implementation of simple database application
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.
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.
Prerequisites
Basic knowledge and using of operation system especially of filesystem.
Language of instruction
Czech
Credits
4 credits
Semester
winter
Forms and criteria of assessment
course-unit credit
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
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.