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.
BIK-DBS.21 Database Systems Extent of teaching: 14KP+6KC Instructor: Borkovcová M., Valenta M. Completion: Z,ZK Department: 18102 Credits: 5 Semester: L Annotation:
Students get acquainted with the architecture of the database engine and typical user roles. They learn to design the structure of a smaller data store (including integrity constraints) using a conceptual model and then implement them in a relational database engine. They get acquainted with the SQL language and also with its theoretical basis - relational database model. They will get acquainted with the principles of relational database schema normalization. They understand the basic concepts of transaction processing and control of parallel user access to a single data source. At the end of the course, students will be introduced to alternative nonrelational database models.
Lecture syllabus:
1. Basic principles of database systems, database engine architecture. 2. Conceptual, database and physical level of data view. 3. Conceptual data model. Basic constructs, expression of integrity constraints. 4. Relational data model. Relations, attributes, domains, relational database schema, relational algebra. 5. Introduction to the SQL language: the basics of the SELECT statement, the basics of the SQL DDL language. 6. Design of a relational schema by direct transformation from a conceptual schema. 7. SQL language - advanced querying: aggregation, nested queries, set operations. 8. SQL language - parts of DCL, DML, TCL. 9. Transactions, error recovery, parallel access coordination, data protection. 10. Functional dependencies, normal forms of relations, normalization of the relational scheme by decomposition. 11. Physical level of data view. Indexes and their use in relational databases. Basics of optimizing SQL queries. 12. Non-relational database models. Database trends. 13. Application access to the (relational) database. Introduction to the concept of software engineering. Seminar syllabus:
1. Proseminar: Organizational instructions, assignment of a semester assignment 2. Computer: Getting to know the environment and tools 3. Proseminar: Conceptual data modeling 4. Computer: SQL communication with the DB engine and work with a tool for conceptual modeling 5. Proseminar: Conceptual data modeling, relational algebra as a query language 6. Consulting, computer: Work on a semester assignment, consultation 7. Proseminar: Relational algebra as a query language 8. Computer: Work on a semester assignment, consultations 9. Seminar: SQL language 10. Computer: Work on a semester assignment, consultations, checkpoint of semester work 11. Seminar: SQL language, 12. Computer: Work on a semester assignment 13. Seminar: Schema normalization, functional dependencies, credits 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:
Knowledge of working with operating systems such as Unix/Linux and MS Windows at a common user level is assumed, as well as the ability to algorithmically describe problem solving, and basic knowledge of algebra and logic. Active knowledge of a programming language is not a requirement. Materials for teaching the subject during the semester are available on the website https://courses.fit.cvut.cz/BI-DBS. The operational management of teaching takes place on the portal https://dbs.fit.cvut.cz
Informace o předmětu a výukové materiály naleznete na https://courses.fit.cvut.cz/BI-DBS/ The course is also part of the following Study plans:
Study Plan Study Branch/Specialization Role Recommended semester BIK-IB.21 Information Security 2021 (in Czech) PP 2 BIK-SPOL.21 Unspecified Branch/Specialisation of Study PP 2 BIK-PV.21 Computer Systems and Virtualization 2021 (in Czech) PP 2 BIK-PS.21 Computer Networks and Internet 2021 (in Czech) PP 2 BIK-SI.21 Software Engineering 2021 (in Czech) PP 2
Page updated 18. 4. 2024, semester: L/2020-1, L/2023-4, L/2019-20, Z/2021-2, L/2022-3, Z/2023-4, Z/2019-20, Z/2022-3, L/2021-2, Z/2024-5, Z/2020-1, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška