SylabUZ
| Course name | Engineering Databases Design |
| Course ID | 06.9-WM-MaPE-P-EngDaDes-23 |
| Faculty | Faculty of Engineering and Technical Sciences |
| Field of study | Management and Production Engineering |
| Education profile | academic |
| Level of studies | First-cycle studies leading to Engineer's degree |
| Beginning semester | winter term 2023/2024 |
| Semester | 4 |
| ECTS credits to win | 4 |
| Course type | obligatory |
| Teaching language | english |
| Author of syllabus |
|
| The class form | Hours per semester (full-time) | Hours per week (full-time) | Hours per semester (part-time) | Hours per week (part-time) | Form of assignment |
| Lecture | 15 | 1 | - | - | Credit with grade |
| Laboratory | 30 | 2 | - | - | Credit with grade |
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
| Outcome description | Outcome symbols | Methods of verification | The class form |
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.
Modified by dr inż. Tomasz Belica (last modification: 08-05-2023 10:10)
