Course: Database System Design

« Back
Course title Database System Design
Course code KST/INPDS
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)
  • Karamazov Simeon, prof. Ing. Dr.
  • Fikejz Jan, Ing. Ph.D.
  • Lach Jaroslav, Ing.
Course content
Principles of object-oriented design. Application architecture design. Design of the structure and the behaviour of the application. Design patterns. Transformation of the object-oriented model into a relational data model. Organization of a project according to UP. Project planning. Configuration and version management. Testing.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities, Skills training
Learning outcomes
In this course the students learn to design large information and database systems in an object-oriented environment. Based on an existing design model the students learn to create a set of design models using the UML and Unified Process. The students also learn other aspects of database systems projects such as planning, project organiation, configuration and version management, iterative approach and testing.
Ability to create a high-quality object-oriented system model using the principles of object-oriented design. Knowledge of and ability to use design patterns. Knowledge of and ability to apply the Design activities of UP. Ability to organize and plan a database system project. Ability to create and use a system for configuration and version management. Ability to design and execute different sorts of tests.
Prerequisites
Knowledge of the basic principles of the relational data modelling (type, relational variable, relation, operations on relations). Ability to create a normalized structure of a relational database. Ability to create analytical models of a system (use cases, class diagrams, interaction diagrams). Knowledge of different fases and disciplines of the Unified Process. Ability to perform activities connected with the Requirements and Analysis disciplines of the UP. Ability to program in at leat one object-oriented language (Java, C#). Knowledge of and ability to use UML. Knowledge of and ability to use ERD.

Assessment methods and criteria
Oral examination, Written examination, Home assignment evaluation

Designing of software systems, Architectures and techniques of database systems.
Recommended literature
  • Arlow, Jim. UML 2 a unifikovaný proces vývoje aplikací : objektově orientovaná analýza a návrh prakticky. Brno: Computer Press, 2008. ISBN 978-80-251-1503-9.
  • C. J. Date. An Introduction to the Database systemsAddison Wesley, 8th edition, 2004. Addison Wesley, 8th edition, 2004.
  • Dennis, Haley-Wixom, Tegarden. Systems Analysis And Design With UML Version 2.0.. Wiley, 2nd edition, 2005.
  • PageJones, Meilir. Základy objektově orientovaného návrhu v UML. Praha: Grada, 2001. ISBN 80-247-0210-X.
  • Whitten, Bentley, Dittman. Systems Analysis & Design Methods. McGrawHill, 6th edition, 2004.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Electrical Engineering and Informatics Study plan (Version): Information Technology (2016) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Electrical Engineering and Informatics Study plan (Version): Information Technology (2015) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Electrical Engineering and Informatics Study plan (Version): Information Technology (2014) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer