Database Systems

The course is a substitute for:

Database systems (36DBS)

Lecturer:

Irena Mlýnková (gar.), Martin Nečaský

Tutor:

Irena Mlýnková (gar.), Jakub Klímek, Tomáš Knap, Martin Nečaský, Pavel Strnad

Supervisor:

Department of Computer Science and Engineering

Synopsis:

Bulk data processing, DBMS concepts and architecture; conceptual data models, E-R model; database models, network, hierarchical, relational and object-relational model; relational algebra, formal query language; relational database desing, functional dependencies, normalization, design algorithms; mapping E-R concepts to the database models; query language SQL, DDL, DML, integrity constraints; transaction, error recovery, parallel access, data security, client-server architecture; physical level data view.

Requirements:

http://service.felk.cvut.cz/courses/X36DBS/

Assessment conditions on the course Web page. Before sitting for exam, students have to get an assessment. The exam consists of two parts: the first part is a common written test, the second part is an individual interview.

Syllabus of lectures:

1. Bulk data processing concepts. DBMS architecture

2. Data abstraction, conceptual, database and physical data model

3. Conceptual data model. E-R model. Entity type, Relationship type, attibute, integrity constraints

4. Overview of network, hierarchical, relation and object-relation database models

5. Relational data model. Relation, relational and set operations, relation schema, attributes

6. Structured query language - SQL (part 1)

7. SQL language (part 2)

8. Relational model (part 2), normalization using functional dependences

9. Query, relational algebra, Set operations

10. Alternative approches to a design of relation schema, quality criterions

11. Mapping E-R schema to relational schema

12. Transactions. Error recovery, concurrency control, data security and integrity

13. Physical level, heap, index of B* tree type, bitmap index, cluster index, hashed cluster.

14. Reserve

Syllabus of tutorials:

1. Seminar room: Introduction to semester project

2. Computer laboratory, E-R modellers

3. Seminar room: conceptual data design

4. Computer laboratory: SQL communication with a database engine

5. Seminar room: relation algebra

6. Computer laboratory: The first check point of the semester project

7. Seminar room: A relation schema design

8. Computer laboratory: Developer tools

9. Seminar room: Language SQL

10. Computer laboratory: Carrying out semester project

11. Seminar room: Language SQL, index B-trees

12. Computer laboratory: Carrying out semester project

13. Seminar room: Transactions

14. Presentation of semester project, grade assessment

Study Objective:

Study materials:

1. Pokorný, J., Halaška, I.: Databázové systémy, 2nd Edition, in Czech, Vydavatelství ČVUT, 2003.

2. Pokorný, J., Halaška, I., Valenta, M.: Databázové systémy, cvičení, in Czech, Vydavatelství ČVUT, 2002.

3. Date C. J.: Introduction to Database Systems, An - 8/E, Addison-Wesley, 2004, ISBN: 0-321-19784-4

4. Elmasri R., Navath S.: Fundamentals of Database Systems - 4/E, Addison-Wesley, 2004, ISBN: 0-321-12226-7

Note:

Time-table for winter semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue	roomKN:E-107 Mlýnková I. Nečaský M. 14:30–16:00 (lecture parallel1) Karlovo nám. Zengerova posluchárna K1
Fri
Thu	roomKN:E-230 Nečaský M. 07:30–09:00 (lecture parallel1 parallel nr.101) Karlovo nám. Černobyl K230
Fri

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans:

• Computer Technology- structured studies (compulsory course)