chapter 15.02_data modelling

8/10/2019 Chapter 15.02_Data Modelling

1/35

IBM Global Services

2005 IBM CorporationData Modeling | 2.15.02 March-2005

Data Modeling


2/35

IBM Global Services

2005 IBM Corporation2 March-2005Data Modeling | 2.15.02

Objectives

The participants will be able to :

Explain Data Modeling

Know uses of Data Modeling

Describe the Basic Components of a Data Model

Know Data Modeler/ABAP Dictionary Terminology

Know about Optionality and Cardinality

Use SAP Graphic Notation and SAP Text Notation

Explain Data Model Hierarchies and the SAP EDM

Link a data model to dictionary objects


3/35

IBM Global Services


Data Dictionary

Real World

What is Data Modeling?

Data Model


4/35

IBM Global Services


Uses of a Data Model


5/35

IBM Global Services


EntityCustomer

Basic Components of a Data Model

Attribute

30 S. 17th St.

Entity Type

Order


6/35

IBM Global Services


Entity

Customer

Order

Product


7/35


8/35

IBM Global Services


Entity Type

Order

CustomerProduct


9/35

IBM Global Services


Data Modeler / ABAP Dictionary Terminology

Data Modeler ABAP Dictionary

Customer: entity record

Customer address: attribute field

Customers: entity type table


10/35


11/35

IBM Global Services


One - to - Many

Many - to - ManyOne - to - One

Cardinality


12/35

IBM Global Services


Order

Order Lines

1 1 A26

Order # Qty Part #

1 3 C589

2 1 A26

Many-to-Many Relationships

Primary Key: Order Number

Primary Key: Product Number

Primary Keys: Order Number

Product Number


13/35

IBM Global Services


?

Customer Order

?Customer

Optionality


14/35


15/35


16/35

IBM Global Services


Customers Orders

Example Using Graphic Notation


17/35


18/35

IBM Global Services


Professors

Students

Practice Using Graphic Notation II


19/35

IBM Global Services


StudentsEnrolment

Records

Courses

Practice Using Graphic Notation III

IBM Gl b l S i


20/35

IBM Global Services


1

C

N

CN

SAP Graphic Notation with Text Notation


21/35

IBM Gl b l S i


22/35

IBM Global Services


Customers Orders

1 CN:

Example Using Text Notation


23/35

IBM Global Services


24/35

IBM Global Services


Students

Professors

:

Practice Using Text Notation II

IBM Global Services


25/35

IBM Global Services


StudentsEnrolment

Records

Courses

:

Practice Using Text Notation III

IBM Global Services


26/35

IBM Global Services


Referential

Hierarchical

Aggregating

?

Conditional-Referential

Specialisation

Category


27/35


28/35

IBM Global Services


29/35

IBM Global Services


Department

Key:

Department Number

Professor

Key:Professor Number

Relationship Category: Referential

IBM Global Services


30/35

IBM Global Services


Department

Key:

Department Number

Professor

Key:Professor Number

Relationship Category: Conditional-Referential

IBM Global Services


31/35

IBM Global Services


Business Customer

Key:

ID Number

Customer

Key:ID Number

Relationship Category: Specialization


32/35

IBM Global Services


33/35

IBM Global Services


Data Model

Linking a Data Model to ABAP Dictionary Objects

IBM Global Services


34/35

IBM Global Services


Summary

A data model is a graphical representation of the information that is to be storedand processed by a system.

SAP comes with its own data model, called the Enterprise Data Model (EDM),

that describes the data design of the SAP system.

The basic components of a data model are Entities, Attributes & Entity types.

The cardinality of a relationship describes the number of entities of one type thatrelate to entities of other types.

The optionality of a relationship describes whether or not entities of one type must

refer to entities of another type.

Data models in SAP can be organised hierarchically.

The SAP Data Modeler is integrated with the ABAP Dictionary.

IBM Global Services


35/35

Questions

What is a data model ?

What is SAP's data model called ?

What are the basic components of a data model ?

chapter 15.02_data modelling

Documents