Page 1 of 1

Designing e-message system, need normal database

Posted: Wed Sep 27, 2006 6:16 pm
by nickvd
I've been asked to build an e-message type of system, where the user can login, enter a new message along with one or more recipients (via email). I've broken things down into 4 main tables, and I'm trying to normalize things as much as possible.

* greetings
* users
* categories
* recipients

Using, DBDesigner 4, i've sketched out how I think the relationships should be working, but since my db normalization skills are a little rusty, i figured posting the question here would be the best thing i could do.

Below is the current relationship status for the above tables (with one additional table for the many greetings to many recipients lookup)

Image

Am I missing any data I should be storing? or Am I able to further normalize what I have already, so it's more efficient (building this out in multiple stages, first stage is public everything, second stage is private messages/purchased messages with printed certificate/item [cant get into details as i dont even have them, other than they WILL be selling products DIRECTLY relating to the messages])

Thanks In Advance!