a little normalization advice?

wxdqz

New Member
Hi all

I'm going to build a very basic news database, it will be one news item per page and has the following required fields

id|title|desc|keywords|headline|subhead|text|date

It seems clear to create two tables

id|title|desc|keywords

and

id|headline|subhead|text

but where should the date go? and does it mattter?

I'm tempted to put it in the first table as it will help if I want to search through the DB for keywords and dates but I'm looking for a second opinion.

Many thanks

Nick
 
Back
Top