Course: Design of Database Systems

« Back
Course title Design of Database Systems
Course code KST/PPSDP
Organizational form of instruction Lecture + Tutorial
Level of course Master
Year of study 1
Semester Summer
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)
  • Fikejz Jan, Ing. Ph.D.
  • Strádal Oktavián, doc. Ing. Ph.D.
  • Lach Jaroslav, Ing.
Course content
Architectures of information systems (definition of an architecture, architectural principles, architecture patterns and design patterns). Introduction to object oriented design (objects and classes, information hiding, object identity, preservation of state, messages, interfaces, encapsulation, polymorphism, inheritance). Domains, encumbrance and cohesion. State spaces and behaviour: sound and extensible hierarchies. Mix-in classes and operation rings. Unified process: an overview of the design workflow. Design classes (what are design classes, anatomy of a design class, nested classes). Refining analysis relationships. Component based design (interfaces and components, overview of component-based technologies, component diagrams). Use case realization - design (interaction diagrams in design, design en modelling of concurrency, subsystem interactions). State machines. Persistency design: design of relational and object-oriented databases (relational model, functional dependencies, normalization, object-oriented databases). Implementation, deployment and testing: an overview.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Skills training
Learning outcomes
The objective of this course is to teach the students how to design an information system. Using the results of the analysis process learned in the previous course of Systems analysis, the students will learn how to continue with the design phase. They will learn what the characteristics of a good design are, which steps need to be taken to achieve it and how the design should be documented.
Students obtain needed knowledge from areas projection Data Base System (processing analyses and proposal engaged personal informative, resp. Data Base System netropsin range with usage choice CASE tools).
Prerequisites
unspecified

Assessment methods and criteria
Written examination, Home assignment evaluation

Given assignment confirms that a student has attended lessons to the extent required. Form, contents and length of the exam are determined in accordance with Study and Examining Rules of University of Pardubice. The exam consists of two parts, a written test and a theoretical exam. Student passes successfully the written test as well as the theoretical part of exam if he/she obtains at minimum 50% of possible points in each part.
Recommended literature
  • Date, C. An Introduction to database systems. Boston, Addison Wesley, 2003. ISBN 0321197844.
  • Matiaško, Karol. Databázové systémy. Žilina: Žilinská univerzita, 2002. ISBN 80-7100-968-7.
  • Whitten, J. a kol. Systems analysis and desing methods. New York, McGraw-Hill, 2005. ISBN 0073052337.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Transport Engineering Study plan (Version): Applied Informatics in Transport (2014) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer