Design of Database Systems

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:

• 11 126 NSTI REP 2012 základ (compulsory elective course)