Course: Database Systems Design

» List of faculties » DFJ » KID
Course title Database Systems Design
Course code KID/PPSDK
Organizational form of instruction Lecture
Level of course Master
Year of study not specified
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)
  • Strádal Oktavián, doc. Ing. Ph.D.
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.

Prerequisites
unspecified

Assessment methods and criteria
Written examination, Home assignment evaluation

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 (2013) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer