Database Systems

Předmět je náhradou za:

Database systems (E36DBS)
Databázové systémy (X36DBS)

Přednášející:

Cvičící:

Předmět zajišťuje:

katedra počítačů

Anotace:

Bulk data processing, DBMS concepts and architecture; conceptual data

models, E-R model;

database models, relational model; relational algebra,

SQL; 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.

Požadavky:

http://moon.felk.cvut.cz/~pisem1/doku.php?id=database_systems

Assessment conditions on the course Web page.

Before sitting for exam, students have to get an assessment.

Osnova přednášek:

1. Introduction, bulk data processing concepts, database system

concepts, DBMS architecture

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

Relational data model.

3. Database query, relational algebra

4. Relational algebra (cont.)

5. SQL language (part 1)

6. SQL language (part 2)

7. Conceptual modelling. E-R model and its variants.

8. E-R model (cont.)

9. Mapping E-R schema to relational schema

10. Functional dependencies, normal forms

11. Agorithms for relational database schema design, lossless join,

dependency preservation

12. Transactions. Concurrency control.

13. Database recovery

14. New trends in databases

Osnova cvičení:

1. Seminar room: Introduction to semester project

2. Computer laboratory: SQL communication with a database engine

3. Seminar room: relational algebra

4. Seminar room: Language SQL

5. Computer laboratory: SQL, Developer tools.

6. Seminar room: A relation schema design

7. Computer laboratory, E-R modellers

8. Seminar room: conceptual data design

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

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

11. Computer laboratory: Carrying out semester project

12. Seminar room: Transactions

13. Computer laboratory: Carrying out semester project

14. Presentation of semester project, grade assessment

Cíle studia:

Studijní materiály:

1. Date C. J.: Introduction to Database Systems, An - 8/E,

Addison-Wesley, 2004, ISBN: 0-321-19784-4

2. Elmasri R., Navathe S.: Fundamentals of Database Systems - 4/E,

Addison-Wesley, 2004, ISBN: 0-321-12226-7

Poznámka:

Další informace:

Pro tento předmět se rozvrh nepřipravuje

Předmět je součástí následujících studijních plánů:

• Computer Technology- structured studies (povinný předmět)