I just wanted to see if someone would review my ERD to make that I have my relationships correct. If not please point me in the right direction as I am new to database design and want to make sure that I am on the right track. Thank you for viewing my post.


ERD02.doc

your employee-employeetype relationship has the FK on the wrong side

i think this error is also repeated in other relationships

Ok thanks for looking at my post and offering help I will make thee necessary corrections and repost my results. Again thank you

ERD02.doc
Ok here is my revised ERD but still not sure if I have gotten this correct yet. Also wouldn't Deliveries and Customer be a 1:1 relationship?

Only if you only want to deliver to a customer once. Wouldn't you want to keep a customer and continue to sell items to them over and over again. I did not look at your diagram.

Dave

Thanks Dave for anwsering my question. I thought thats how it should be but I wasnt sure. Thanks for the clarification.

Edit: I am still trying to figure this out and have made a few more changes to my ERD.
Here is my updated ERD: ERD02.doc