The Database Design Resource Center

My Fault

When designing my first several databases, I asked the client if any field, item or bit of information about the data in the table was ever going to be unique, unchanging and always populated.

In my youthful foolishness, I believed these heads of industry when they said SSNs, Account Numbers, License numbers. I believed any silly thing that came out of their mouths was actually TRUE.

So you guys (others at this site) have been going in and cleaning up behind me if I didn't stay long enough. Sorry. If I did stay long enough, I found that EVERY SINGLE TIME THEY WERE WRONG. SSNs can be and are reused. People even STEAL them. Some people do not have SSNs. Every single account number, license number, etc. HAS AN EXCEPTION.

So, if I have learned anything, non-database programmers have absolutely no idea the importance of a primary key in a table.

Put one in every table (that holds anything interesting) as a mater of habit. It will save your butt in the long run.

Comments for My Fault

Average Rating starstarstarstarstar

Click here to add your own comments

Oct 02, 2015
Good post NEW
by: Mireya McDermott

You have a great site!
I really would like to place some ads on your site, is it possible? My site is Find Costume Ideas and I think your blog is an ideal place for adveritising.
Please, answer me and we'll discuss all details, I will pay nice money and really want to be on yout site!

Many thanks for answering!

Aug 07, 2015
Education NEW
by: Anonymous

Education gives us the duty of respecting and taking care of our elders in their old age. Education through makes us humble by telling us that one day or the other day we will be old like them.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Worst Database Design Experience.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.