-----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]

Reply via email to