-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Je Merkredo Januaro 26 2005 15:34, Ian Sales (DBA) skribis: > SONG-TO-PERSON-OR-GROUP LINK TABLE > * song_id > * person_id > * group_id > * role (performer, lyricist, etc.) What I don't like about that, is that half the person_id fields would be empty and half the group_id fields would be empty. I was thinking about:
SONG-TO-PERSON-OR-GROUP LINK TABLE * song_id * musician_id * type ('person', 'group') * role (performer, lyricist, etc.) But this is the solution that has so many redundant data. It's not very clear, but it's there. - -- Pupeno: [EMAIL PROTECTED] - http://www.pupeno.com Reading Science Fiction ? http://sfreaders.com.ar -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) iD8DBQFB95G5fW48a9PWGkURAkhJAJ41HNEEI9v1ccLIAIuAajxA/oL59wCffdLE MNgYp2L6UrjgQcB3WWfCI10= =yDWO -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]