3RD normal form question

Question

silvercats 10 Junior Poster

13 Years Ago

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 13 Years Ago by silvercats because: n/a

3 Contributors
10 Replies
286 Views
1 Week Discussion Span
Latest Post 13 Years Ago Latest Post by umer ansari

debasisdas 580 Posting Genius

13 Years Ago

That is good if coach is not a member.

Reply to this topic

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.

silvercats 10 Junior Poster · Answer 1 · 2011-04-23T08:27:48+00:00

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

umer ansari 0 Newbie Poster · Answer 2 · 2011-04-29T10:17:42+00:00

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]

silvercats 10 Junior Poster · Answer 3 · 2011-04-29T18:46:37+00:00

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

silvercats 10 Junior Poster · Answer 4 · 2011-04-29T18:47:40+00:00

and yes coach is not a member.also if you have time take a look at this question too

http://www.daniweb.com/web-development/databases/database-design/threads/360596

I created a new better ER .take a look

umer ansari 0 Newbie Poster · Answer 5 · 2011-04-30T20:22:10+00:00

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

umer ansari 0 Newbie Poster · Answer 6 · 2011-04-30T20:28:58+00:00

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

silvercats 10 Junior Poster · Answer 7 · 2011-04-30T22:05:06+00:00

did you see my ERD in http://www.daniweb.com/web-development/databases/database-design/threads/360596?

I have no Idea where to put sports detail .name table - [(f.k)Member ID,(f.k)sport ID,(f.k)coach Id] table.....ny idea?
thanks

umer ansari 0 Newbie Poster · Answer 8 · 2011-04-30T22:14:01+00:00

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

umer ansari 0 Newbie Poster · Answer 9 · 2011-04-30T22:18:08+00:00

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