Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2019/2020

Design of Database Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
2383048 Z 3 1P+2C Czech
Lecturer:
Petr Žemlička, Vladimír Brdek
Tutor:
Petr Žemlička, Vladimír Brdek
Supervisor:
Department of Management and Economics
Synopsis:

The objective of the subject is mastering of basics in databases entity-relationship theory and obtaining practical skills by using database technology at the level needed for design of database, development of database applications and administration of database systems.

Requirements:

Database system design and development.

Syllabus of lectures:

Basic database systems terminology. Conceptual database model design. Entity-relationship data model. Data scheme normalization and its usage in relation database design. Design of relation database from conceptual model. Data organization. SQL query language. Practical database application development by using modern development environment. Recent database technology trends.

1.Basic database systems terminology.

2.Conceptual database model design.

3.Entity-relationship data model.

4.Data scheme normalization and its usage in relation database design.

5.Design of relation database from conceptual model.

6.Data organization. SQL query language.

7.Practical database application development by using modern development environment. Recent database technology trends.

Syllabus of tutorials:

1.Basic database systems terminology.

2.Conceptual database model design. Entity-relationship data model.

3.Transformation of entity-relationship data model into relation database.

4.Relation database, structure of data, integrity of data.

5.Database formalisation.

6.SQL query language.

7.Design of database model in DB. Database application development.

8.Design of database .

9.Design of database .

10.Screen forms design.

11.Print forms design

12.Application design

13.Presentation of students cases

Study Objective:

The objective of the subject is mastering of basics in databases entity-relationship theory and obtaining practical skills by using database technology at the level needed for design of database, development of database applications and administration of database systems.

Study materials:

Riordan, R.M.: Vytváříme relační databázové aplikace. Praha : Computer Press, 2000. 280 s. ISBN 80-7226-360-9, Pokorný, J.: Databázové systémy a jejich použití v informačních systémech. Praha : Acade-mia, 1992. 313 s. ISBN 80-200-0177-8, Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Fourth Edition. Mc-Graw-Hill. 2002, 1064 p., Hoffer, J.A., Prescott, Ma B., Mc Fadden, F.R.: Modern Database Management. 6 ed. Upper Saddle River : Prentice Hall, 2002. 638 s. ISBN 0-13-033969-5

Note:
Time-table for winter semester 2019/2020:
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
roomKN:B-129
Žemlička P.
Brdek V.

09:45–10:30
(lecture parallel1)
Karlovo nám.
Poč. učebna 12138
roomKN:B-129
Žemlička P.
Brdek V.

10:45–12:15
(lecture parallel1
parallel nr.101)

Karlovo nám.
Poč. učebna 12138
Tue
Fri
Thu
Fri
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-08-15
For updated information see http://bilakniha.cvut.cz/en/predmet10740402.html