1. How can oracle show relationships between tables & identify the true primary keys without having the additional foreign keys in other/said tables. e.g. Product Number, Workflow, Workflow Step are PK in the 'Product Workflow Map' entity but appear as FK in the other entities.
2. If we use the 'pseudo key' approach how we show the natural keys as the true primary key? e.g. The pseudo key for entity 'Work Order Workflow' is 'Work Order Workflow ID' but the natural key would be 'Planned Workflow Step Completion Date'
