Table of Contents

BIE-DBS - Database Systems

This is a temporary website for the course. Pages will move to edux portal if the portal is prepared.

Course organization

Schedule:

Requirements to Pass

Semestral Project

Exam

Final Mark

Points IntervalGradeEvaluation in Words
>= 90 A Excellent
80-89 B Very Good
70-79 C Good
60-69 D Satisfactory
50-59 E Sufficient
< 49 F Failed

Study Materials

Lectures are based on book and slides Database Management Systems written by R. Ramakrishanan and J. Gerkhe

  1. lecture (3 of October)relational databases
  2. lecture (3 of October, 10 of October) relational algebra
  3. lecture (10 of October) er-introduction
  4. lecture (17 of October) er-model (presentation is the same)
  5. lecture (24 of October) SQL SQL - part I
  6. lecture (31 of October) SQL (see previous presentation)
  7. lecture (7 of November) SQL part II
  8. lecture (14 of November) We discussed conceptual models in your project
  9. lecture (21 of November) database normalization
  10. lecture (28 of November) Nomrmalization - another example + Transactional processing

Seminars

Materials are here

Semestral Project

The aim of semestral project is design and implementation of relational database. The semetral project consist of 3 parts:

A sample of semestral work is here.

Tools

You need a tool for conceptual modeling and a client for RDBMS. Recommended tools are:

It is allowed to use another (your favorite) modeler and/or RDBMS and its client.