Does PowerDesigner allow attributes on relationships?
A. No, although this addition is planned for a future release of PowerDesigner. However, it is possible to use an ordinary entity to resolve this situation. Simply create an entity with dependent relationships to the entities participating in the relationship to be given an attribute, as shown below: Q. What is the difference between a Primary Key and an Alternate Key? A. Any column or set of columns, whose combined values uniquely identify a table row, is termed a Candidate Key. One of these keys is chosen to become the primary key and the others are then alternate keys. These alternate keys may be used, as well as the primary key, to locate a table row. For example, the Client table might have Client Number as its primary key and Client Name as an alternate key. Both keys will uniquely identify a client in the client table. Q.
