PowerDesigner OLAIS

Sample Class

Go to:

Evolving the conceptual model

• Reconnecting relationships
• Defining roles through relationships
• Create a many to many relationship
• Reflexive relationships - one-to-many, many-to-many

Logical modeling in the CDM

• Populating entities with attributes
• Normalization 1NF ~ 2NF ~ 3NF
• Data items: a first look at PowerDesigner’s meta-data
• Using domains
• Check constraints
• The relational requirement of identity
• Selecting identifiers from candidate keys
• Check the model for logical methodology requirements

Transforming the logical model

• Generating the first Physical Data Model (PDM)
• A look at default DDL and DML
• Dependent identifiers
• Logical issues the PDM

Evolving the CDM some more

• Eliminating many-to-many in the CDM
• Externalizing domains through entities
• Inheritance hierarchies for generalization and specialization
• Optional parents as super-types
• The one-to-one special case

Naming objects

See Also

© © 1997-2000 Applied Information Science