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 2021

• 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
• Online-held in 2021/2022
  Lectures and exams will be held online using videoconferencing systems, and practical work will be condone using a special software system that I developed for this course, that enables hands-on practice assignments and exams

Lecture topics

1. Introduction
2. Entity-Relationship Modeling
3. ER notations comparioson
4. Relational model
5. Translation of ER model to relational model
6. SQL
7. UML Diagrams
8. Relational algebra
9. Relational algebra with NULL values
10. Relational Calculus
11. Database integrity
12. Application Development
13. Functional Dependencies
14. Normalization and Normal Forms

Project work

Project Phases

1. ER Modeling
2. Translation of ER model to relational database schema
3. SQL DDL
4. SQL DML
5. DB Application Development - Building a prototype application using the database schema developed during Labs.
6. Functional Dependencies and Normalization
7. Advanced DB Application Development - Transactions, Services and Background jobs

Student projects

• TBA