A course is the basic teaching unit, it's design as a medium for a student to acquire comprehensive knowledge and skills indispensable in the given field. A course guarantor is responsible for the factual content of the course.
For each course, there is a department responsible for the course organisation. A person responsible for timetabling for a given department sets a time schedule of teaching and for each class, s/he assigns an instructor and/or an examiner.
Expected time consumption of the course is expressed by a course attribute extent of teaching. For example, extent = 2 +2 indicates two teaching hours of lectures and two teaching hours of seminar (lab) per week.
At the end of each semester, the course instructor has to evaluate the extent to which a student has acquired the expected knowledge and skills. The type of this evaluation is indicated by the attribute completion. So, a course can be completed by just an assessment ('pouze zápočet'), by a graded assessment ('klasifikovaný zápočet'), or by just an examination ('pouze zkouška') or by an assessment and examination ('zápočet a zkouška') .
The difficulty of a given course is evaluated by the amount of ECTS credits.
The course is in session (cf. teaching is going on) during a semester. Each course is offered either in the winter ('zimní') or summer ('letní') semester of an academic year. Exceptionally, a course might be offered in both semesters.
The subject matter of a course is described in various texts.
BI-DBS.21 Database Systems Extent of teaching: 2P+2R+1L Instructor: Valenta M. Completion: Z,ZK Department: 18102 Credits: 5 Semester: L Annotation:
Students are introduced to the database engine architecture and typical user roles. They are briefly introduced to various database models. They learn to design small databases (including integrity constraints) using a conceptual model and implement them in a relational database engine. They get a hands-on experience with the SQL language, as well as with its theoretical foundation - the relational database model. They learn the principles of normalizing a relational database schema. They understand the fundamental concepts of transaction processing, controlling parallel user access to a single data source, as well as recovering a database engine from a failure. They are briefly introduced to special ways of storing data in relational databases with respect to speed of access to large quantities of data. This introductory-level course does not cover: Administration of database systems, debugging and optimizing database applications, distributed database systems, data stores.
Lecture syllabus:
1. Basic principles of database systems, architectures of database management systems. 2. Conceptual, database, and physical level of view of data. 3. Conceptual data model. Basic constructs, expression of integrity constraints. 4. Relational data model. Relation, attributes, domains, relational database schema, relational algebra. 5. Introduction to the SQL language: basics of the SELECT statement, basics of the SQL DDL. 6. Design of a relational scheme by direct transformation from a conceptual scheme. 7. The SQL language - advanced querying: aggregation, nested queries, set operations. 8. The SQL language: parts DCL, DML, TCL. 9. Transactions, error recovery, parallel access coordination, data protection. 10. Functional dependencies, normal forms of relations, normalization of a relational scheme by decomposition. 11. Physical level of view of data. Indexes and their use in relational databases. Basics of SQL query optimization. 12. Nonrelational database models. Trends in databases. 13. Access of applications to a (relational) database. Introduction to the concept of software engineering. Seminar syllabus:
1. Seminar: Introduction, project assignment. 2. Computer lab: Introduction to the environment and the tools. 3. Seminar: Conceptual data modeling. 4. Computer lab: SQL communication with a database engine, working with a conceptual modeler. 5. Seminar: Conceptual data modeling, relational algebra as a query language. 6. Computer lab: Working on projects, consultations. 7. Seminar: Relational algebra as a query language. 8. Computer lab: Working on projects, consultations. 9. Seminar: SQL. 10. Computer lab: Working on projects, consultations, project checkpoint. 11. Seminar: SQL. 12. Computer lab: Working on projects. 13. Seminar: Normalization of a schema, functional dependencies. Assessments Literature:
1. Coronel C., Morris S. : Database Systems: Design, Implementation, and Management (13th Edition). Cengage Learning, 2018. ISBN 978-1337627900. 2. Garcia-Molina H., Ulman D. J., Widom J. : Database systems: The Complete Book (2nd Edition). Pearson Education, 2009. ISBN 978-0131873254. 3. Harrington J.L. : Relational Database Design and Implementation (4th Edition). Morgan Kaufmann, 2016. ISBN 978-0128043998. 4. Pokorný J., Valenta M.: Databázové systémy (2. rozšířené vydání). CVUT Praha, 2020. ISBN 978-80-01-06708-6. Requirements:
Common user-level knowledge of Unix/Linux and MS Windows operating systems, ability to describe a solution to a problem algorithmically, and elementary knowledge of algebra and logic are expected. Active knowledge of a specific programming language is not required.
Informace o předmětu a výukové materiály naleznete na https://courses.fit.cvut.cz/BI-DBS/
Na tento předmět navazuje v magisterském studiu předmět Pokročilé databázové systémy a také Databázové systémy v praxi.The course is also part of the following Study plans:
Page updated 24. 4. 2024, semester: Z/2020-1, Z/2019-20, Z/2023-4, Z/2021-2, L/2022-3, Z/2024-5, L/2019-20, Z/2022-3, L/2020-1, L/2021-2, L/2023-4, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška