P116 Data Modelling II

Faculty of Informatics
Autumn 2000
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 Data Modelling I
Předmět vyžaduje znalosti úvodního kursu databází a navazuje na předmět P114 - Datové modelování 1.
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
  • Concepts and objects, TIL with ramified type theory, conceptual systems
  • The concept of ideal data model (IDM) of an organisation, components of IDM, architecture of organisation IDM
  • Modeling tools, modeling capability, comparing of modeling tools according to modeling capability, new paradigm of information systems building
  • 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
  • Duží, Marie. Konceptuální modelování (Datový model HIT). Skripta. Slezská universita, Opava, duben 2000
  • 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
  • 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 1999, Autumn 2001.
  • Enrolment Statistics (Autumn 2000, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2000/P116