How to convert this to 3RD normal form?
http://oi55.tinypic.com/aytvv5.jpg
error in above table >>>>> Take c02(ID) bobby as lee.they both has to be the same
Here what I have done.# indicated 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]
all are ok?
thanks