I have created a ER diagram fro this table http://oi55.tinypic.com/aytvv5.jpg

is it correct?my first ER diagram btw


http://oi52.tinypic.com/hx3ybk.jpg

I think coach is not directly related to member, coach is related to member through sport.

commented: agree +9

A little error on the table image.Take c02(ID) bobby as lee.they both has to be the same.sorry

Yes coach and member should be related through sport not directly.

except related through sport thing,others are 100% correct?
can anybody give me a correct one?

member ->|-------|<- sport -||-------|<- coach

except the urtrivedi mentioned thing ,i am not missing other things?