normalising and viewing data from two tables

[rajchahal]

This is a two part question:

 

I have one table (articles) that containes all article info and publish date / unpublish date pairs - there are 4 pairs of dates. I've written this application, but now I realise I need to add 2 more date pairs.

Practically, is it worth normalising this table? I was told it would simplyfy my sql queries?

 

 

This leads me on to my next question, If I was to normalise i then would need to create a viewable relationship in mysql.

In access a plus sign would indicate relationships, which could be easliy opened and closed.

I would like to be able to view articles table with a subsection displaying article_occurance. how can I achieve this?

I'm using mysql administrator 1.2.12. and willing to try some other administrive program if this doesnt do the job.

Thank you