SylabUZ
Nazwa przedmiotu | Engineering Databases Design |
Kod przedmiotu | 06.9-WM-MaPE-P-EngDaDes-23 |
Wydział | Wydział Mechaniczny |
Kierunek | Management and Production Engineering |
Profil | ogólnoakademicki |
Rodzaj studiów | pierwszego stopnia z tyt. inżyniera |
Semestr rozpoczęcia | semestr zimowy 2023/2024 |
Semestr | 4 |
Liczba punktów ECTS do zdobycia | 4 |
Typ przedmiotu | obowiązkowy |
Język nauczania | angielski |
Sylabus opracował |
|
Forma zajęć | Liczba godzin w semestrze (stacjonarne) | Liczba godzin w tygodniu (stacjonarne) | Liczba godzin w semestrze (niestacjonarne) | Liczba godzin w tygodniu (niestacjonarne) | Forma zaliczenia |
Wykład | 15 | 1 | - | - | Zaliczenie na ocenę |
Laboratorium | 30 | 2 | - | - | Zaliczenie na ocenę |
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.
Passing course Information Technologies.
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.
Lecture: a conventional lecture
Laboratory: practical classes in the computer laboratory
Opis efektu | Symbole efektów | Metody weryfikacji | Forma zajęć |
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.
Zmodyfikowane przez dr inż. Tomasz Belica (ostatnia modyfikacja: 08-05-2023 10:10)