|
|
|
| Perl Monk, Perl Meditation | |
| PerlMonks |
Re^2: Avoiding SQL double jeopardyby Pope-O-Matik (Pilgrim) |
| on Jun 28, 2015 at 03:23 UTC ( [id://1132319]=note: print w/replies, xml ) | Need Help?? |
|
PersonId INTEGER,
The problem with that is PersonRole defines what PersonId is. Meaning, PersonId is two different data entities in one column. This breaks normalization. Well, unless the entity is who the person is, and what role they play is merely an attribute for this table. If that is not the case, it should be two separate columns.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||