Need Help Creating A Databse

[iNko]

Hi, i need help creating a database for a software that im supposed to do. My english isnt the best but ill try to my best to explain what i need and hopefully someone will understand and help me.

 

My assignment - "reminder" software. It would read messages from database and display them on desktop.

 

Heres a pic of the database im trying to make:

 

There would be 1 person (administrator) that creates new users (or deletes old ones), those users then can login to the software and are able to receive messages.

 

I was thinking that administrator could write a message, pick date (year/month/day), and then pick a user ID (to send this message to one specific person) or group ID (to send this message to many people). All this would be done from database.

 

What i need help with - figure out what "fields" i need (like - username/password/message_year/message_month etc)

This is what iv come up with so far:

 

Am i going in the right direction with this? any help or tips would be greatly appreciated.

 

P.S. sorry if i posted this in the wrong section or this isnt the forum for this kinda stuff :x

[Barand]

Do not hold separate day, month and year. Use DATETIME fields. (Time is usually relevant for messages)

 

Your design only allows for a user to be in a single group. Introduce a membership table to allow for a many to many relation between groups and users

 

You also have two addressees per message (to user and to group). I'd introduce a "receipt" table. Write to this when a message is sent, one row per recipient. When they read it, timestamp it. This will let you know who has read them and when.

 

See my attached image (they disintegrate when I paste directly on this board)

Edited October 13, 2012 by Barand