1. SylabUZ
2. Wydział Nauk Inżynieryjno-Technicznych
3. semestr zimowy 2023/2024
4. Management and Production Engineering - pierwszego stopnia z tyt. inżyniera
5. Engineering Databases Design

Wygeneruj PDF dla tej strony

Engineering Databases Design - opis przedmiotu

Cel przedmiotu

The aim of the course is to provide information on the design and implementation of an IT system, developing the ability to use the SQL language to process a set of data in order to obtain the desired information.

Wymagania wstępne

Zapisz zmiany

Passing course Information Technologies.

Zakres tematyczny

Lecture

W01. Creating an IT project, data modelling, introduction to the relational data model, architecture of database systems.

W02. Relational algebra, introduction to the SQL language, basic syntax of the SELECT command.

W03. Internal and external joins

W04. Calculations and data aggregation

W05. Views and subqueries, vector operators. Defining structures and manipulating data in SQL.

W06. Relational data model: functional dependencies, first, second and third normal form of the relationship, analysis of a sample project.

W07. Final test.

Laboratory

L01. Introduction to phpMyAdmin.

L02-03. Creating tables using the phpMyAdmin interface: data types, data control, establishing relationships between tables, integrity constraints.

L04-05. Basics of the SQL language, execution of queries operating on a single table.

L06-07. Using an inner join operation to merge data stored in several tables.

L08. Outer join.

L09. Performing calculations on data available in the database, using SQL functions.

L10. Using data aggregation to perform calculations involving data stored in many table tuples.

L11. Defining and using views.

L12. Independent subqueries.

L13-14. Summary and repetition of the learned elements of the SQL language.

L15. Defining structures and manipulating data.

Metody kształcenia

Lecture: a conventional lecture

Laboratory: practical classes in the computer laboratory

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

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

Warunki zaliczenia

Lecture: a positive result of the assessment via a written test

Laboratory: the average of grades obtained from written tests and lab reports.

Final grade: the condition for passing the course is to pass all its forms, the final grade for the course is the arithmetic mean of the grades for individual forms of classes.

Literatura podstawowa

1. Batra R., SQL Primer : An Accelerated Introduction to SQL Basics, New York: Apress, 2018
2. Garcia-Molina H., Ullman J., Widom J., Database Systems: The Complete Book , Pearson, 2008
3. Harkins S. S., Reid M., SQL : Access to SQL Server, Berkeley, CA: Apress, 2008
4. Harrington J. L., SQL Clearly Explained, Amsterdam: Morgan Kaufmann, 2003
5. Russo J., SQL by Example, New York: Momentum Press, 2018
    

Literatura uzupełniająca

1. Kenler E., Razzoli F., MariaDB Essentials, Birmingham, UK: Packt Publishing, 2015
2. Foster E. C., Godbole S., Database Systems : A Pragmatic Approach, Apress, 2016
3. Zygiaris S., Database Management Systems : A Business-Oriented Approach Using ORACLE, MySQL and MS Access, Bingley, UK: Emerald Publishing Limited, 2018

Uwagi

Zmodyfikowane przez dr inż. Tomasz Belica (ostatnia modyfikacja: 08-05-2023 10:10)