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
  • Fully online since 2020
    Lectures and exams are held online using videoconferencing systems, and practical work is realized using special software systems (dbLearn* and EPRMS) that I developed, which enable hands-on practice assignments and exams and iterative development and grading

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

Class Schedules

  • Databases - Lectures
    Thu 16-18 - @MF225
  • CompSnd - TBA
  • DBA - TBA

Office Hours / Consultations

  • None scheduled at this moment. Contact hours for each next week are published at the end of the current week. Please check again or contact me to make an appointment.
  • Chat preffered for brief questions

Recommended Links