Apr 082013
 
select benefit
from   normalisation
where  benefit not in (
    'Preventing update anomalies',
    'Ensuring uniqueness of rows',
    'Supporting (unknown) ad-hoc SQL queries',
    'Allowing extensions to the data model',
    'Representing entity relations',
    'Improving consistency by avoiding redundancy'
);

no rows selected

Apart from all that, there's no benefits right?! ;) I'm sure there's more than those listed; 
if you've got any to add just put them in the comments and I'll update the post
If you enjoyed this article, Get email updates (It’s Free)

  2 Responses to “What has normalization ever done for us?”

  1. Improving consistency by avoiding redundancy

    • Indeed; avoiding redundancy is something normalization helps significantly with. Post updated!

 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>