3
Contributors
10
Replies
12
Views
6 Years
Discussion Span
Last Post by umer ansari
0

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 correct?
thanks

1

Members table - [(p.k)Member ID,member name]
Sports table - [(p.k)sport Id,Sport name]
Coach table - [(p.k)Coach table,coach name]
sports detail .name table - [(f.k)Member ID,(f.k)sport ID,(f.k)coach Id]

0

ok.Thanks every one.I am gonna take umer ansari's answer as the final and correct one.any disagreement? debasisdas or some one???

0

Members table - [(p.k)Member ID,member name]
Sports table - [(p.k)sport Id,Sport name]
Coach table - [(p.k)Coach id,coach name]
sports detail .name table - [(f.k)Member ID,(f.k)sport ID,(f.k)coach Id]


now check it sorry for my old mistake...

0

now u can make erd by seeing the normal form now it is correct because here now all the dependencies has been removed..
best of luck

0

sports detail comes in sports table and n sports detail here comes only foreign key of sports in detail..
now here any values can b repeated because here all keys are foreign key not p.k

0

Sports
Sport id(p.k) Sports name

Coach


Coach id(p.k) Coach name


Member
Member id(p.k) Member name


Sports details

Sport id(f.k) Coach id(f.k) Member id(f.k)

Now check it broo…..

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.