|
Lecturer(s)
|
-
Šimonová Stanislava, doc. Ing. Ph.D.
|
|
Course content
|
Data processing, database technology. Architecture of database systems, the relational data model. Approaches towards data modeling. Principles of structural data approach, ER diagrams. Principles of the object modeling, UML. Transformation models of analysis into the relational data model. Normalization of the relational data model. Data demands in database systems, data integrity. Language means, Structured Query Language.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
|
|
Learning outcomes
|
The aim of the course is to deepen theoretical and practical knowledge about database systems. The course Database systems II (in summer term) is the follow-up course to the Database systems I (held in winter term). They are expected basic database knowledge (basic principles of data modelling, basic principles of the relational data model).
Students will be able to solve problems of data modelling in terms of the structural and object-oriented approaches. Furthermore, they will understand designing of normalize relations for relational data models. Students will also learn how to apply a designed model within the relational database, and master basic principles of transaction systems with operational data.
|
|
Prerequisites
|
The course Database systems II (in summer term) is the follow-up course to the Database systems I (held in winter term). They are expected basic database knowledge (basic principles of data modelling, basic principles of the relational data model).
|
|
Assessment methods and criteria
|
Oral examination, Written examination, Didactic test, Discussion
The assignment is granted elaboration of given tasks; there are made public in the system Moodle at the beginning of semester (information about password is available in the system STAG - Study material (studijní materiály)). The examination consists of two parts, written and oral. It examines theoretical knowledge of presented themes and the student ability of practical task elaboration.
|
|
Recommended literature
|
-
GARCIA-MOLINA, H., ULLMAN, J., WIDOM, J. Database Systems. Prentice Hall, 2002.
-
System Help. - MS Access.
-
WHITEHORN, M, MARKLYN, B. Inside relational databases. Springer, 2001.
-
3) Date, J. An Introduction to Database Systems. Addison-Wesley Publishing Company, 2004.
|