P502 Introduction to Database Systems

Faculty of Informatics
Autumn 2001
Extent and Intensity
2/0. 2 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Pavel Hajn (lecturer)
Guaranteed by
prof. PhDr. Karel Pala, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Pavel Hajn
Timetable
Thu 17:00–18:50 B011
Prerequisites (in Czech)
(! U332 Databases II ) && (! P002 Introduction to Database Systems )&&(! NOW ( P002 Introduction to Database Systems ))
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 / plans the course is directly associated with
Syllabus
  • Introduction to DBs. Entity sets, attributes, key attributes. Data sharing, DBS architecture, external, conceptual and internal schemes. Database management system. Data model.
  • Relational database model. Relation scheme, relation, relation scheme instance. Relational database scheme.
  • Data manipulation languages. Relational algebra, relation calculus. SQL language.
  • Design of relational DB scheme. Functional dependencies. Relational scheme decomposition. The second, the third and the Boyce--Codd normal forms.
  • Introduction to distributed databases. Horizontal and vertical fragmentation. Queries in distributed processing.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Autumn 2000.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2001/P502