Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2023/2024
UPOZORNĚNÍ: Jsou dostupné studijní plány pro následující akademický rok.

Design of Database Systems

The course is not on the list Without time-table
Code Completion Credits Range Language
2383048 Z 3 1P+2C Czech
Garant předmětu:
Lecturer:
Tutor:
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:
Further information:
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2024-03-27
Aktualizace výše uvedených informací naleznete na adrese https://bilakniha.cvut.cz/en/predmet10740402.html