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

Recommended Answers

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

Jump to Post

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

Jump to Post

All 8 Replies

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.