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

Thanks

Recommended Answers

That is good if coach is not a member.

Jump to Post

All 10 Replies

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

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]

That is good if coach is not a member.

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

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...

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

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

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…..

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.