The aim of studying and bibliography

The main aim of study: The main aim of the module's education is the presentation of selected issues in the field of database bases and modern database systems that have practical applications in their design, use and management.

The general information about the module: Presentation of the theoretical basis of databases and the use of software from leading suppliers for designing and creating databases.

Teaching materials: http://v.prz.edu.pl/pawel.dymora

Bibliography required to complete the module

Bibliography used during lectures

1	M. McLaughlin	Oracle Database 12c. Programowanie w języku PL/SQL	Helion.	2015
2	A. Silberschatz, H. F. Korth, S. Sudarshan	Database System Concepts	McGraw-Hill Higher Education.	2011
3	Bob Bryla, Kevin Loney	Oracle Database 11g, Podręcznik administratora baz danych	Helion.	2010
4	H. Garcia-Molina, J.D. Ullman, J. Widom	Systemy baz danych	WNT .	2006
5	T Cannolly, C. Begg	Systemy baz danych	Read Me.	2004
6	L Banachowski	Relacyjne Bazy danych – wykł. i ćwiczenia	PJWSTK.	1998

Basic requirements in category knowledge/skills/social competences

Formal requirements: Completed an introduction course to computer science and mathematical logic. The student satisfies the formal requirements set out in the study regulations.

Basic requirements in category knowledge: The student should know the basic issues in the field of set theory, set algebra, ICT and computer skills.

Basic requirements in category skills: He can manage computer and applications both in Windows and Linux.

Basic requirements in category social competences: Group work, communication skills.

Module outcomes

MEK	The student who completed the module	Types of classes / teaching methods leading to achieving a given outcome of teaching	Methods of verifying every mentioned outcome of teaching	Relationships with KEK	Relationships with PRK
01	He knows the concept and basic concepts related to the relational database model and uses these principles to model and design databases.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06+++ K_W07++ K_U05++ K_U06++ K_U15+ K_U18+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
02	Has knowledge of the SQL query language standard and the principles of building the DBMS.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06++ K_W07++ K_U05+ K_U06++ K_U15+ K_U18+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
03	He is able to use the SQL query language in a practical way for an existing database and to create and design basic database objects and structures.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06++ K_W07+++ K_U05+ K_U06+++ K_U15+++ K_U18+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
04	He knows other database models, including multimedia and NoSQL.	lecture, laboratory, project	pass, observation of performance	K_W05+ K_W06+++ K_W07+++ K_U05+ K_U06+++ K_U15++ K_U18+ K_U23+ K_K01+ K_K03+	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
05	Uses the acquired knowledge in typical and unusual situations.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06++ K_W07+ K_U05+ K_U06+ K_U15++ K_U18+++ K_U23+ K_K01++ K_K03++	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG
06	Independence in the use and design of databases as well as an active way of acquiring knowledge and responsibility for the task entrusted.	lecture, laboratory, project	pass, observation of performance	K_W05++ K_W06+ K_W07+ K_U05+ K_U06+ K_U15+ K_U18+++ K_U23+ K_K01+++ K_K03+++	P6S_KK P6S_KO P6S_KR P6S_UK P6S_UW P6S_WG

Attention: Depending on the epidemic situation, verification of the achieved learning outcomes specified in the study program, in particular credits and examinations at the end of specific classes, can be implemented remotely (real-time meetings).

The syllabus of the module

Sem.	TK	The content	realized in	MEK
3	TK01	Organizational classes. Determining the form of credit and the scope of the material. Familiarizing with the work regulations in the laboratory.	W01, L01
3	TK02	Basics of the relational data model, operations performed on relations.	W01, W02, L01, L02	MEK01
3	TK03	Normalization of logical database diagrams.	W03, L03, P1	MEK01 MEK03
3	TK04	Principles of database modeling, ER transformation to a relational model	W04, L04, P2	MEK01 MEK03
3	TK05	SQL language - a standard language of communication with relational databases.	W05, W6, L05, L06, P3	MEK02 MEK03 MEK05
3	TK06	Creating and indexing databases, creating constraints, inserting data.	W07, W8, L07, L8, P4	MEK01 MEK03 MEK05 MEK06
3	TK07	Transactions in databases, concurrent transaction management and transactional disaster recovery.	W09, W10, L09, L10	MEK01 MEK03 MEK04
3	TK08	Multimedia databases.	W11, L11, P5	MEK01 MEK04 MEK05 MEK06
3	TK09	Distributed databases and problems related to data dispersal.	W12, L12	MEK01 MEK04 MEK05 MEK06
3	TK10	Introduction to the object-relational and object-oriented data model.	W13, W14, L13, L14 , P5	MEK01 MEK04 MEK05 MEK06
3	TK11	NoSQL databases	W14, W15, L14, L15	MEK01 MEK04 MEK05 MEK06

The student's effort

The type of classes	The work before classes	The participation in classes	The work after classes
Lecture (sem. 3)	The preparation for a test: 55.00 hours/sem.	contact hours: 30.00 hours/sem.
Laboratory (sem. 3)		contact hours: 30.00 hours/sem.
Project/Seminar (sem. 3)		contact hours: 10.00 hours/sem..
Advice (sem. 3)		The participation in Advice: 2.00 hours/sem.
Exam (sem. 3)	The preparation for an Exam: 10.00 hours/sem.	The written exam: 2.00 hours/sem.

The way of giving the component module grades and the final grade

The type of classes	The way of giving the final grade
Lecture	Oral exam.
Laboratory	Presence is obligatory in all laboratory classes - medical exemptions are allowed with the need to make up for classes.
Project/Seminar	The aim of the project classes will be an independent (also permissible team) implementation of an IT project, the effect of which is to be documented, a database based on a selected database system.
The final grade	The final grade is issued as the weighted average of 1/3 of the laboratory grade, 1/3 of the project grade and 1/3 of the lecture grade.

Sample problems

Required during the exam/when receiving the credit
(-)

Realized during classes/laboratories/projects
(-)

Others
(-)

Can a student use any teaching aids during the exam/when receiving the credit : no

The contents of the module are associated with the research profile: no