Database Design - Where to start?

[mattgaunt]

Hey everyone,

Im new to using server side programming for webdevelopment, now I'm sure I'll be fine accessing and querying the database but i literally have no idea about how to set things up in terms of tables in a database.

So i intend to use for for a arbitrary number of tasks for a number of users, some settings for each user.

So I was thinking should I have a table of user's which contain a user ID, then use this to query a settings table and a tasks table?

I'm sorry if this sounds stupid but I'm sure you people would be able to point me in the right direction.

Many thanks

 

[mattgaunt]

Hey philjohn that does snd like a gd idea

Im just trying to make this as flexible as possible and i might get to a stage where i will want different lists of tasks per user, so would i have a seperate table for each list or one table containing pointer to each list in the table?

Sorry I got a bit lost with what you were saying

Cheers

 

[mattgaunt]

Awesome think i see where your getting at, thanks for your help