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
- 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