Databases@FCSE

Databases@FCSE News

World News

Student DB Projects

Databases 2018-2019 Winter term by VVA

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)

Student projects

  • TBA