Hi.
I not very good at designing databases, so i'm asking for some suggestions/help.
This db is a combination of several other ones i've created. The reason for the merge was to make every element (news, event, workshop) have its own 'id' so that I can keep track of their corresponding images.
My problem lied is that, obviously, each element has several common attributes, but at the same time different attributes for it. I initially just combined all the data into a single table (tblContent) but realized that it wasn't correct, much less efficient. I decided to leave the common attributes into the single (tblContent) table and split up the other attributes into other tables. Somehow I know there is a better way of doing this, that's why i'm searching for suggestions.
I'd appreciate any help.
sijis
I couldn't upload it because file is too big. File can be found here: http://www.geocities.com/kaveman2000/new2003_v4.zip
It's also in MS Access 2000; file size 279KB
