I have created an ER diagram for this table



oi55.tinypic.com/aytvv5.jpg

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

oi52.tinypic.com/hx3ybk.jpg - here is the ER diagram I created

is this ok?what are the errors

Also I want to convert this one to the 3rd normal form using this ER diagram.


# indicates the primary key

Members table - [#Member ID,member name]
Sports table - [#sport Id,Sport name]
Coach table - [#Coach table,coach name]
IDK.name table - [#Member ID,#sport ID,#coach Id]

are these tables correct?Do I have to connect and show relationships between tables?

I know this is long,at least answer the ER diagram question if you can't answer both.thanks!