Designing e-message system, need normal database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Designing e-message system, need normal database

Post 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!
Post Reply