Feb 282014
 
alter  /* unnormalized */ table 
    is_still_unnormalized_after add ( 
  surrogate_key_id integer primary key,
  to_it            varchar2(1)
);

Normalization is to do with the dependencies between the (business) attributes. As surrogate keys are additional system generated identifiers, they do nothing to change the dependencies between the original attributes!

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>