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:	Too many persons	Semester:	L

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 systems

Exercises 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-9

Requirements:

math (function, projection, cartesian product) JAVA

Webpage:

http://www.ksi.mff.cuni.cz/~svoboda/courses/202-B0B36DBS

Keywords:

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:

Program	Branch	Role	Recommended semester
BPSIT	Common courses	P	2
BPOI1_2016	Computer and Information Science	P	4
BPOI_BO_2016	Common courses	P	4
BPOI4_2016	Computer Games and Graphics	P	4
BPOI3_2016	Software	P	4
BPOI2_2016	Internet things	P	4
BPBIO_2018	Common courses	PV	5
BPOI_BO_2018	Common courses	P	4
BPOI4_2018	Computer Games and Graphics	P	4
BPOI3_2018	Software	P	4
BPOI2_2018	Internet things	P	4
BPOI1_2018	Artificial Intelligence and Computer Science	P	4
BPSIT_2021	Common courses	P	2
BPSIT4_2021	Technologie internetu věcí	P	2
BPSIT3_2021	Business informatics	P	2
BPSIT2_2021	Technologie pro multimédia a virtuální realitu	P	2
BPSIT1_2021	Enterprise systémy	P	2

---

Page updated 8.8.2022 15:50:34, semester: Z,L/2022-3, Z/2024-5, L/2021-2, Send comments about the content to the Administrators of the Academic Programs

Proposal and Realization: I. Halaška (K336), J. Novák (K336)