Databases 1

Lecturer:

Dana Majerová (gar.)

Tutor:

Dana Majerová (gar.)

Supervisor:

Synopsis:

Basic terms (information, data, information system, database system). Evolution of computer data processing. History of database systems. Basic data models. Conceptual models, E-R model (decomposition methodology, advantages of decomposed system).

Requirements:

Nothing.

Syllabus of lectures:

1. information - data, information system, database system, disadvantages of file management system

2. database system (basic terms, criteria, development), DBMS function

3. data models (network and hierarchical)

4. data models (relational)

5. conceptual models, E-R model, normal forms

6. table normalization

7. integrity constraints, relationships types

8. decomposition of M:N relationship

9. E-R models - bank, invoice, ZOO

10. E-R models - key words, cooking book, basic school

11. E-R models - tree structure, acyclic graph

12. E-R models - history journals

Syllabus of tutorials:

1. information - data, information system, database system, disadvantages of file management system

2. database system (basic terms, criteria, development), DBMS function

3. data models (network and hierarchical)

4. data models (relational)

5. conceptual models, E-R model, normal forms

6. table normalization

7. integrity constraints, relationships types

8. decomposition of M:N relationship

9. E-R models - bank, invoice, ZOO

10. E-R models - key words, cooking book, basic school

11. E-R models - tree structure, acyclic graph

12. E-R models - history journals

Study Objective:

Knowledges: overview and characteristics of the different types of database systems, with emphasis on relational database systems.

Ability to make the E-R model of database with correct decomposition of M-by-N relationships.

Study materials:

Key references:

[1] Pokorný, J., Halaška, J. Databázové systémy. Praha: ČVUT, 1998.

[2] Pokorný, J., Halaška, J. Databázové systémy: vybrané kapitoly a cvičení. Praha: ČVUT, 1997.

Recommended references:

[3] Bíla, J., Král, F. Databázové a znalostní systémy. Praha: ČVUT, 1999.

[4] Riordan, R. M. Vytváříme relační databázové aplikace. Praha: Computer Press, 2000.

[5] Hernandez, M. J. Návrh databází. Praha: Grada Publishing, 2006.

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: