Due to COVID-19 we moved entirely online.

Class Schedules

Office Hours / Consultations

  • Chat preffered for brief questions
  • Online or office contact hours in this period are published at the end of the week, for next week appointments. If nothing is published yet, do contact me to make an appointment.

Recommended Links

Databases

My teaching philosophy:

  • Learn by Doing
    All courses I teach are project based - students work individually or in small groups towards a successful project implementation
  • 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 since 2020
    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

This is just a short decription of the course and my general teaching philosophy. For more details regularly check the information at the web-site: bazi.finki.ukim.mk where you can also find samples of past students projects.

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