The subject is taught in Polish

Lecture

Databases are a subject in first-cycle computer science studies. This course provides a foundational understanding of database design and implementation. The knowledge gained in this course provides the foundation for implementing persistent data storage applications (which is the majority of modern applications).
The scope of the issues covered includes, among others:

  • architecture of database systems,
  • database design,
  • relational database model (currently the most common),
  • SQL language (according to the standards of this language),
  • aspects of relational databases normalization
  • transaction mechanisms and support for concurrent data access,
  • data security issues.

The course consists of: 2 hours of lecture per week throughout the semester, 2 hours of project per week until mid-semester, and 2 hours of laboratory from mid-semester onwards.

Project

As part of the project, students undertake a task involving designing a database for a selected topic area. Database design is associated with analytical skills. The first step is to analyze what the client would expect from such a database, what information they want to store, and what they will search for in the database. The next step is to consider how this information will be stored. The entity-relationship model is used to model the database structure. It consists of an entity-relationship diagram (ERD) and a diagram description. Only the third step is to precisely depict the database structure, which can be achieved using a precise notation of a relational database schema.

Laboratorium

In the lab, students implement a database they have previously designed. The lab is primarily designed to teach the basics of SQL (creating tables, attributes, defining primary keys, foreign keys, and constraints, populating and modifying the database, and creating queries). The lab is conducted using a single database management system (DBMS), but the basics of SQL are universal, allowing students to apply the knowledge they have acquired to other DBMSs. The lab also includes hands-on practice in planning and implementing transactions within an application.

More information on the portal eNauczanie.pg.edu.pl