PB154/T01: Thu 24. 9. to Tue 22. 12. Thu 15:00–16:35 KOM 105, J. Valčík, Nepřihlašuje se. Určeno pro studenty se zdravotním postižením.
PB154/01: each odd Wednesday 8:00–9:50 A319, M. Batko
PB154/02: each even Wednesday 8:00–9:50 A319, M. Batko
PB154/03: each odd Wednesday 12:00–13:50 A218, M. Batko
PB154/04: each even Wednesday 12:00–13:50 A218, M. Batko
PB154/05: each odd Tuesday 10:00–11:50 A319, M. Batko
PB154/06: each even Tuesday 10:00–11:50 A319, M. Batko
PB154/07: each odd Tuesday 18:00–19:50 B204, V. Míč
PB154/08: each even Tuesday 18:00–19:50 B204, F. Nálepa
PB154/09: each odd Tuesday 14:00–15:50 A319, M. Batko
PB154/10: each even Tuesday 14:00–15:50 A319, M. Batko
PB154/11: each odd Thursday 12:00–13:50 A217, J. Sedmidubský
PB154/12: each even Thursday 12:00–13:50 A217, J. Sedmidubský
Prerequisites
Ability to understend a computer-specialized English text.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
Fields of study the course is directly associated with
there are 24 fields of study the course is directly associated with, display
Course objectives
The goal of the course is to teach students principles of database systems.
On successful completion of the course the student will be able:
to formulate reasons for using database systems;
to understand basic principles of database systems;
to describe ways of indexing data;
to design a database schema;
to create queries for retriving data.
Syllabus
Introduction, terminology
Entity-relationship model
Relational model
Query language SQL
Integrity constraints
Relational database design
Storage and file structures
Indexing and hashing
Query processing
Transaction management
New trends in database systems
Literature
recommended literature
SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006. xxvi, 1142. ISBN 0072958863. info
Teaching methods
Lectures and seminars. Lectures are given in Czech, but teaching materials are in English. In seminars, materials in Czech are used exclusively. Selected parts of the lecture are exercised in seminars.
Assessment methods
Lectures are given weekly. Seminars are given in a fortnight cycle. There are usually five seminars plus consultation. Presence at seminars is not mandatory.
The course is completed with a written exam consisting of ten tasks. Each task is graded with 6 points at maximum. The minimum of 30 points is required to pass the exam. Before sitting for the exam, the student must pass a credit test. It contains eight tasks in each a correct answer out of four options must be selected. A correct answer is graded with +3 points and an incorrect answer is graded with -1 point. The minimum to pass the test is 10 points.