Subject description - B0B36DBS
Summary of Study |
Summary of Branches |
All Subject Groups |
All Subjects |
List of Roles |
Explanatory Notes
Instructions
B0B36DBS | Database Systems | ||
---|---|---|---|
Roles: | P, PV | Extent of teaching: | 2P+2C+4D |
Department: | 13136 | Language of teaching: | CS |
Guarantors: | Řimnáč M. | Completion: | Z,ZK |
Lecturers: | Řimnáč M. | Credits: | 6 |
Tutors: | Kostov B., Nagyová I., Prokop Y., Řimnáč M. | Semester: | L |
Web page:
https://cw.fel.cvut.cz/wiki/courses/b0b36dbs/Anotation:
The course is designed as a basic database course mainly aimed at the student ability to design a relational data model and to use the SQL language for data definition as well as for data querying and to choose the appropriate degree of transaction isolation. Students will also get acquainted with the most commonly used indexing techniques, database system architecture and their management. They will verify their knowledge during the elaboration of a continuously submitted seminar task.Study targets:
Students will be learned to design a data model for a relational database, formulate queries over a relational database in SQL, choose the appropriate degree of transaction isolation and design and implement a simple database application in Java.Course outlines:
- Conceptual model - Relational model - Functional dependencies - Integrity constraints, reference integrity, normal forms - SQL (schema definition), data querying - Query optimization, indexes - Stored procedures, triggers - Object relational mapping, JPA - Modern trends in database systemsExercises outline:
1. | Motivace, seznámení s programovým vybavením, nabídka témat indiv. prací | |
2. | Datové modelování, konceptuální a logický model | |
3. | Návrh datového modelu, schválení tématu indiv. práce | |
4. | SQL I. | |
5. | SQL II. | |
6. | SQL, CRUD, Kontrolní bod 1 (datový model) | |
7. | Transakce, indexy | |
8. | Pokročilé databázové techniky (pohledy, uložené procedury, triggery) | |
9. | Přípojení k DB serveru: JDBC, JPA 2 - entity a manipulace s jimi, relace mezi entitami, JPQL | |
10. | - | 11. Implementace semestrální práce |
12. | GIS ukázka, Datový sklad ukázka | |
13. | Implementace semestrální práce | |
14. | Odevzdání aplikace, zápočet |
Literature:
Pokorný J., Valenta M.: Databázové systémy, Nakladatelství ČVUT, Praha, 2013, ISBN 978-80-01-05212-9Requirements:
math (function, projection, cartesian product) JAVAKeywords:
Konceptuální datový model, E-R diagram, logický model, referenční integrita, normální formy, dotazovací jazyk SQL, transakce, objektově-relační mapování, vysoká dostupnost Subject is included into these academic programs:Page updated 13.10.2024 07:51:20, semester: Z/2025-6, L/2023-4, Z,L/2024-5, Send comments about the content to the Administrators of the Academic Programs | Proposal and Realization: I. Halaška (K336), J. Novák (K336) |