Download - 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
-
8/10/2019 Chapter 15.02_Data Modelling
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
-
8/10/2019 Chapter 15.02_Data Modelling
3/35
IBM Global Services
2005 IBM Corporation3 March-2005Data Modeling | 2.15.02
Data Dictionary
Real World
What is Data Modeling?
Data Model
-
8/10/2019 Chapter 15.02_Data Modelling
4/35
IBM Global Services
2005 IBM Corporation4 March-2005Data Modeling | 2.15.02
Uses of a Data Model
-
8/10/2019 Chapter 15.02_Data Modelling
5/35
IBM Global Services
2005 IBM Corporation5 March-2005Data Modeling | 2.15.02
EntityCustomer
Basic Components of a Data Model
Attribute
30 S. 17th St.
Entity Type
Order
-
8/10/2019 Chapter 15.02_Data Modelling
6/35
IBM Global Services
2005 IBM Corporation6 March-2005Data Modeling | 2.15.02
Entity
Customer
Order
Product
-
8/10/2019 Chapter 15.02_Data Modelling
7/35
-
8/10/2019 Chapter 15.02_Data Modelling
8/35
IBM Global Services
2005 IBM Corporation8 March-2005Data Modeling | 2.15.02
Entity Type
Order
CustomerProduct
-
8/10/2019 Chapter 15.02_Data Modelling
9/35
IBM Global Services
2005 IBM Corporation9 March-2005Data Modeling | 2.15.02
Data Modeler / ABAP Dictionary Terminology
Data Modeler ABAP Dictionary
Customer: entity record
Customer address: attribute field
Customers: entity type table
-
8/10/2019 Chapter 15.02_Data Modelling
10/35
-
8/10/2019 Chapter 15.02_Data Modelling
11/35
IBM Global Services
2005 IBM Corporation11 March-2005Data Modeling | 2.15.02
One - to - Many
Many - to - ManyOne - to - One
Cardinality
-
8/10/2019 Chapter 15.02_Data Modelling
12/35
IBM Global Services
2005 IBM Corporation12 March-2005Data Modeling | 2.15.02
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
-
8/10/2019 Chapter 15.02_Data Modelling
13/35
IBM Global Services
2005 IBM Corporation13 March-2005Data Modeling | 2.15.02
?
Customer Order
?Customer
Optionality
-
8/10/2019 Chapter 15.02_Data Modelling
14/35
-
8/10/2019 Chapter 15.02_Data Modelling
15/35
-
8/10/2019 Chapter 15.02_Data Modelling
16/35
IBM Global Services
2005 IBM Corporation16 March-2005Data Modeling | 2.15.02
Customers Orders
Example Using Graphic Notation
-
8/10/2019 Chapter 15.02_Data Modelling
17/35
-
8/10/2019 Chapter 15.02_Data Modelling
18/35
IBM Global Services
2005 IBM Corporation18 March-2005Data Modeling | 2.15.02
Professors
Students
Practice Using Graphic Notation II
-
8/10/2019 Chapter 15.02_Data Modelling
19/35
IBM Global Services
2005 IBM Corporation19 March-2005Data Modeling | 2.15.02
StudentsEnrolment
Records
Courses
Practice Using Graphic Notation III
IBM Gl b l S i
-
8/10/2019 Chapter 15.02_Data Modelling
20/35
IBM Global Services
2005 IBM Corporation20 March-2005Data Modeling | 2.15.02
1
C
N
CN
SAP Graphic Notation with Text Notation
-
8/10/2019 Chapter 15.02_Data Modelling
21/35
IBM Gl b l S i
-
8/10/2019 Chapter 15.02_Data Modelling
22/35
IBM Global Services
2005 IBM Corporation22 March-2005Data Modeling | 2.15.02
Customers Orders
1 CN:
Example Using Text Notation
-
8/10/2019 Chapter 15.02_Data Modelling
23/35
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
24/35
IBM Global Services
2005 IBM Corporation24 March-2005Data Modeling | 2.15.02
Students
Professors
:
Practice Using Text Notation II
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
25/35
IBM Global Services
2005 IBM Corporation25 March-2005Data Modeling | 2.15.02
StudentsEnrolment
Records
Courses
:
Practice Using Text Notation III
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
26/35
IBM Global Services
2005 IBM Corporation26 March-2005Data Modeling | 2.15.02
Referential
Hierarchical
Aggregating
?
Conditional-Referential
Specialisation
Category
-
8/10/2019 Chapter 15.02_Data Modelling
27/35
-
8/10/2019 Chapter 15.02_Data Modelling
28/35
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
29/35
IBM Global Services
2005 IBM Corporation29 March-2005Data Modeling | 2.15.02
Department
Key:
Department Number
Professor
Key:Professor Number
Relationship Category: Referential
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
30/35
IBM Global Services
2005 IBM Corporation30 March-2005Data Modeling | 2.15.02
Department
Key:
Department Number
Professor
Key:Professor Number
Relationship Category: Conditional-Referential
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
31/35
IBM Global Services
2005 IBM Corporation31 March-2005Data Modeling | 2.15.02
Business Customer
Key:
ID Number
Customer
Key:ID Number
Relationship Category: Specialization
-
8/10/2019 Chapter 15.02_Data Modelling
32/35
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
33/35
IBM Global Services
2005 IBM Corporation33 March-2005Data Modeling | 2.15.02
Data Model
Linking a Data Model to ABAP Dictionary Objects
IBM Global Services
-
8/10/2019 Chapter 15.02_Data Modelling
34/35
IBM Global Services
2005 IBM Corporation34 March-2005Data Modeling | 2.15.02
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
-
8/10/2019 Chapter 15.02_Data Modelling
35/35
Questions
What is a data model ?
What is SAP's data model called ?
What are the basic components of a data model ?