Member Avatar for silvercats

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

  • 3 Contributors
  • 8 Replies
  • 439 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by silvercats
Member Avatar for urtrivedi

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

commented: agree +9
Member Avatar for silvercats

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

Member Avatar for debasisdas

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

Member Avatar for silvercats

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

Member Avatar for urtrivedi

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

Edited by urtrivedi because: n/a
Member Avatar for silvercats

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.