Back to the List of courses
General Information
Main lecturer: Vangel V. Ajanovski, PhD, Associate Professor
Related sites and tools:
- Learning management system: https://courses.finki.ukim.mk
- dbLearn* practice and exam system: https://bazi.finki.ukim.mk/dbLearnStar
- EPRMS - Educational Project and Resource Management System: https://develop.finki.ukim.mk/eprms
- DEVELOP - Student Project Status and Documentation Trackings - https://develop.finki.ukim.mk/projects
Course Contents
This course is on-going and the information will be updated according to the progress.
I use the following premises when teaching Databases in 2023/24
- Learn by Doing
All courses I teach are project based and personalized - students build projects individually or in small groups - Guided and Personalized
I personally supervise the project work week by week, and offer menthorship and guidance through individualized comments and critique towards advancement
Lecture topics
- Introduction
- Entity-Relationship Modeling
- ER notations comparioson
- Relational model
- Translation of ER model to relational model
- SQL
- UML Diagrams
- Relational algebra
- Relational algebra with NULL values
- Relational Calculus
- Database integrity
- Application Development
- Functional Dependencies
- Normalization and Normal Forms
Project work
Project Phases
- ER Modeling
- Translation of ER model to relational database schema
- SQL DDL
- SQL DML
- DB Application Development - Building a prototype application using the database schema developed during Labs.
- Functional Dependencies and Normalization
- Advanced DB Application Development - Transactions, Services and Background jobs