The ORM Foundation

Get the facts!

Search

You searched for the word(s): 5
Page 94 of 311 (3108 items) « First ... < Previous 92 93 94 95 96 Next > ... Last »
  • Re: Modeling based an existence chain

    Thanks for the analysis.  What I'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 05-19-2011
  • Re: Modeling based an existence chain

    Hi Marc, This is, if I'm not mistaken, a DDL script based on the ORM diagram I posted. I was looking, rather, for some indication of what is the schema that you're trying to write your constraint for, in SQL. But maybe I should make sure of this question first: Are you planning to re-do a current relational schema (to make it ...
    Posted to ORM Techniques (Forum) by Andy Carver on 05-19-2011
  • Re: Modeling based an existence chain

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

    Hi Marc, I have responded in-line, like  >> this [quote user="mnnoon"] Yes that seems to reflect accurately the way I currently want to design the database, thanks.   >> Good, now we can go ahead and address finer details (e.g. see below). ... I'm not sure how you added those light blue ...
    Posted to ORM Techniques (Forum) by Andy Carver on 05-15-2011
  • Re: Modeling based an existence chain

    Thanks.  I'm trying to use various identifiers to clearly define my schema.  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.  So I'm tryingt ...
    Posted to ORM Techniques (Forum) by mnnoon on 05-15-2011
  • Re: Modeling based an existence chain

    Yes that seems to reflect accurately the way I currently want to design the database, thanks.   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 05-15-2011
  • Re: Modeling based an existence chain

    Hi Marc,  Does the below seem to reflect accurately the fact types and business logic in view in the domain (of your "watered-down example")?   I gather that the actual, existing database has a "CostOfLiving" table. This seems like something that needs correcting, rather than reflecting accurately the fact types of ...
    Posted to ORM Techniques (Forum) by Andy Carver on 05-14-2011
  • Re: Modeling based an existence chain

    It seems to me that it might be easier for you to define some atomic facts and then expand as required. The following model illustrates this approach. Also, it's not good practice to use ".id" as a reference mode for every object. My model shows some alternatives. Ken Note: Click on the diagram to see the right hand side.
    Posted to ORM Techniques (Forum) by Ken Evans on 05-14-2011
  • Re: Modeling based an existence chain

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

    Marc, Your description is not very clear. I can think of a couple of different things you might mean though, so I'll try to answer based on that. If I'm mistaken, please clarify and we'll have another go. One possibility is that you have a record which has a single country code, but the source or provenance or authority which ...
    Posted to ORM Techniques (Forum) by Anonymous on 05-12-2011
Page 94 of 311 (3108 items) « First ... < Previous 92 93 94 95 96 Next > ... Last »
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service