On Wed, 2010-02-03 at 23:56 -0200, Jorge Godoy wrote: > You can always normalize and not use an artificial key. > > You'd end up with: > > > measurement (normalization) > =========== > id | value | measurement_unit_id | measurement_type_id > ------------------------------------------------------ > 1 0.23 mm width > 2 0.38 mm width > 2 0.72 mm width How is this different? It looks like you just added some FKs, which don't change the normal form. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general