Database & SQL

Moderators: None (Apply to moderate this forum)
Number of threads: 1174
Number of posts: 2221

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Re: Third Normal Form ERD Posted by Devoquality on 17 Apr 2012 at 3:16 PM
Before i start telling you what to do there are one or two things you should take a look at. Like, according to rules table names should be singular. so it would be 'competition' and not 'competitions' etc. . .

You are going to have to make a composite table between people and competitions (this is just another table between the two). Usually the easiest way to name it will be taking the two names of the two many to many relational tables and calling it that. So, for instance you could call it 'person competition'. then you will therefore have a one to many relationship from person to person competition, (ID will therefore become a FK in this new table). and then you will also have a one to many relationship from competitions to person competition and therefore this new table will also have competitionID in it.

This will solve your problem, as the new table will show the competitionID and the person(ID) that takes part in that particular competition.

I dont know what your case study says but unless it says a competition has only one sponsor and a sponsor can sponsor many competitions, then usually a competition can have many sponsors. So you would have a composite table betweeen these two aswell.

Looking at the date you posted this, i guess my reply is a bit late. . .
Thread Tree
Lynce Third Normal Form ERD on 23 Feb 2012 at 1:59 PM
Devoquality Re: Third Normal Form ERD on 17 Apr 2012 at 3:03 PM
Devoquality Re: Third Normal Form ERD on 17 Apr 2012 at 3:06 PM
Devoquality Re: Third Normal Form ERD on 17 Apr 2012 at 3:07 PM
Devoquality Re: Third Normal Form ERD on 17 Apr 2012 at 3:16 PM



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.