Database Design. Introduction to SQL
This course introduces the classical methodology of database design, covering the entire process from requirements analysis and conceptual modeling to logical and physical implementation in a relational database management system. Entity-relationship modeling and normalization techniques are used to design well-structured relational schemas. Relational algebra is presented as the theoretical foundation of query processing, followed by the Structured Query Language (SQL) for data definition and data manipulation. Students implement a database project using the PostgreSQL RDBMS.