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