You searched for the word(s): 5
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, ...
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 ...
Hi Andy et al,
I think this is what you wanted?
CREATE SCHEMA "Exists"
CREATE TABLE "Exists".Claimant
claimantId INTEGER IDENTITY (1, 1) NOT NULL,
federalAgencyId INTEGER IDENTITY (1, 1),
homeCountry NATIONAL ...
I have responded in-line, like
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 ...
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 ...
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 ...
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 ...
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.
Note: Click on the diagram to see the right hand side.
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 ...
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 ...