Hi everyone,

I have attached an jpeg image of my ERD. It is for a web mailing application i developed for my degree using .NET. Please have a look at it and let me know your opinion. Do you have any idea to enhance it or do you forsee any problem with this design?

Thanks and Rgrd,
Seaview

I would Normalize Schedule at least to 2NF. It definately is not in 2NF yet.

Hi AGISB,

Thanks for your comment. You are absolutely correct, I overlooked that part. Here is the revised ERD. Any comments are welcome.

Btw, do we have to include all of our tables into the ERD? I have a AdminLogin table which has no relationship with the other tables, so I exclude it from the diagram, is this correct?

Regards, Seaview