Database Systems

The course cannot be taken simultaneously with:

Databases (AD7B36DBS)

Lecturer:

Pavel Strnad

Tutor:

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:

https://service.felk.cvut.cz/courses/XD36DBS

Assessment requirements are stated on the subject's 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, file organisation, Database physical structure, other database objects (indexes, views, procedures)

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.

2. Date C. J.: An Introduction to Database Systems, Addison-Wesley, 6-th Edition, 1995

3. Elmasri R., Navathe S.: Fundamentals of database systems

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
Fri
Thu
Fri	roomKN:E-126 Strnad P. 09:15–10:45 ODD WEEK (lecture parallel1) Karlovo nám. Trnkova posluchárna K5

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans:

• Inteligentní systémy (compulsory course)
• Manažerská informatika (compulsory course)
• Softwarové inženýrství (compulsory course)
• Web a multimedia (compulsory course)