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.
About the Course
Team
Lyudmila Kozina
Lyudmila Kozina is an Assistant Professor in the Department of Computer Engineering at the International University of Information Technologies with over 14 years of teaching experience. She is a PhD candidate, an author of scientific publications, and an active researcher involved in a funded grant project. She has successfully supervised more than 40 student projects, guiding students from initial concept to final defense. In 2023, she was awarded the Certificate of Honor by the Ministry of Science and Higher Education of the Republic of Kazakhstan.