Jump to content


Photo

newbie database design question


  • Please log in to reply
1 reply to this topic

#1 workingdog

workingdog
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 02 August 2003 - 03:05 PM

I\'m buildling a database of vineyard properties in Sonoma County and I am unsure as to how to build some \"sets\" of values. Each property can be in one or more appellations, grow one or more grape varieties and have one of several classifications.

I was going to build each of these as a table, then I can add new appellations, grape varieties or classifications as they appear without altering the database.

But in all the books I bought, there are no examples of creating the one to many relation I want to make between the \"properties\" table and the \"appellation\" and \"variety\" tables. And I am wondering what the queries are going too look like.

Help?

Peter Young

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 02 August 2003 - 07:51 PM

Each property can have many appellations and each appellation can apply to many properties. Same goes for grape varieties

In these cases you need linking tables to provide many to many relationships. Only one classification is required so classification_id can be held in property table with link to classification table.

Can\'t see a way to do attachments in this forum so I\'ll email diagram
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users