1PalGov © 2011

أكاديمية الحكومة اإللكترونية الفلسطينية

The Palestinian eGovernment Academy

www.egovacademy.ps

Session 1.2

Conceptual Data Modeling using

Object-Role Modeling (ORM)

Tutorial 1: Data and Business Process Modeling

Prof. Mustafa Jarrar

Sina Institute, University of Birzeit

mjarrar@birzeit.edu

www.jarrar.info

Reviewed by

Prof. Marco Ronchetti, Trento University, Italy

2PalGov © 2011

About

This tutorial is part of the PalGov project, funded by the TEMPUS IV program of the

Commission of the European Communities, grant agreement 511159-TEMPUS-1-

2010-1-PS-TEMPUS-JPHES. The project website: www.egovacademy.ps

University of Trento, Italy

University of Namur, Belgium

Vrije Universiteit Brussel, Belgium

TrueTrust, UK

Birzeit University, Palestine

(Coordinator )

Palestine Polytechnic University, Palestine

Palestine Technical University, PalestineUniversité de Savoie, France

Ministry of Local Government, Palestine

Ministry of Telecom and IT, Palestine

Ministry of Interior, Palestine

Project Consortium:

Coordinator:

Dr. Mustafa Jarrar

Birzeit University, P.O.Box 14- Birzeit, Palestine

Telfax:+972 2 2982935 mjarrar@birzeit.edu

3PalGov © 2011

© Copyright Notes

this material, or part of it, but should properly useEveryone is encouraged to

(logo and website), and the author of that part. cite the project

in any form or by any reproduced or modified No part of this tutorial may be

from the project, who have the full written permissionmeans, without prior

copyrights on the material.

Attribution-NonCommercial-ShareAlike

CC-BY-NC-SA

This license lets others remix, tweak, and build upon your work non-

commercially, as long as they credit you and license their new creations

under the identical terms.

4PalGov © 2011

Tutorial Map

Topic Time

Module I: Conceptual Data Modeling

Session 0: Outline and Introduction

Session 1.1: Information Modeling 1

Session 1.2: Conceptual Data Modeling using ORM 1

Session 1.3: Conceptual Analyses 1

Session 2: Lab- Conceptual Analyses 3

Session 3.1: Uniqueness Rules 1.5

Session 3.2: Mandatory Rules 1.5

Session 4: Lab- Uniqueness & Mandatory Rules 3

Session 5: Subtypes and Other Rules 3

Session 6: Lab- Subtypes and Other Rules 3

Session 7.1: Schema Equivalence &Optimization 1.5

Session 7.2: Rules Check &Schema Engineering 1.5

Session 8: Lab- National Student Registry 3

Module II: Business Process Modeling

Session 9: BP Management and BPMN: An Overview 3

Session 10: Lab - BP Management 3

Session 11: BPMN Fundamentals 3

Session 12: Lab - BPMN Fundamentals 3

Session 13: Modeling with BPMN 3

Session 14: Lab- Modeling with BPMN 3

Session 15: BP Management & Reengineering 3

Session 16: Lab- BP Management & Reengineering 3

Intended Learning ObjectivesModule 1 (Conceptual Date Modeling)

A: Knowledge and Understanding

11a1: Demonstrate knowledge of conceptual modeling notations and concepts

11a2: Demonstrate knowledge of Object Role Modeling (ORM) methodology.

11a3: Explain and demonstrate the concepts of data integrity & business rules

B: Intellectual Skills

11b1: Analyze application and domain requirements at the conceptual level,

and formalize it using ORM.

11b2: Analyze entity identity at the application and domain levels.

11b4: Optimize, transform, and (re)engineer conceptual models.

11b5: Detect &resolve contradictions & implications at the conceptual level.

C: Professional and Practical Skills

11c1: Using ORM modeling tools (Conceptual Modeling Tools).

Module 2 (Business Process Modeling)

A: Knowledge and Understanding

12a1: Demonstrate knowledge of business process modeling notations and concepts.

12a2: Demonstrate knowledge of business process modeling and mapping.12a3: Demonstrate understand of business process optimization and re-engineering.

B: Intellectual Skills

12b1: Identify business processes.

12b2: Model and map business processes.

12b3: Optimize and re-engineer business processes.

C: Professional and Practical Skills

12c1: Using business process modeling tools, such as MS Visio.

5PalGov © 2011

Session ILOs

After completing this session students will be able to:

11a1: Demonstrate knowledge of conceptual modeling notations

and concepts

11a2: Demonstrate knowledge of Object Role Modeling (ORM)

methodology.

11c1: Using ORM modeling tools (Conceptual Modeling Tools).

6PalGov © 2011

Remark: this tutorial is about

Object-Role Modeling (ORM),

Not Object-Relational Mapping (ORM)

7PalGov © 2011

Object-Role Modeling (ORM)

Room Time Activity Code Activity Name

20 Mon 9am VMC VisioModeler Class

20 Tue 2pm VMC VisioModeler Calss

33 Mon 9am AQD ActiveQuery Demo

33 Fri 5 pm SP Staff party

… … … …

Activity

(code)

Room

(Nr)

Time

(dh)

Activity

Name

20 Mon 9am VMC

20 Tue 2pm VMC

33 Mon 9am AQD

33 Fri 5pm SP

… … …

AQD ActiveQuery Demo

SP Staff party

VMC VisioModeler Calss

VMC VisioModeler Class

Y2K Year 200 seminar

… …

Has / refers to…at … is booked for…

8PalGov © 2011

Object-Role Modeling (ORM)

MovieName ReleaseYear Director Stars

Awakenings 1991 Penny MarshallRobert De Niro

Robin Williams

Backdraft 1991 Ron Howard

William Baldwin

Robert De Niro

Kurt Russell

Cosmology 1994 Terry Harding

Dances with wolves 1990 Kevin CostnerKevin Costner

Mary McDonnell

Representing information graphically

Movie

Year

Person

ReleasedIn

StaredBy/

DirectedBy/Directs

9PalGov © 2011

Object-Role Modeling (ORM)

• ORM is conceptual modeling language.

• ORM has an expressive graphical notation.

• ORM is designed for modeling DB schemes at the conceptual level.

You build an ORM schema and then click a bottom to automatically generate

a database.

Our goal in this course is to use ORM as general Conceptual Modeling

language, rather than as database modeling language.

ORM can be used for modeling business rules, ontology, XML

schemes, and others.

Movie

Year

Person

ReleasedIn

StaredBy/

DirectedBy/Directs

Conceptual Level Logical Level

10PalGov © 2011

ORM Usage Scenarios

Database

XML Schema Web (x)FormsBusiness Rules

Ontology

Originally

Warehouse

Later

Requirements

Engineering

Record

my recipes !

11PalGov © 2011

Object-Role Modeling (ORM): Other Examples

Book

Title

Author

Has/Is-Of

Witten-By/Writes

12PalGov © 2011

Book

Title

Author

2 Intro to Java

2

2B. Hacker

A. Smith

Has/Is-Of

Witten-By/WritesCalled Population

Object-Role Modeling (ORM): Other Examples

1 Databases Systems

1 J. Date

13PalGov © 2011

Object-Role Modeling (ORM): Other Examples

14PalGov © 2011

Object-Role Modeling (ORM) constructs

Called Object Type

(or Concept, or Class) Relation

Each part is called a Role

Subtype relation

15PalGov © 2011

Object-Role Modeling (ORM) constructs

Called Fact Type

Each fact type should be elementary.

16PalGov © 2011

Object-Role Modeling (ORM) constraints

Uniqueness Constraint:

Each Book must has at most one ISBN

Uniqueness Constraint:

Each ISBN must Is-Of at most one Book

Uniqueness Constraint:

It is possible that a Book is Written-By more

than one Author, and vice versa

Mandatory Constraint:

Each Book must has at Least one ISBN

17PalGov © 2011

eGov Ontology (using ORM)

18PalGov © 2011

Modeling Approaches (short discussion)

Which is more intuitive for modelers? For domain experts?

ER-model UML-model

ORM-model

Close to the way programmers

think

Nice for picturing to DB-schemes

Suitable for general

conceptual modeling, not

only DB schemes

19PalGov © 2011

References

1. www.zinnar.pna.ps

2. Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design, Terry Halpin (ISBN 1-55860-672-6) – Chapter 1.