SylabUZ

Generate PDF for this page

Engineering Databases Design - course description

General information
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
Course information
Semester 4
ECTS credits to win 4
Course type obligatory
Teaching language english
Author of syllabus
  • dr inż. Grzegorz Pająk
  • dr inż. Iwona Pająk
Classes forms
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

Aim of the course

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.

Prerequisites

Passing course Information Technologies.

Scope

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.

Teaching methods

Lecture: a conventional lecture

Laboratory: practical classes in the computer laboratory

Learning outcomes and methods of theirs verification

Outcome description Outcome symbols Methods of verification The class form

Assignment conditions

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.

Recommended reading

  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
     

Further reading

  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

Notes


Modified by dr inż. Tomasz Belica (last modification: 08-05-2023 10:10)