I am making a music library system with php in MySQL. In this system there would be a table named Songs. Since many songs can be by the same Artist (Person), I wanted to store a table of Person that contains a persons data (name, DoB, hometown, fan page URL), then just store that ID in the Songs table.
I'm trying to avoid repeating the same 10 fields for an Artist over and over for each of their songs. I'd rather store the ID (Primary Key) and then be able to pull all of their specific data.
What is this called, so I can research how to do it (or can someone give me an example)?
If I do this, will queries for "Barry Manilow", who's ID may be '123', be found in every song that contains the field Artist='123'?
Thanks, -CJJ (Basically, what's the best way to reuse fields)