1. SylabUZ
2. Wydział Matematyki, Informatyki i Ekonometrii
3. semestr zimowy 2022/2023
4. Mathematics - pierwszego stopnia z tyt. licencjata
5. Database Systems 1

Wygeneruj PDF dla tej strony

Database Systems 1 - opis przedmiotu

Cel przedmiotu

The course introduces basic notions, definitions and problems related to the relational models of databases. The student acquires knowledge and skills in the design and use of databases. Getting to know the applications of the SQL language.

Wymagania wstępne

Zapisz zmiany

Fundamentals of logic. Programming skills.

Zakres tematyczny

Lecture:

1. The basic notions and definitions of the relational data model.
2. Operations on relations (union, difference, intersection, complement, projection, selection, join, division).
3. The functional dependencies and Armstrong’s axioms.
4. Relational schemas.
5. Decomposition of relational schemas (without data loss, without loss of functional dependencies and into independent components).
6. Normalization through decomposition (First Normal Form, Second Normal Form, Third Normal Form, Boyce–Codd Normal Form, Forth Normal Form).
7. Multivalued dependencies.
8. The set of axioms for multivalued dependencies.
9. Optimalization of the sets of functional dependencies.

Class:

1. Operations on relation
2. Normalization through decomposition (2NF, 3NF, B-CNF).
3. Structured Query Language (Data Manipulation Language, Data Definition Language, Data Control Language).
4. Creating the project of a database (Data-Flow Diagram, Entity-Relationship Diagrams, generating database scheme).

Laboratory:

1. The use of SQL.
2. Data types, expressions and operators, conditions, functions, procedures.
3. SELECT statement (inner join, outer join, simple subqueries, correlated subqueries, grouping and aggregate functions, set operators).
4. Defining the database structure (domains, tables, views, indexes, sequences/generators, triggers, referential integrity constraints).
5. Database users management and control of transactions.
6. Using computer CASE tools to generate a simple database schema.
7. Getting to know the possibilities offered by database components.

Metody kształcenia

Lecture: Seminar lecture.

Classes: Problem method, brainstorming.

Laboratory: Laboratory exercises in the computer lab.

Efekty uczenia się i metody weryfikacji osiągania efektów uczenia się

Opis efektu	Symbole efektów	Metody weryfikacji	Forma zajęć

Warunki zaliczenia

Lecture: an exam consisting of two parts: written and oral, the condition for the oral part is to obtain at least 30% of points in the written part, obtaining 50% of points in the written part guarantees a positive grade, without the need to take the oral part. The condition for taking the exam is obtaining positive grades from classes.

Laboratory: the grade consists of points from four tests writen in the semester or from points from a test covering the entire material (80% of the grade) and students' activity during laboratory classes (20% of the grade).

Exercise classes: the grade consists of points from four tests written in the semester or points from the test covering the entire material (which constitutes 80% of the grade) and students' activity during classes (20% of the grade).

The final grade for the course is the arithmetic mean of grades from the lecture, exercise classes and laboratory. The necessary condition for obtaining a positive final grade is obtaining positive grades from the lecture, exercise classes and the laboratory.

Literatura podstawowa

1. D. Maier, The Theory of Relational Databases, Computer Science Press, 1983.
2. C.J. Date: An Introduction to Database Systems, Addison-Wesley Longman, 2000.
3. C.J. Date, H. Darwen: A Guide to SQL Standard, 4th Edition, Addison-Wesley Professional, 1996.
4. C.J. Date: SQL and Relational Theory. How to Write Accurate SQL Code, O’Reilly, 2009.
5. R. Colburn: Special Edition Using SQL, Que, 2000.
6. J.D. Ullman, J. Widom: A First Course in Database Systems, 3rd Edition, Pearson, 2007.
7. D. Russell J.T., Learning MySQL and MariaDB, O'Reilly Media, 2015.
8. https://www.w3schools.com/
9. www.tutorialspoint.com

Literatura uzupełniająca

1. R. Barker, Case*Method: Entity Relationship Modelling, First Edition, Addison-Wesley, 1990.
2. P. Dubois, MySQL (Developer's Library), 5th Edition, Addison-Wesley Professional, 2013.
3. L. Welling, L. Thomson, MySQL Tutorial, Sams Publishing, 2003.

Uwagi

The subject is also offered in the 4h semester.

Zmodyfikowane przez dr Anna Fiedorowicz (ostatnia modyfikacja: 18-01-2024 14:27)