mysql - database normalization users and messages database -

i'm newbie databases , want create database have

1. username varchar(16)
2. membership status ( paid or free )
3. message text (most or should use else?)
4. messages counter user 'to count total number of messages user (probably unsigned int).
5. catagory of message varchar(60)
6. date posted date

now have layout database not sure how first , second , third normal forms. appreciated.

thanks

seems want user table:

userid, username, member_status 

and message table:

userid, category, date, message 

a category table:

category, description 

you can total number of messages user query like:

select count(*) message userid = 'someuser' 

so don't store that.

hope gets started. have fun...