Design of Database Systems

Lecturer:

Petr Žemlička (gar.), Vladimír Brdek (gar.)

Tutor:

Petr Žemlička (gar.), Vladimír Brdek (gar.)

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 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	roomHO:A-270 Žemlička P. 09:00–09:45 (lecture parallel1) Horská ulice Poc.ucebna 222roomHO:A-270 Žemlička P. 09:45–11:30 (lecture parallel1 parallel nr.101) Horská ulice Poc.ucebna 222
Fri

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: