Data Modeling...some help please?

Hello i am currently trying to design the DB for my web project
http://art.uk-graffiti.co.uk

Users can submit artwork into the digital gallery, so users can have one or many pieces of art in the gallery.

Users can comment on images in the gallery, so users can have one or many comments and each piece of art work can have one or many comments.

Users also have the oppertunity to enter a biog about them selves..so one user will have one biog.

So this means i have 4 tables

USERS
ARTWORK
COMMENTS
BIOG

thing im not sure about is what keys to have in each table so the relations work and so that its fully normalised.

Im guessing...

USER
User_ID
Username
f_name
s_name
location

ARTWORK
Art_ID
Medium
Name
Date
User_ID

COMMENTS
Comment_ID
Text
Date
Art_ID
User_ID

BIOG
Biog_ID
Biog
User_ID

would this work?
many thanks...

You got it spot on gat! My only suggestion is avoid using reserved words for field names such as "text", "date", "name".

PS - you need to add some left/right margin to your user login box on your site to make it consistent w/ the other boxs.

yeh, its one of those..."it looks ok in DW but not in the browser" cases...

i wasnt sure how to set the peramiters for it, the input boxes seem to be stuck at a defalt size.

could you enlighten me as of how to change this..?

many thanks

In your CSS If your login box is a div/ID, then combine that name with the input rule, so that only the input box's within that div are effected.

Thanks for that, there is so much you can do with CSS....i need a book on it.

Anyway, i have to add some complexity to my database and to the way in which data is to be accessed.

I have come up with this.


Does this look ok...and can you understand what is going on with the data.

Just think what a user would want when comming to browse an art site.

Any help or suggestions are much appreciated.
Many Thanks

Your schema looks fabbo gat - have you recently done/doing a course in DB design?

For a good model on organising an art site, check out deviantart.com...if u haven't already.

Thanks...
Thing is....this is my final year uni project....so it has to have a fair bit of complexity.

Can you see how all the information is working? and is there anything else you can think of that a user would be looking for when browsing an art site?

I was thinking about including a rating system, so that each image could be rated out of 10...and top images can be displayed dynamically on the home page.

however i dont think that this would need a new table, could probably just go in the comments table, so when a user leaves a comment on an image...he/she also rates it out of ten.

But is there anything else that you would think i could add, just to beef it up a bit?

probably do the gallerys in a similar way to my original site
www.uk-graffiti.co.uk

thanks man