workingdog Posted August 2, 2003 Share Posted August 2, 2003 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted August 2, 2003 Share Posted August 2, 2003 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.