The ORM Foundation

Get the facts!

Search

Page 5 of 6 (60 items) « First ... < Previous 2 3 4 5 6 Next >
  • Re: Modeling based an existence chain

    Yes in this domain you can have all three, or any combination of nulls or country codes.&nbsp; The idea in the domain I&#39;m working off of assumes that its important to have as much data as possible filled out as well as a default value in case no country code was found.&nbsp; So to sumarize, a claimant can be &quot;Investigated by&quot; Federal ...
    Posted to ORM Techniques (Forum) by mnnoon on Wed, May 25 2011
  • Re: Modeling based an existence chain

    I think I&#39;m way over my head on this one.&nbsp; But I can make some basic logical declarations about this particular domain. A Claimant can only have one country code in this domain used to determine living expenses. A Federal Agency object, an organization object, and a Claimant object&nbsp;can either have a country code&nbsp;with a ...
    Posted to ORM Techniques (Forum) by mnnoon on Wed, May 25 2011
  • Re: Modeling based an existence chain

    I&#39;d prefer to use an else statement after the test for null and in my join I also test for empty string &#39;&#39; which I don&#39;t think that represents a null.&nbsp; This seems to be the case where too many table constraints have been relaxed.
    Posted to ORM Techniques (Forum) by mnnoon on Thu, May 19 2011
  • Re: Modeling based an existence chain

    Thanks Clifford, &nbsp;I&#39;m using a join to do the same thing not sure which is better.&nbsp; But in the join I do need to start at the top, and then as I go down to the lower priority organizations I would check to ensure that the spots for&nbsp;the higher priority&nbsp;organizations above are indeed null. &nbsp;Id like to try out that Norma ...
    Posted to ORM Techniques (Forum) by mnnoon on Thu, May 19 2011
  • Re: Modeling based an existence chain

    Thanks for the analysis.&nbsp; What I&#39;d like is for these constraints to be built into the model as constraints without having to build a matrix of each claimant[claimantid], [fedagency country code], [org country code], [claimant country code], [cost of living]1, null, af, us, 41.502, null, us, af, 55.003, null, fr, us, 45.504, us, us, af, ...
    Posted to ORM Techniques (Forum) by mnnoon on Thu, May 19 2011
  • Re: Modeling based an existence chain

    Hi Andy et al,&nbsp; I think this is what you wanted?&nbsp; CREATE SCHEMA &quot;Exists&quot; GO CREATE TABLE &quot;Exists&quot;.Claimant ( &nbsp;claimantId INTEGER IDENTITY (1, 1) NOT NULL, &nbsp;hasUnlistedWorkHistory BIT, &nbsp;federalAgencyId INTEGER IDENTITY (1, 1), &nbsp;publicOrganizationId INTEGER, &nbsp;homeCountry NATIONAL ...
    Posted to ORM Techniques (Forum) by mnnoon on Thu, May 19 2011
  • Re: Modeling based an existence chain

    Thanks.&nbsp; I&#39;m trying to use various identifiers to&nbsp;clearly define my schema. &nbsp;As far as this intermediate table it is an agreement that is pre-determined, but the order of presidence dictates that the existence of certain pieces takes presidence over other pieces regardless of wether they exist or not.&nbsp; So I&#39;m tryingt ...
    Posted to ORM Techniques (Forum) by mnnoon on Sun, May 15 2011
  • Re: Modeling based an existence chain

    Yes that seems to reflect accurately the way I currently&nbsp;want to design the database, thanks.&nbsp;&nbsp; The current model can have all three cases b/c the more info the better as well as nulls, I only put the exclusive or b/c I wanted to relay the importance of the existence of the first case as the most important, then the next importance ...
    Posted to ORM Techniques (Forum) by mnnoon on Sun, May 15 2011
  • Re: Modeling based an existence chain

    &nbsp;I forgot to add the country to the Cost of Living table.&nbsp; But this is basically what I&#39;m trying to do find the cost of living based the country code.&nbsp; The Federal Agency takes, presidence, then comes the Public Organization(charity) then the Claimant&#39;s Country code is last.&nbsp; I&#39;m using this as&nbsp;a watered down ...
    Posted to ORM Techniques (Forum) by mnnoon on Sat, May 14 2011
  • Modeling based an existence chain

    Hi, I am running into a problem modeling a table that covers where a county code exists or not in 5 different situations where a penalty is applied based on what the first in the chain country is not null and is mapped correctly.&nbsp; I want to remodel the database but keep the business logic clearly defined in one or more tables and am looking ...
    Posted to ORM Techniques (Forum) by mnnoon on Wed, May 11 2011
Page 5 of 6 (60 items) « First ... < Previous 2 3 4 5 6 Next >
© 2008-2020 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service