Quantcast

connecting artist to album to track tables together correctly

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

connecting artist to album to track tables together correctly

sgarciaafi123
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: connecting artist to album to track tables together correctly

George Sexton
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
Loading...