Back to the List of courses
General Information
Main lecturer: Vangel V. Ajanovski, PhD, Assistant Professor
Learning management system: http://courses.finki.ukim.mk
Course Contents
Lectures
- 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
- Labs
- ER Modeling
- Translation of ER model to relational database schema
- SQL DDL
- SQL DML
- Analytical queries, views and reporting
- Functional Dependencies and Normalization
- Application Development
- Building a prototype application using the database schema developed during Labs
Student projects
To be published...