University of Pardubice
Study programmes & Course catalogue
for academic year 2016/2017
University of Pardubice
Česky
Search
FAQ

Course: Database Systems I

« Back
Course title Database Systems I
Course code USII/KDBS1
Organizational form of instruction Lecture
Level of course Bachelor
Year of study 2
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
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. 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 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. The conditions for the examination are made public in the system Stag by way of "Studijní materiály" (Educational materials) at the beginning of semester.
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 produktu MS Access.
  • Písek, S. Access 2010. 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): 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): 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): 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): 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): 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): Enterprise Management (2016) 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 (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 (2014) 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): 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): 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): Enterprise Management (2015) 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): 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): Enterprise Management (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): 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): 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): 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): 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): 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 (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 (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): 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): Enterprise Management (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
University of Pardubice, date of update: 02.11.2024 23:51. Data created for academic year 2016/2017