Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Modeling opinion? Help?

Re: Data Modeling opinion? Help?

From: Yosi Greenfield <yosi_at_comhill.com>
Date: Thu, 26 Jul 2001 21:07:39 -0700
Message-ID: <F001.00356C70.20010726212024@fatcity.com>

Chris,

It sounds like the client feels that the Business Mailer is simply a customer, albeit a customer with special needs, and therefore special fields.

In your summary, you wrote:

    Aside from the average consumer, a Business Mailer(BM) can     also file a claim. The BM has a special agreement with the client and gets     special treatment when filing claims, and therefore a Business Mailer     profile is created.

... which actually sounds also like the BM is simply a customer. So I can hear their point of view.

Then again, as you point out, the BM is not actually a customer tied to a claim, like most customers, he's a repeat customer. And that sounds like a whole different logical beast, a different logical entity.

So, from here, I find it's hard to tell if the BM is simply another customer or a new beast entirely. This would seem to me to be the crux of the problem. So they want to define their relationship with their client, the BM. My gut then says let 'em. It's possible to accomodate a 'customer type' in a customer table, so think of BM as an extremely limited way to handle customer type.

(I know that's not how one would implement customer type, but they've
decided they ONLY allow two customer types, I think I can deal with that.)

What I don't know is do you feel there are already existing specific functions or reports that their spec won't be able to handle? If there are, then I go back

leaning towards your design, otherwise I'd let them define their relationship with the BM.

(Now my KIDS' relationship with THEIR bm, that's a whole different story!)

My2c fwiw. Good luck in general, and in getting out before their model falls apart in particular,

Yosi



Yosi Greenfield
Oracle Certified DBA
ygreenfield_at_compuserve.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jul 26 2001 - 23:07:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US