power designer modelando la arquitectura de la empresa
TRANSCRIPT
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 1/50
PowerDesigner
Modelando la arquitectura de la empresaRoberto Olvera Sr. System Consultant
October 2008
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 2/50
Enterprise Architecture
Enter rise Architecture is a strate ic initiative that rovides alignment and integration for increasingly dynamic and complex environments resulting in business agility.
Enterprise Architecture perspectives As is …. To be
Information Management and data Lineage(critical and sensitive)
nterpr se uepr nt
– Business –
– Technical
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 3/50
Enterprise Architecture drivers
Enterprise Architectures to respond to
the following 3 key drivers: the need to better align IT systems with
business requirements
e nee or us ness an o responto competitive changes in a more agileway
the need to achieve regulatory
compliance and standards
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 4/50
How do Enterprises Manage Change?
PowerDesigner is the
most effective tool thatallows organizations tomanage the ‘impact ofchange’ from business
technologicalimplementations andbe able to trace alltechnology changesdirectly to
specific business.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 5/50
PowerDesigner
PowerDesigner is an integrated modeling solution that empowers effective Enterprise Architecture through clear, concise, and accurate, metadata synergy from all three views of the organization: business, information, and technology.
Ca ture, Mana e & Communicate
The Impact of Change in dynamic & complex enterprises
-
Integrated, Aligned & Agile Tooling Focused on
Modeling & Metadata Management
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 6/50
PowerDesigner
PowerDesigner - Enterprise Architecture implementation from business goals through implementation
all architectural layers and perspectives of the Enterprise
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 7/50
PowerDesigner features
Integrated modeling through standard methodologies:Data (E/R, Merise), Business (BPMN, BPEL, ebXML),Application (UML)
templates: SQL (with more than 50 supported DBMSs),Java, .NET
and update existing systems
A scalable enterprise repository solution with strongsecur y an vers on ng capa es o a mu -userdevelopment
Automated, customizable reporting capabilities
An extensible environment, permitting you to add newrules, commands, concepts and attributes to your
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 8/50
PowerDesigner
PowerDesigner’s sophisticated inter- model and code and database generation
to synchronize your models and applications to prov e you w t control over each
and every
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 9/50
PowerDesigner
tools for analyzing the dependencies
between model objects. When youperform an action on a model object,you can use:
Impact Analysis – to analyze the effectof the action on the objects thatde end on the initial ob ect.
Lineage Analysis – to identify theobjects that influence the initial object.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 10/50
Project Framework Matrix
A project allows you to group allthe models and other types ofdocuments you need to
accomplish a particular goal.
FEAF
Documents can be displayed in aproject diagram and includemodels and files with their
relationships. Framework matrix template help
to modeling process by providing agrid in which each cell must becompleted according to a set ofpredefined actions. Provides someof the most popular frameworks,including Zachman and FEAF andallows to create and customize
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 11/50
Zachman Framework
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 12/50
Modeling Techniques used by
Requirements, Business Process Models,Simple Data Models
All Models and Meta Data, Struggle most of
management.
UML (Unified Modeling Language)
Data Models (Conceptual, Physical)
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 13/50
Modeling is NOT Development…
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 14/50
PowerDesigner for BI/DW
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 15/50
PowerDesigner for Model Driven Data
Analysis and Design
Development andDeployment
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 16/50
PowerDesigner Architecture
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 17/50
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 18/50
Enterprise Architecture Model
The PowerDesigner enterprise architecture model (EAM) providesseven types of EA diagrams that allow you to model your businessprocesses and technology infrastructure, and to show the
relationshi s between them. The dia rams in the EAM are dividedinto three layers as follows:
• Business Layer• Or anization Chart
• Business Communication Diagram• Process Map -
• City Planning Diagram
• Application Layer• Application Architecture Diagram
• Service Oriented Diagram
• ec no ogy ayer• Technology Infrastructure Diagram
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 19/50
Organization Chart
An Organization Chart
re resents the structure of an organization in a graphical tree format.
It can be used to analyze
and display the relationships between
• (divisions, groups, etc)
• Individuals and
• Roles
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 20/50
Business Communication Diagram
A BusinessCommunicationdiagram can be usedto analyze anddis la :
• Relationships• Flows and
• Connections
between businesselements.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 21/50
Process Map
A process map
used to identify thebusinessarchitecture
people andorganization unitsand to describe:
• Businessfunctions and
• Classify theprocesses.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 22/50
City Planning Diagram
A Cit Plannin diagram allowsyou to focus onthe big picture ofyour enterprisearchitecture usingthe metaphor of
infrastructure of a
city.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 23/50
Application Architecture Diagram
An Application
Architecture diagramshows a high-levelview of the applicationarchitecture, and
allows to identify:• Applications, sub-a lications
• Components,
• Databases,• Services, etc,
and their interactions.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 24/50
Service Oriented Diagram
diagram allows you toassociate applications
the application layerwith business
objects in the
business layer to
design.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 25/50
Technology Infrastructure Diagram
A TechnologyInfrastructure
agram sp ays ahigh-level picture ofthe physicalarchitecturedeployed in the
enterprise.
Sybase Confidential
c
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 26/50
Requirements Model
listing and explaining precisely what actions must be
implemented during a development process.Offers three types of views:
Requirements document views: numbered lists of
requirements with a common set of properties Traceability matrix views: links requirements and design
, ,and/or other requirements
User allocation matrix views: links requirements andusers or groups who must meet these requirements duringa development process
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 27/50
Requirements document view
Sybase Confidential
Traceability Matrix View
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 28/50
Traceability Matrix View -
Requirements from different hierarchies - to manage interconnected requirements.
Sybase Confidential
Traceability Matrix View Design
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 29/50
Traceability Matrix View – Design
Design objects (objects from other types of models) – to confirm that the requirements
Sybase Confidential
c
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 30/50
Business Process Model
• Define and anal ze the sco e of thebusiness process
High Level Analysis
– Describe data re uirements of business rocessessupported by the proposed system or Enterprise
Low Level Analysis – Describe the data specifications for the software
• Define and anal ze the main rocessesand their informational requirements
• earn w ere e us ness n orma oncomes from and what happens to it
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 31/50
Business Process Model
Create as man interconnected business rocess dia ramas are needed to describe your system to a suitable level ofgranularity
,ebXML BPSS, ebXML CPA, BPEL4WS, or WS-BPEL
Reverse en ineer code from ebXML BPSS BPEL4WS or
WS-BPEL Simulate your model with the Simul8 application
Generate automatic PowerDesigner reports to documentyour model
Data Flow Diagram
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 32/50
Process Hierarchy Diagram (PHD)
Specify the structure of a systemy ent y ng g - eve unct ons,
decompose processes to an
appropriate level of detail in ordero un ers an e unc onsrequired by your system.The PHD is mostly used during theana ys s p ase o a pro ect: Define all the processes performed
in the scope of a business function ocus on process recogn on an
enumeration
Decompose already identified- an appropriate atomic level isreached
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 33/50
Business Process Diagram (BPD),
A business rocess diagram can becreated in a model, a package or withina decomposed process.
modeling different aspects of a system:
Top-level diagram – focuses on thero es p aye y us ness par ners n
relation to a system Choreography diagram – focuses on
a ocat ng respons ty or act v t es,choreographing objects, analyzing flows
of data, and modeling the implementationo ac v es
Data flow diagram – focuses on dataexchange between processes
Sybase Confidential
C l D M d l
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 34/50
Conceptual Data Model
A Conceptual Data Model (CDM)represents the logical structure ofa data system independent of any
software or data storage structure.a ows you o: Represent the organization of
data in a graphic format to create
(ERD). Verify the validity of data design.
(LDM), a Physical Data Model(PDM) or an Object-OrientedModel OOM which s ecifies anobject representation of the CDMusing the UML standard.
Sybase Confidential
D t Fl Di
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 35/50
Data Flow Diagram
A data flow dia ram DFD letsyou graphically represent the flowof data through a system without
.
Analysts can use DFD to modelthe functions a system has to
carry out and the interactionsbetween those functions in terms
processes
Sybase Confidential
L i l D t M d l
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 36/50
Logical Data Model
A Logical Data Model helps you design aata ase structure an per orm some
database denormalization actionsindependent of any specific DBMS physical
.
You can use a logical model as anintermediary step in the database design
Member
0..n
1..1
Division
Division number
Division name
Division address
<pi > ID
NAME
SHORT_TEXT
<M>
<M>
Idtf_1 <pi>
Team
Team number
Speciality
<p i> ID
SHORT_TEXT
<M>
Idtf_5 <pi>
physical designs: Start with a CDM containing entities,
attributes relationshi s domains data items
Chiefsupervises
0..1
0..n
Is member of
1..n
Works on 1..1
Belongs to
1..n
Employee
Employee number
First na me
Last name
Employee function
Employee salary
<p i> ID
NAME
NAME
NAME
MONEY
<M>
<M>
f i
Task
Task name
Task cost
<pi> NA ME
MONEY
<M>
<M>
Idt f_6 <pi>
and business rules.
Generate an LDM. Create indexes and
specify FK column names and other
Is done by1..1
1..n0..n
_
Participate
Start date (par)
End date (par)
D
D
common ea ures
Generate one or more PDMs, each targetedto a specific DBMS implementation
Sybase Confidential
c
Ph sical Diagram
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 37/50
Physical Diagram
A h sical dia ram allows ou to definea database structure from the physicalimplementation point of view. It takes into
,data storage structures and software, todescribe the structure of the database.
You build a physical diagram at the end,
start the software programming. The
physical diagram allows you to defineow ata rom conceptua mo e are
implemented in the database.
Sybase Confidential
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 38/50
ILM Information Liquidity Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 39/50
ILM Information Liquidity Model
enterprise. Data movement modeling allows you to
model where data originates to where it is loaded, andhow it is transformed on the way.
ILM is a graphical modeling environment focused on
data movement, which lets you model: Data replication – Data are replicated from source
,such as Replication Server and MobiLink.
Data transformation – Data from diverse sources arecombined to be extracted, transformed, and loaded tooutput sources via ETL (Extract Transform and Load)
Sybase Confidential
.
Data Replication
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 40/50
Data Replication
A replication process is a server engine that copies data from a given database into
• Publications – Specifies a set of data to
replicate, and from where it was extracted.
one or more a a ases or rep ca on processes.
Publications contain tables of the replicateddatabase and, which point to the tables of thesource database.
• –
replicated by indicating which replicateddatabase subscribes to which publication.
• Users – Specifies who is involved in the
replication process.
• Connection groups – Specifies a logical
group for database connections.• ven scr p s – pec es ow even s on e
process are implemented.
Sybase Confidential
Data Transformation
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 41/50
Data Transformation
A data transformation contains the detail of how data is extracted from datain uts transformed b actions and loaded into data out uts. At each ste ofthe transformation, you can display a mapping between the current data andits parent.
Sybase Confidentialc
Object Oriented Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 42/50
Object Oriented Model
An Object-Oriented Model (OOM) is a graphical analysis of a system using the
.is the standard language for object-oriented modeling.
notations of the Unified Modeling Language (UML).
Build an Object-Oriented Model (OOM) using the standard UMLdiagrams
Generate and reverse engineer Java, C#, VB.NET, andPowerBuilder files
Generate code for C++, Visual Basic, IDL-CORBA, etc. enerate , serv ets, an components Generate Conceptual Data Models (CDMs), Physical Data Models
(PDMs), XML Models (XSMs), and other Object-Oriented Models
Generate an OOM from a CDM, PDM, XML, or other OOM
Sybase Confidential
Object Oriented Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 43/50
A use case diagram is a high level UML diagram for analyzing requirements and systembehavior. It is part of an Object-Oriented Model (OOM), and graphically models thefunctionality of the system in the form of use cases, and how outside users, called actors,interact with them.
Sybase Confidential
Object Oriented Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 44/50
A sequence diagram is a UML interaction diagram. It represents the chronology of the passing of messages between system objects and actors. It may be used to illustrate a possible scenario of a use case, the execution of an operation, or simply an interaction scenario between classes of the system.
Sybase Confidential
Object Oriented Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 45/50
Activity Diagram is a UML diagram that models
e ynam c aspec s o a sys em. s a s mp ca onof the UML statechart diagram for modeling controlflows in computational and organizational processes.
Sybase Confidentialc
XML Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 46/50
XML Model
Since XML structures can be very complex, it is much easier tovisualize them through comprehensive and explicit diagrams,than to read XML-coded pages.
An XML model XSM is a ra hical re resentation of: an XML Schema Definition file (.XSD),
a Document Type Definition file (.DTD) or
- . .
XML is increasin l used to hold a lication data because it: describes and structures data, whereas HTML only displays
data
uses a self-describin and ersonalized s ntax can be exchanged between incompatible systems, since data is
stored in plain text format
Sybase Confidential
XML Model
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 47/50
XML Model
Build and check XML models
,models
,
XDR files
Model (PDM), Object Oriented Model (OOM), or
another XSM
Sybase Confidential
XML Schema
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 48/50
Sc e a
The following example shows the diagram of an XSM which models an XML schema
xs:annotation
Element<xs:element minOccurs="0" ref="xs:annotation"/>
for Resume documents
SC typeDefParticle
complexRestrictionType
{- xs:restrictionT ype}
attrDecls<xs:complexType name="complexRestrictionType">
<xs:complexContent><xs:restriction base="xs:restrictionType">
<xs:sequence><xs:element minOccurs="0" ref="xs:annotation"/>
Group<xs:group ref="xs:attrDecls">
</xs:group>
<xs:choice minOccurs="0"><xs:annotation>
<xs:documentation>This choice is added simply tomake this a valid restriction per the REC</xs:documentation>
</xs:annotation>" "
</xs:group></xs:choice><xs:group ref="xs:attrDecls">
</xs:group></xs:sequence>
Sybase Confidential
<xs:anyAttribute namespace="##other" processContents="lax"/>
</xs:restriction></xs:complexContent></xs:complexType>
c
BPM - Impact and lineage analysis
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 49/50
p g y
(BPM Sample)
Flow Flow_36
[Lineage]
(BPM Sample)
Decision Parall el(AND)_7
[Lineage](BPM Sample)
Flow Flow_35
[Lineage]
ece ve ssue s
Review Issue List
(BPM Sample)
Flow Flow_9
[Lineage]
Process E-mail Results of Vote
[Lineage]
Process Post Results on Web Site
[Lineage]
(BPM Sample)
Flow Flow_33
[Lineage]
[7 Days]
<<Vote>>
Discussion Cycle Announce Issues Collect Votes
(BPM Sample)
Flow Flow_22
[Lineage]
(BPM Sample)
Process Prepare Results
[Lineage]
repare esut s
Post Results on Web Site E-mail Results of Vote
(BPM Sample)
Process Collect Votes
[Lineage]
(BPM Sample)
Flow Message Flow_23
[Lineage]<<Dealine Warning>>
<<Issue Announcement>>
<<Vote Results>><<Vote Announcement>>
(BPM Sample)
Flow Flow_30
[Lineage]
(BPM Sample)
Process Voting M embers
[Lineage]
(BPM Sample)
Flow Message Flow_33
[Lineage]
(BPM Sample)
Flow Message Flo w_34
[Lineage]
<<Deadline Warning>>
Voting Members
Sybase Confidential
(BPM Sample)Process Announce Issues
[Change]
CDM - Impact and lineage analysis
8/8/2019 Power Designer Modelando La Arquitectura de La Empresa
http://slidepdf.com/reader/full/power-designer-modelando-la-arquitectura-de-la-empresa 50/50
p g y
Division
Team
Team number
Speciality
<pi>
Idt f_5 <pi>(Project Management (CDM))
Chief
supervises0..1
Member
0..n
Is member of1..n
Belongs to
1..1
Division numb er
Division nam e
Division address
<pi>
Idt f_1 <pi>
Customer
Customer number
Customer name
Customer address
Customer activity
Customer tel ephone
Customer fax
<pi>
Idtf 3 <pi >
(Project Management (CDM))
Data Item Division address
[Lineage]
[Lineage]
Subcontract
Subcontract1..1
0..n
Used
0..n
Uses0..n
Is responsible forIs manager of
0..1
0..n
0..n
Works on
1..1
1..n Employee number
First name
Last name
Employee function
Employee salary
<pi>
Idt f_2 <pi>
_
Project
Project number <pi>
(Project Management (CDM))
Entity Attribute Division.Division address
[Change]
Relationships
RelationshipsRelationships
Relationships(Project Management (CDM))
Entity Customer
Change
(Project Management (CDM))
Entity Task
Change
roec anagemen
Entity Participate
[Change]
composes0..n
composed of0..n
Belongs to
1..1
0..n
Is done by1..11..n
0..nProject name
Project label
Idt f_4 <pi>
Task
Material
Material number
Material name
Material type
<pi>
Idt f_7 <pi>
Participate
Start date (par)
End date (par)
Activity
RelationshipsRelationshipsRelationships
RelationshipsRelationships
(Project Management (CDM))
Entity Material
[Change]
(Project Management (CDM))
Entity Team
[Change]
(Project Management (CDM))
Entity Project
[Change]
ComposeTask name
Task cost
<pi>
Idt f_6 <pi>
Start date (act)
End date (act)
Relationships
RelationshipsRelationshipsRelationshipsRelationshipsRelationshipsRelationships
(Project Management (CDM))
Entity Employee
[Change]
(Project Management (CDM))
Conceptual Data Model Project M anagement (CDM)
[Lineage]
Entity impact
Sybase Confidential
RelationshipsRelationships
(Project Management (CDM))Entity Division
[Change]