FI:U332 Organizace dat, databáze II - Course Information

U332 Organizace dat, databáze II

Extent and Intensity

0/2. 0 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Pavel Hajn (lecturer)

Guaranteed by

Contact Person: RNDr. Pavel Hajn

Prerequisites

Aplication of the knowledges from P002 .

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

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

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.

Language of instruction

Czech

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