|
|
Posted by Geoff Berrow on 06/25/06 08:53
Message-ID: <BbWdnUHqd747YgDZnZ2dnUVZ_vydnZ2d@comcast.com> from Jerry
Stuckle contained the following:
>
>I'd suggest you read up on "database normalization" and how it prevents the
>problems which can be caused by your method.
Indeed, and the OP should make sure that this is correct before doing
any coding.
As a lecturer I've seen students tackle this many times. You solo
artists, have bands with members, artists who perform as solo artists
and part of bands, albums and tracks, compilation albums, singles, DVDs
and concert performances. Quite a lot to consider. A properly thought
out entity relationship diagram will save a lot of grief later on.
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Navigation:
[Reply to this message]
|