P002 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)
prof. Ing. Pavel Zezula, CSc. (lecturer)
Guaranteed by
prof. PhDr. Karel Pala, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc.
Timetable
Mon 13:00–14:50 D1
Prerequisites (in Czech)
(! U332 Databases II ) && (! P502 Introduction to Database Systems )&&(!NOW( P502 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
Course objectives
The goal of the course is to teach students principles of database systems and design methods for developing database applications.
Syllabus
  • introduction; Entity-Relationship model; relational model; query language SQL; integrity constraints; relational database design; object-oriented databases; storage and file structures; indexing and hashing; query processing; transaction management; concurrency control; recovery system; new trends in database systems.
Literature
  • A. Silberschatz, H.F. Korth, and S. Sudarshan. Database System Concepts (third edition), McGraw-Hill, 1998, ISBN: 0-07-031086-6.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 1996, Spring 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000.

P002 Introduction to Database Systems

Faculty of Informatics
Autumn 2000
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)
prof. Ing. Pavel Zezula, CSc. (lecturer)
Guaranteed by
prof. PhDr. Karel Pala, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc.
Prerequisites (in Czech)
(! U332 Databases II ) && (! P502 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
Course objectives
The goal of the course is to teach students principles of database systems and design methods for developing database applications.
Syllabus
  • introduction; Entity-Relationship model; relational model; query language SQL; integrity constraints; relational database design; object-oriented databases; storage and file structures; indexing and hashing; query processing; transaction management; concurrency control; recovery system; new trends in database systems.
Literature
  • A. Silberschatz, H.F. Korth, and S. Sudarshan. Database System Concepts (third edition), McGraw-Hill, 1998, ISBN: 0-07-031086-6.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is taught: every week.
The course is also listed under the following terms Spring 1996, Spring 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2001.

P002 Introduction to Database Systems

Faculty of Informatics
Autumn 1999
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
Prerequisites (in Czech)
! U332 Databases II
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 taught: every week.
The course is also listed under the following terms Spring 1996, Spring 1997, Autumn 1997, Autumn 1998, Autumn 2000, Autumn 2001.

P002 Introduction to Database Systems

Faculty of Informatics
Autumn 1998
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
Prerequisites (in Czech)
! U332 Databases II
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 taught: every week.
The course is also listed under the following terms Spring 1996, Spring 1997, Autumn 1997, Autumn 1999, Autumn 2000, Autumn 2001.

P002 Introduction to Database Systems

Faculty of Informatics
Autumn 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, Spring 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.

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.

P002 Introduction to Database Systems

Faculty of Informatics
Spring 1996
Extent and Intensity
0/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 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.

P002 Úvod do databázových systémů

Faculty of Informatics
Spring 2002

The course is not taught in Spring 2002

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
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, Spring 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.

P002 Úvod do databázových systémů

Faculty of Informatics
Spring 2001

The course is not taught in Spring 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
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, Spring 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.

P002 Úvod do databázových systémů

Faculty of Informatics
Spring 2000

The course is not taught in Spring 2000

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
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, Spring 1997, Autumn 1997, Autumn 1998, Autumn 1999, Autumn 2000, Autumn 2001.
  • Enrolment Statistics (recent)