Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: merging small tables
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