If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
table design
I am having problem with a table design. The table is for
Quality measures. A couple of the attributes for the Quality measures table are the Company name and Group name. Each Company can have multiple groups but a group only belongs to one particular company so that's a one to many relationship that exists for the Group table. The problem is that while a Quality Measure belongs to a particulare Company, some of the Measures don't belong to a Group. So I am worried about queries, that if pulled from the group table, would be result in inaccuraties. |
#2
|
|||
|
|||
" wrote in
: The problem is that while a Quality Measure belongs to a particulare Company, some of the Measures don't belong to a Group. You need to be much, much, clearer in your own mind before trying to model this. "Belongs to" can be a very specific type of relationship or a general portmanteau word that covers lots of different things. So, what _exactly_ is the relationship between Measures and Companies: the company PaidFor it, or OwnsCopyright to it; or is the the SubjectOf or the CarrierOutOf it? And, separately, what is the nature of the relationship(s) between the Measure and the Group. One is clearly this: The Group to which belongs the Company that (Whatever)ed the Measure. but you obviously have some extra kind of relationship in mind. What about The Group that Commissioned the Measure The Group that was InChargeAtTheTime of the Measure The Group that will be ResponsibleForCorrecting the Measure and so on. Once you have described precisely what you are modelling, the rest is easy! Just call the relationship (or the FK, if it's a one-to- many) after the natural English word or phrase. Hope that helps Tim F |
#3
|
|||
|
|||
very true. thanks for the help. Two of the measures can
apply to a group within a company and or the company as a whole. This is making strict classification difficult. See what I mean? -----Original Message----- " wrote in : The problem is that while a Quality Measure belongs to a particulare Company, some of the Measures don't belong to a Group. You need to be much, much, clearer in your own mind before trying to model this. "Belongs to" can be a very specific type of relationship or a general portmanteau word that covers lots of different things. So, what _exactly_ is the relationship between Measures and Companies: the company PaidFor it, or OwnsCopyright to it; or is the the SubjectOf or the CarrierOutOf it? And, separately, what is the nature of the relationship (s) between the Measure and the Group. One is clearly this: The Group to which belongs the Company that (Whatever) ed the Measure. but you obviously have some extra kind of relationship in mind. What about The Group that Commissioned the Measure The Group that was InChargeAtTheTime of the Measure The Group that will be ResponsibleForCorrecting the Measure and so on. Once you have described precisely what you are modelling, the rest is easy! Just call the relationship (or the FK, if it's a one-to- many) after the natural English word or phrase. Hope that helps Tim F . |
#4
|
|||
|
|||
wrote in news:107c01c5064c$61b4fee0
: Two of the measures can apply to a group within a company and or the company as a whole. This is making strict classification difficult. See what I mean? Not really. If you have different types of measures that relate in different ways to other entities, then you may in fact be looking at more than one table of QualityMeasures. Try googling for SubTyping methods in relational database design. All the best Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Need help w/ table design | Tom | Database Design | 0 | August 12th, 2004 02:34 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |