This subject introduces students to basic database modelling, design, and implementation concepts and techniques. Entity-Relationship (E-R) modelling methodology is described in detail and students learn how to model information requirements and develop conceptual models from user specifications. Relational database theory is presented, including the description of the relational model and theory of Normal Forms. Transformations techniques between the E-R and relational models are described. Database programming using SQL is introduced in lectures and supported by practical exercises using a relational DBMS. Access control and transaction management are also studied.
Autumn semester, City campus
Spring semester, City campus
Summer session, City campus