BIE-DBS - Database Systems

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

• Teacher: Michal Valenta Michal.Valenta@fit.cvut.cz
• Teachers's office: Room T7:A-927 Building A (Thákurova 7), the “old” blue building connected with the new CTU building through a glass corridor, take a lift to 9th floor

• Lectures: Monday 14:30 - 16:00, room T7:A-1030 (building A, see above)
• Seminars: Friday 11:00 - 12:30, room T7:A-1031 (building A, see above)
  • your laptops/notebooks are welcome especially if you want to consult semestral project

• project is mandatory
• you receive up to 40 points

• is mandatory
• it is a test including practical exercises
• your receive up to 60 points
• there may be additional discussion part (test is the basis for discussion)
• Sample of exam test.

• your points from semestral project and exam are summed together
• final mark is done by the table:

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

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

Materials are here

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

• specification - you have to choose arbitrary topic (domain) - for example: library, hospital, car renting, a game support database, … Briefly describe your application domain by several paragraphs.
• design - you have to create conceptual model of your database and eventually discuss circles (loops) which appear in the model
• implementation - you have to:
  • create a database scheme in a relational DBMS - create srcipt
  • write a initialization script to fill database with a small amount of testing data - insert script
  • design and develop at least 25 ad-hoc queries over your database (queries should be of a given complexity, see sample of semestral project) - query script
  • formulate at least 8 queries also in relational algebra
  • create a log-file, which documents that your queries works and returns expected results - log file

A sample of semestral work is here.

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

• Oracle SQL Developer Data Modeler official site, local copy
• Oracle SQL Developer official site, local copy

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