On Thursday, December 15, 2011 10:17:43 PM UTC-5, JavierQQ wrote: > > > > On Thu, Dec 15, 2011 at 10:15 PM, Anthony <abas...@gmail.com> wrote: > >> Is there a one-to-many relationship here? If so, which is the one and >> which is the many? If not, why not put everything in one table? >> >> Anthony >> >> > Yes there is, > 1 group can have many scales... is it correct the way I'm doing it? >
Yes, in that case, your model is correct. I was confused because you said you want to "validate the existence of only 1 scale per group" -- yet there can be many scales per group. But from your example, it looks like maybe you're trying to ensure that the scale ranges for a given group do not overlap -- is that it?
