P116 Data Modelling II

Faculty of Informatics
Autumn 1999
Extent and Intensity
1/2. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: z (credit).
Teacher(s)
RNDr. Zdenko Staníček, Ph.D. (lecturer)
Guaranteed by
doc. Ing. Jan Staudek, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Prerequisites (in Czech)
P002 Introduction to Database Systems && P114 Datové modelovaní I
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Syllabus
  • The concept of ideal data model (IDM) of an organisation, components of IDM, architecture of organisation IDM
  • Pattern constructions in components: recursive relationships, the bill-of-material structure, construction using data polymorphism, using of the construction "occurrence is an element of of a class"
  • Semantics mistakes in existing IS and how to find them
  • Component architecture of IS, the concept of a delegate of an entity in component, consolidation of components of IDM, categorisation of entity sorts
  • The component "Global objects": identification of objects and their relationships, unification of identical objects and relationships
  • Deriving of the logical data model (LDM) from IDM and its transformation to physical data model (PDM)
  • Exercises focused on: practical advance of the creating of an organisational IDM using CASE, audit of organisation data model
  • Assignment: to create IDM of a given organisation
Literature
  • POKORNÝ, Jaroslav. Databázové systémy a jejich použití v informačních systémech. 1. vyd. Praha: Academia, 1992, 313 s. ISBN 8020001778. info
  • GRAY, Peter M. D., Krishnarao G. KULKARNI and Norman W. PATON. Object-Oriented Databases :A Semantic Data Model Approach. New York: Prentice Hall, 1992, 237 s. ISBN 0-13-630203-3. info
  • POKORNY, Jaroslav. Konstrukce databázových systémů. Praha: Vydavatelství ČVUT, 1999, 166 pp. ISBN 80-01-01935-7. info
  • Případové studie z reálných projektů fy SHINE studio s.r.o.
Assessment methods (in Czech)
K zápočtu a zkoušce je vyžadována domácí práce -- vytvoření IDM dané organizace. Zkouška se skládá z písemné a ústní části.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is taught every week.
The course is also listed under the following terms Autumn 2000, Autumn 2001.
  • Enrolment Statistics (Autumn 1999, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn1999/P116