Better design?
Posted: Fri Jan 18, 2008 9:45 pm
I want to make a database where people login and insert jokes.
//Design 1
joke
joke_id
joke
category_id
author_id
category
category_id
category
author
author_id
author_name
// Design 2 - this is given in a php book
joke
joke_id
joke
author_id
category
category_id
category
author
author_id
author_name
jokecategory
joke_id
category_id
Thanks
//Design 1
joke
joke_id
joke
category_id
author_id
category
category_id
category
author
author_id
author_name
// Design 2 - this is given in a php book
joke
joke_id
joke
author_id
category
category_id
category
author
author_id
author_name
jokecategory
joke_id
category_id
Thanks