Database Design
Roles
- Some database shops insist that no two fields have exactly the same name.
- This presents an obvious problem with foreign keys
- A role name is an alternate name for a foreign key that clearly distinguishes the purpose that the foreign key serves in the table.
- The decision to require role names or not is usually established by the data or database administrator.