Relational database structure design question

Posted on 2007-10-08
Last Modified: 2008-02-01
I want to design a relational database to support a dynamic web page for a friend.  The website is about dogs and the database will contain the dog names and all possible competition titles.  I want an end result that allows the user to update the titles (usually multiple titles) a specific dog has earned and then the web page will display the animal's name and all related titles.

I am stuck at having three tables within the DB;
table_DOGS   ---  all dogs breed by breeder
dogs_RegName (PK)
<other fields >

table_TITLES  ---  all possible titles
titles_org (PK)
titles_title (PK)
<other fields >

table_DogTitles  --  

It seems to me I'm creating a many to many situation that I think I don't want.  Is there a better way?
Question by:ITNESPEO
    1 Comment
    LVL 14

    Accepted Solution

    I would actualy suggest an extra table for Breeder ie


    You would then have a "one to many" relationship from breeders to dogs
    a "one to many" relationship from dogs to dogTitlesData
    and a "one to one" relationship from dogtitlesdata to Titles.

    Provided you set your indexes and primary keys this is actually good design.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now