You should take a look at "The Puppy Poster":
http://www.informationqualitysolutions.com/FreeStuff/rettigNormalizationPoster.pdf
It really covers database normalization well. It used to be given away
as a freebie when you subscribed to a magazine. You should take a few
hours and really go over it well.
Here are some things you need to think about
Artists and Albums often don't have a one-to-one relationship. The album
may be by Lady Gaga, but it's got a duet with Tony Bennet. Similarly, a
song may have multiple credited artists.
Second, depending upon how detailed you want to get, an artist may have
multiple roles on a song. The two biggies would be Vocalist and Lyricist
(or writer).
One of the things that makes me insane about iTunes is that the album
artist will be all of the credited artists. That can make things hard to
find.
On 3/6/2016 3:25 PM, sgarciaafi123 wrote:
Hey guys so I'm a bit confused. I'm making a artist, album, and track tables
and I'm confused about how to correctly link an album to their tracks if its
more than one.do I need to write one track to one album to one artist?
Artist1->album1->track1
Artist1->album1->track2
Or can I do it
Artist1->album1->track1,track2,track3
If I can do the second, what's the best way to do it?
Thank you, I'm new to DB.
--
View this message in context:
http://apache-database.10148.n7.nabble.com/connecting-artist-to-album-to-track-tables-together-correctly-tp145713.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
--
George Sexton
*MH Software, Inc.*
Voice: 303 438 9585
http://www.connectdaily.com