FI:P002 Introduction to Database Syste - Course Information

P002 Introduction to Database Systems

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

• Informatics (programme FI, B-IN)
• Informatics (programme FI, M-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
• Information Technology (programme FI, B-IN)

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

• Enrolment Statistics (Spring 1997, recent)
  
• Permalink: https://is.muni.cz/course/fi/spring1997/P002