Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Rolenames in schema design
What's your opinion?
I am are seeking feedback on the use of role names in database design. A Role Name "declares a new attribute whose name and definition are intended to connote the busines statement embodied by the relationship that contributes the foreign key or keys." (Designing Quality Databases with IDEF1X Information Models, Thomas A. Bruce, 1992). How prevalent is the use of role names in the real world? Its use seems to create as much confusion as it lends clarity. How is this implemented in case tools (i.e., ERwin).
ROLE NAME Defintion: A new name for a foreign key attribute or group of foreign key attributes, which defines the role that it plays in the child entity.
Example:
team-id in parent table TEAM
player-team-id in child table PLAYER
Received on Mon Nov 30 1998 - 14:11:04 CST