Database Systems

(in Polish) brak

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 50.00 %

+ Grade for "Information technology laboratory" grade * 50.00 %

Additional requirements to pass the subject:

The final grade is the average of lecture and tutorial grades

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Lecture

Database management systems

Role and significance of database management systems

Architecture of systems using databases (client-server, query languages, etc.)

Prerelational data models (hierarchical and network) and their contemporary applications and incarnations (object and graph databases as a contemporary incarnation of network databases, windows registry, LDAP, XML databases and hierarchical file system as contemporary incarnations of hierarchical databases).

Relational data model

Atomic values, tuples, relationships, and relational variables. The concept of relational schema.

Conjunctive queries as an example of a simple query language. Domain-independent queries

Relational algebra as the foundation for the implementation of query languages.

Basic operators of relational algebra (joins, projection, selection, union, intersection, difference, Cartesian products).

Relational algebra rules and optimization of query execution

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Views and their applications

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms (third and BCNF)

Decomposition to normal forms. Heath's theorem. Dependency preserving decompositions

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Multivalued dependencies and fourth normal form

Decomposition to the fourth normal form. Fagin's theorem

Transactions in databases

ACID properties

ANSI ISO isolation levels

Starting and ending transactions in SQL

Procedural extensions of SQL

Stored procedures and functions

Triggers

Database design

Three levels of modeling: conceptual, logical and physical

ER model as a conceptual model

From ER model to database schema

Object oriented aspects of modeling

Role of indices

Information technology laboratory

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Recursive SQL queries

Commit and rollback of SQL transaction.

Defining views in SQL

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Database schema

Procedural extensions of SQL

Stored procedures and functions

Triggers

PL/SQL or PL/pgSQL

(in Polish) brak

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 50.00 %

+ Grade for "Information technology laboratory" grade * 50.00 %

Additional requirements to pass the subject:

The final grade is the average of lecture and tutorial grades

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Lecture

Database management systems

Role and significance of database management systems

Architecture of systems using databases (client-server, query languages, etc.)

Prerelational data models (hierarchical and network) and their contemporary applications and incarnations (object and graph databases as a contemporary incarnation of network databases, windows registry, LDAP, XML databases and hierarchical file system as contemporary incarnations of hierarchical databases).

Relational data model

Atomic values, tuples, relationships, and relational variables. The concept of relational schema.

Conjunctive queries as an example of a simple query language. Domain-independent queries

Relational algebra as the foundation for the implementation of query languages.

Basic operators of relational algebra (joins, projection, selection, union, intersection, difference, Cartesian products).

Relational algebra rules and optimization of query execution

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Views and their applications

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms (third and BCNF)

Decomposition to normal forms. Heath's theorem. Dependency preserving decompositions

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Multivalued dependencies and fourth normal form

Decomposition to the fourth normal form. Fagin's theorem

Transactions in databases

ACID properties

ANSI ISO isolation levels

Starting and ending transactions in SQL

Procedural extensions of SQL

Stored procedures and functions

Triggers

Database design

Three levels of modeling: conceptual, logical and physical

ER model as a conceptual model

From ER model to database schema

Object oriented aspects of modeling

Role of indices

Information technology laboratory

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Recursive SQL queries

Commit and rollback of SQL transaction.

Defining views in SQL

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Database schema

Procedural extensions of SQL

Stored procedures and functions

Triggers

PL/SQL or PL/pgSQL

(in Polish) brak

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 50.00 %

+ Grade for "Information technology laboratory" grade * 50.00 %

Additional requirements to pass the subject:

The final grade is the average of lecture and tutorial grades

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Lecture

Database management systems

Role and significance of database management systems

Architecture of systems using databases (client-server, query languages, etc.)

Prerelational data models (hierarchical and network) and their contemporary applications and incarnations (object and graph databases as a contemporary incarnation of network databases, windows registry, LDAP, XML databases and hierarchical file system as contemporary incarnations of hierarchical databases).

Relational data model

Atomic values, tuples, relationships, and relational variables. The concept of relational schema.

Conjunctive queries as an example of a simple query language. Domain-independent queries

Relational algebra as the foundation for the implementation of query languages.

Basic operators of relational algebra (joins, projection, selection, union, intersection, difference, Cartesian products).

Relational algebra rules and optimization of query execution

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Views and their applications

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms (third and BCNF)

Decomposition to normal forms. Heath's theorem. Dependency preserving decompositions

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Multivalued dependencies and fourth normal form

Decomposition to the fourth normal form. Fagin's theorem

Transactions in databases

ACID properties

ANSI ISO isolation levels

Starting and ending transactions in SQL

Procedural extensions of SQL

Stored procedures and functions

Triggers

Database design

Three levels of modeling: conceptual, logical and physical

ER model as a conceptual model

From ER model to database schema

Object oriented aspects of modeling

Role of indices

Information technology laboratory

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Recursive SQL queries

Commit and rollback of SQL transaction.

Defining views in SQL

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Database schema

Procedural extensions of SQL

Stored procedures and functions

Triggers

PL/SQL or PL/pgSQL

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 100.00 %

+ Grade for "Information technology laboratory" grade * 100.00 %

Additional requirements to pass the subject:

The final grade is the average of lecture and tutorial grades

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

Class attendance is compulsory (a prerequisite for passing)

Lecture

Database management systems

Functions and significance of database management systems

Architecture of systems using databases (client-server, query languages, etc.)

Prerelational data models (hierarchical and network) and their contemporary applications and incarnations (object and graph databases as a contemporary incarnation of network databases, windows registry, LDAP, XML databases and hierarchical file system as contemporary incarnations of hierarchical databases).

Relational data model

Atomic values, tuples, relationships, and relational variables. The concept of relationship schema.

Conjunctive queries as an example of a simple query language. Domain-independent queries

Relational algebra as the foundation for the implementation of query languages.

Basic operators of relational algebra (joins, projection, selection, union, intersection, difference, Cartesian products).

Relational algebra rules and optimization of query execution

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Views and their applications

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms (third and BCNF)

Decomposition to normal forms. Heath's theorem. Dependency preserving decompositions

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Multivalued dependencies and fourth normal form

Decomposition to the fourth normal form. Fagin's theorem

Transactions in databases

ACID properties

ANSI ISO isolation levels

Starting and ending transactions in SQL

Procedural extensions of SQL

Stored procedures and functions

Triggers

Database design

Three levels of modeling: conceptual, logical and physical

Model ER as conceptual model

From ER model to database schema

Object oriented aspects of modeling

Role of indices

Information technology laboratory

Language SQL

Defining and modifying relational variables (CREATE TABLE, DROP TABLE, opt. ALTER TABLE)

Modifying data (UPDATE, DELETE, INSERT)

SELECT queries, including aggregate queries, subqueries, quantifiers, joins, set-based operators.

Subqueries in DML commands

Recursive SQL queries

Commit and rollback of SQL transaction.

Defining views in SQL

Constraints and normal forms

Functional dependencies for relations and relational variables and their basic properties (Armstrong axioms)

Superkeys, candidate keys, primary keys.

Update anomalies

Normal forms

Declaration of constraints in SQL (Domains, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, referential constraints).

Database schema

Procedural extensions of SQL

Stored procedures and functions

Triggers

PL/SQL or Pg/PLSQL

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 100.00 %

+ Grade for "Information technology laboratory" grade * 100.00 %

Additional requirements to pass the subject:

None

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

None

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

None

(in Polish) Wykład 1

Systemy zarządzania bazami danych

Funkcje i znaczenie systemów zarządzania bazami danych.

Architektura systemów korzystających z baz danych (klient-serwer, języki zapytań itp.)

Przedrelacyjne modele danych (hierarchiczny i sieciowy) i ich współczesne zastosowania i inkarnacje (bazy obiektowe i grafowe jako współczesna inkarnacja baz sieciowych, rejestr windows, LDAP, bazy XML i hierarchiczny system plików jako współczesne inkarnacje baz hierarchicznych).

Relacyjny model danych

Wartości atomowe, krotki, relacje i zmienne relacyjne. Pojęcie schematu relacji.

Rachunek relacyjny (krotkowy i domenowy). Zapytania niezależne od dziedziny.

Algebra relacyjna jako podstawa implementacji języków zapytań.

Podstawowe operatory algebry relacyjnej (złączenia, projekcja, selekcja, unia, przecięcie, różnica, iloczyny kartezjańskie).

Reguły algebry relacyjnej a optymalizacja wykonywania zapytań

Język SQL

Definiowanie i modyfikacja zmiennych relacyjnych (CREATE TABLE, DROP TABLE, opcj. ALTER TABLE)

Modyfikacje danych (UPDATE, DELETE, INSERT)

Zapytania SELECT, w tym zapytania agregujące, podzapytania, kwantyfikatory, złączenia, operatory teoriomnogościowe.

Podzapytania w operacjach DML

Widoki i ich zastosowania

Więzy i postacie normalne

Zależności funkcyjne dla relacji i zmiennych relacyjnych i ich podstawowe własności (aksjomaty Armstronga)

Nadklucze, klucze kandydujące, klucze główne.

Anomalie modyfikacji

Postacie normalne (trzecia i BCNF).

Dekompozycja do postaci normalnych. Twierdzenie Heatha. Dekompozycje zachowujące zależności

Deklarowanie więzów w SQL (Domeny, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, więzy referencyjne).

Zależności wielowartościowe i czwarta postać normalna.

Dekompozycja do czwartej postaci normalnej,. Twierdzenie Fagina

Transakcje w bazach danych

Własności ACID

Poziomy izolacji ANSI ISO

Rozpoczynanie i kończenie transakcji w SQL

Proceduralne rozszerzenia SQL

Procedury i funkcje składowane

Triggery

Projektowanie baz danych

Trzy poziomy modelowania: koncepcyjny, logiczny i fizyczny

Model ER jako model koncepcyjny.

Od modelu ER do schematu relacyjnego.

Aspekty obiektowe modelowania.

Rola indeksów

Laboratorium informatyczne lub pracownia fizyczna 2

Język SQL

Definiowanie i modyfikacja zmiennych relacyjnych (CREATE TABLE, DROP TABLE, opcj. ALTER TABLE)

Modyfikacje danych (UPDATE, DELETE, INSERT)

Zapytania SELECT, w tym zapytania agregujące, podzapytania, kwantyfikatory, złączenia, operatory teoriomnogościowe.

Podzapytania w operacjach DML

Rekurencyjne zapytania SQL

Zatwierdzanie i wycofywanie transakcji w SQL

Definiowanie widoków w SQL

Więzy i postacie normalne

Zależności funkcyjne dla relacji i zmiennych relacyjnych i ich podstawowe własności (aksjomaty Armstronga)

Nadklucze, klucze kandydujące, klucze główne.

Anomalie modyfikacji

Postacie normalne.

Deklarowanie więzów w SQL (Domeny, CHECK, NOT NULL, UNIQUE, PRIMARY KEY, więzy referencyjne).

Schemat bazy danych

Proceduralne rozszerzenia SQL

Procedury i funkcje składowane

Triggery

PL/SQL lub Pg/PLSQL

Lecture

Expository method | Information lecture

Expository method | Problem lecture

Expository method | Information lecture

Expository method | Problem lecture

Information technology laboratory

Search methods | Practice method

Search methods | Problem method

FINAL GRADE FOR THE SUBJECT

is determined according to the algorithm:

Grade for "Lecture" grade * 100.00 %

+ Grade for "Information technology laboratory" grade * 100.00 %

Additional requirements to pass the subject:

None

Grade for "Lecture" is determined on the basis of results of the following components of passing requirements:

Test/quiz - 100.00%

Grade for "Lecture" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

None

Grade for "Information technology laboratory" is determined on the basis of results of the following components of passing requirements:

Assignment / practical tasks - 100.00%

Grade for "Information technology laboratory" is determined according to the following point scale:

Below 50.00% - grade 2

50.00% and more - grade 3

60.00% and more - grade 3,5

70.00% and more - grade 4

80.00% and more - grade 4,5

90.00% and more - grade 5

Additional requirements to pass the form:

None

1) Hierarchical, network and relational data models.

2) Mathematical foundations of relational data model.

3) Relational calculus and relational algebra

4) Physical, logical and conceptual modeling.

5) Design of relational databases. Entity–relationship model.

6) Introduction to SQL: SELECT queries, UPDATE, DELETE and INSERT commands, creation and deletion of tables, etc.

7) Introduction to transactions and ACID properties.

8) Indices.

9) Views

10) Triggers, stored subroutines, procedural extensions to SQL.

11) Basic database server administration (PostgreSQL).

12) Structure of database applications. Connecting to database.

13) Elements of postrelational and hybrid databases..