I am having trouble determining how to Normalize a table.
Examine the table tblArtist. Normalize the table, creating any new tables you think are necessary to complete the normalization. Define a primary Key for the new table created. Join the new table created to the table tblArtist and enforce referential integrity between the two tables/
The table is: tblArtists
ArtistID (primary Key)
I am lost on this step. Can someone point me in the right direction?