#39 database design flaw

[Philip Lowman]

a design flaw I knew that has been with us for a
while.. perhaps most apparant when dealing with an
album that is named "Greatest Hits"

Albums must be made so that they are per artist and not
totally independent. This involves adding an artist_id
field to the albums table or some other sql modification.

[Philip Lowman]

Logged In: YES
user_id=78148

yeah this is going to be a while.. don't hold your breath..
taking a real database course this semester and going to
learn the proper way to do things before I decide how much I
want to rearchitect the Tunez db

[Manik Surtani]

Logged In: YES
user_id=472675

I agree - they should be a composite key on artist AND album
name - not just album name.