Course: Database Systems I

« Back
Course title Database Systems I
Course code USII/PDBS1
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study 2
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Kuchtíková Eva, Ing.
  • Kopáčková Hana, Ing. Ph.D.
  • Sedlák Pavel, Mgr. Ph.D.
  • Šimonová Stanislava, doc. Ing. Ph.D.
  • Panuš Jan, Ing. Ph.D.
  • Bílková Renáta, Ing. Ph.D.
  • Tomeš Milan, Ing.
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. Normalization of the relational data model. Data demands in database systems, data integrity. Language means, SQL. Transaction systems with operational data and data warehouses.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
Learning outcomes
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.
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 and master basic principles of data warehouses.
Prerequisites
unspecified

Assessment methods and criteria
Oral examination, Written examination, Didactic test, Discussion

The course is available in the system Moodle (information is available in the system STAG - Study material (studijní materiály)). The assignment is granted elaboration of given tasks; there are made public in the system Stag by way of "Studijní materiály" (Educational materials) at the beginning of semester. 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
  • Coronel, C. Database Principles - Fundamentals of Design, Implementation, and Management. Andover Cengage Learning EMEA, 2013.
  • Date, J. An introduction to database systems. Addison-Wesley Publishing Company, 2004.
  • Fowler, M. Destilované UML. Praha: Grada Publishing, 2009.
  • Kanisová, H. UML srozumitelně. Brno: Computer Press, 2006.
  • Microsoft. Manuál k produktu MS Access..
  • Písek, S. Access 2011. Praha: Grada Publishing, 2011.
  • Šimonová, S. Databázové systémy I. Univerzita Pardubice, 2013.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Economics and Administration Enterprise Management (2015) Economy 2 Winter
Faculty of Economics and Administration Economics and Operation in Enterprises (2014) Economy 2 Winter
Faculty of Economics and Administration Management of Financial Risks (2015) Economy 3 Winter
Faculty of Economics and Administration Security Management in Enterprises (2013) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2014) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2016) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2013) Economy 2 Winter
Faculty of Economics and Administration Regional and Information Management (2014) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2014) Economy 2 Winter
Faculty of Economics and Administration Economics and Operation in Enterprises (2015) Economy 2 Winter
Faculty of Economics and Administration Information and Security Systems (2015) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2014) Economy 2 Winter
Faculty of Economics and Administration Security Management in Enterprises (2016) Economy 2 Winter
Faculty of Economics and Administration Informatics in Public Administration (2015) Economy 2 Winter
Faculty of Economics and Administration Informatics in Public Administration (2013) Economy 2 Winter
Faculty of Economics and Administration Information and Security Systems (2013) Economy 2 Winter
Faculty of Economics and Administration Management of Financial Risks (2014) Economy 3 Winter
Faculty of Economics and Administration Security Management in Enterprises (2015) Economy 2 Winter
Faculty of Economics and Administration Economics and Operation in Enterprises (2016) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2016) Economy 2 Winter
Faculty of Economics and Administration Regional and Information Management (2015) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2013) Economy 2 Winter
Faculty of Economics and Administration Management of Financial Risks (2013) Economy 3 Winter
Faculty of Economics and Administration Enterprise Management (2013) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2015) Economy 2 Winter
Faculty of Economics and Administration Economics and Operation in Enterprises (2013) Economy 2 Winter
Faculty of Economics and Administration Security Management in Enterprises (2014) Economy 2 Winter
Faculty of Economics and Administration Informatics in Public Administration (2014) Economy 2 Winter
Faculty of Economics and Administration Regional and Information Management (2013) Economy 2 Winter
Faculty of Economics and Administration Information and Security Systems (2014) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2015) Economy 2 Winter
Faculty of Economics and Administration Enterprise Management (2014) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2013) Economy 2 Winter
Faculty of Economics and Administration Public Economics and Administration (2015) Economy 2 Winter