Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rolenames in schema design

Rolenames in schema design

From: Ann Schrader <anncraig_at_wavefront.com>
Date: Mon, 30 Nov 1998 14:11:04 -0600
Message-ID: <3662FBD7.19ED@wavefront.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US