Member Avatar for silvercats

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

Edited by silvercats because: n/a
  • 3 Contributors
  • 10 Replies
  • 286 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by umer ansari

Recommended Answers

All 10 Replies

Member Avatar for silvercats

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

Member Avatar for umer ansari

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]

Member Avatar for debasisdas

That is good if coach is not a member.

Member Avatar for silvercats

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

Member Avatar for umer ansari

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

Member Avatar for umer ansari

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

Member Avatar for umer ansari

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

Member Avatar for umer ansari

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