P002 Introduction to Database Systems

Faculty of Informatics
Spring 1997
Extent and Intensity
2/0. 2 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Pavel Hajn (lecturer)
Guaranteed by
Contact Person: RNDr. Pavel Hajn
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
The course is also listed under the following terms Spring 1996, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.
  • Enrolment Statistics (Spring 1997, recent)
  • Permalink: https://is.muni.cz/course/fi/spring1997/P002