The course studies the design of a database starting from the initial stage to the physical implementation with a relational database management system. The entity-relationship model and normalization are used in problems. Relational algebra and then the SQL (Structured Query Language) are presented. Course studies the design of a database with using a relational database management system. Students implement an individual database on PostgreSQL RDBMS.

Students successfully completing the course will be able to: describe the process of database design, identify and describe the stages of database design and related issues, analyze and estimate the normalization and results of database design; demonstrate the database design starting from the analysis and the conceptual stage with ER diagram to the physical implementation using DBMS; demonstrate skills with Structured Query Language (DDL, DML); use DBMS (PostgreSQL) as an environment to implement problems using Structured Query Language; discuss issues related to the Database Management Systems and database design.