Designing e-message system, need normal database
Posted: Wed Sep 27, 2006 6:16 pm
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)

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!
* 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)

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!