Re: Single Code Table or Separate Code tables dilemma

• Original Message -----

> at last i convinced my duhvelopers to go for individual tables.

Probably they were just unaware of how much code they would have to write. DUHelopers are easy to convince - they just have no brain. Developers have. :-))

> > -----Original Message-----
> > From: Steve Orr [mailto:sorr_at_arzoo.com]
> > Sent: Thursday, March 22, 2001 5:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Single Code Table or Separate Code tables dilemma
> >
> >
> > Regarding "lookup" or validation tables and more complex
> > "rules" tables...
> > do they ALL go into your master code table? For instance,
> > what about a "code
> > table" for all valid U.S. zip codes? Do they go into your
> > master code table?
>
> we r in the process for defining country--->state/province--->city and
> airports tables. there would be another 30-40 masters and all in different
> tables :-) sweet smell of victory

:-) In this case you have dependencies. I would create multiple tables there.

> > State abbreviations too? What about valid city/state/zip code
> > combinations
> > which you can get from the U.S.P.O.? At what point are
> > validation/lookup/rules data not in the master code table and
> > how do you
> > decide?
>
> i blive every logical entity should hv its seperate physical presence.

I think if logical entities differ from each other only a couple of attributes, they should go into one table.

> but then every solution is an "Engineering Compromise". So i wont mind some
> give and take. but its fun to have an occasional fight with a duhveloper.

Yeah, a duhveloper might consider it's fun to write 10 packages which differ only by name and a couple attributes.
Later he might claim that he wrote 10K lines of code ( instead of 1K ) and worked hard. :-)

Regards,
Michael Netrusov
www.atelo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Netrusov
  INET: mn_at_g-fax.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).