|
Lecturer(s)
|
-
Šimonová Stanislava, doc. Ing. Ph.D.
|
|
Course content
|
Database systems as the technology platform company information systems. 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. Implementation of the relation data model into SW MS Access.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
|
|
Learning outcomes
|
Database systems are an important component of information systems in every organization. The users need the so-called right data for their work and the data is managed using database systems. To have data indeed correct it is necessary to design a correct database model using the data modeling approaches and data modeling tools. The aim of the course is to gain basic theoretical knowledge about database systems with the emphasis on relational systems as well as with structural and object oriented approaches to data modeling.
Database systems are an important component of information systems in every organization. The users need the so-called right data for their work and the data is managed using database systems. To have data indeed correct it is necessary to design a correct database model using the data modeling approaches and data modeling tools. Students will be able to solve problems of data modelling in terms of the structural and object-oriented approaches. Furthermore, they will learn how to apply a designed model within the relational database, and master basic principles of transaction systems with operational data.
|
|
Prerequisites
|
unspecified
|
|
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.
|