This is a temporary website for the course. Pages will move to edux portal if the portal is prepared.
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)
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)
-
Points Interval | Grade | Evaluation 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 |
Lectures are based on book and slides Database Management Systems written by R. Ramakrishanan and J. Gerkhe
-
-
-
-
lecture (17 of October) er-model (presentation is the same)
-
lecture (31 of October)
SQL (see previous presentation)
-
lecture (14 of November) We discussed conceptual models in your project
-
lecture (28 of November) Nomrmalization - another example + Transactional processing
-
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:
It is allowed to use another (your favorite) modeler and/or RDBMS and its client.