University of Pardubice
Study programmes & Course catalogue
University of Pardubice
Česky
Search
FAQ

Course: Database Systems I

« Back
Course title Database Systems I
Course code USII/PDBS1
Organizational form of instruction Lecture + Tutorial
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, doc. 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) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Economics and Operation in Enterprises (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Management of Financial Risks (2015) Category: Economy 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2016) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Regional and Information Management (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Economics and Operation in Enterprises (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Information and Security Systems (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2016) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Informatics in Public Administration (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Informatics in Public Administration (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Information and Security Systems (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Management of Financial Risks (2014) Category: Economy 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Economics and Operation in Enterprises (2016) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2016) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Regional and Information Management (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Management of Financial Risks (2013) Category: Economy 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Economics and Operation in Enterprises (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Security Management in Enterprises (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Informatics in Public Administration (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Regional and Information Management (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Information and Security Systems (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Enterprise Management (2014) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2013) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Economics and Administration Study plan (Version): Public Economics and Administration (2015) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter
University of Pardubice, date of update: 27.05.2024 23:50.