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

Home -> Community -> Usenet -> c.d.o.server -> Re: merging small tables

Re: merging small tables

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 9 Aug 2002 14:09:09 -0500
Message-ID: <uptwr4r2a.fsf@hotpop.com>


On Mon, 5 Aug 2002, stjepan.brbot_at_zg.hinet.hr wrote:

> Mentioned simplifying of data-model was my first intention. The values
> from this merged table are intended for listboxes or LOVs in my
> application so there is no chance that user can ruin the consistency.

They still are parents to your base tables? ie, act_type_tbl has act_type_id and act_type_desc and the account_tbl has act_type_id in it?

What you can do to not make your actual model hard to show in a graphical tool (like Erwin) is to be very anal about your naming of columns. ie, everything that ends in _typ is a type. Then, if the name of the column is blah_typ, you make sure there is a corresponding table called blah_typ_tbl. Then, if you make sure of this, you don't have to show these type tables in your data-model pictures.

> But maybe I should listen Sy and leave small tables intact because it
> is according to Normal Forms and RDBMS design rules altough there is
> not so much data.

Stay with Normal forms as much as possible.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Fri Aug 09 2002 - 14:09:09 CDT

Original text of this message

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