Normal
This looks like a good idea!I don't think I agree that you sholud make it "simple". Of course the db-structure has to be simple,and I think you nailed it pretty well on the model.Why not incorporate Artist info (allmusic?), and IMDB and so on.Actor/artist might bee the same deal? maybe a "person" entity might be in place? This would lead to a cross-section between music, musicvideos, and movies..(Britney spears-> Greatest hits, hit me baby one more time, crossroads)=(Person-> Artist, Artist (Music video), Actor)PS:.. One directory should be able to have more then one label..
This looks like a good idea!
I don't think I agree that you sholud make it "simple". Of course the db-structure has to be simple,and I think you nailed it pretty well on the model.
Why not incorporate Artist info (allmusic?), and IMDB and so on.
Actor/artist might bee the same deal? maybe a "person" entity might be in place? This would lead to a cross-section between music, musicvideos, and movies..
(Britney spears-> Greatest hits, hit me baby one more time, crossroads)
=
(Person-> Artist, Artist (Music video), Actor)
PS:.. One directory should be able to have more then one label..