Back to the List of courses
General Information
Main lecturer: Vangel V. Ajanovski, PhD, Assistant Professor
Learning management system: http://courses.finki.ukim.mk
Exam site: /exams (access restricted to FCSE students only)
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 (group project or in special cases individual project)
- 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
Exam
- Written part of the exam - consists of assignments (modelling, answering, solving - on a computer), where conceptual knowledge and application of knowledge to simulated real life or model situations is tested
- Practical part of the exam - consists of assignments where application of knowledge at implementation level is tested in a database system (creating a database and issuing queries to find data)